@PaulWhite Yes, but usually 15 hours after everyone else has.
@Phil I thought I could make something of it while using a hand-held. Unfortunately awetoekerrekt, genalised UI madness and small children got in the way. Unwilling to loose what (little) I'd achieved I saved the changes. Hopefully I didn't deviate too far from the OP's intentions.
@Phil I've got (second hand) a bottle of chili sauce from a datacenter company we work with. Had to realize that my family is not that fond of spicyness, so offered it to a colleague. He asked what was in it - 40% red pepper and 8% dried bhut joloki. Hearing this, he said 'That's poison! Yes, I want it!'
pivot has 131 questions and crosstab has 12.
Is there any important difference between the two from a tagging perspective?
If yes, please add your reasoning to the 'yes' CW answer below.
You can use Dynamic SQL and the sys.triggers DMV to build query that you can execute.
is_ms_shipped excludes any triggers that were shipped with SQL Server.
parent_class_desc filters for object level triggers, rather than database level.
Change the PRINT to an EXEC once you are happy with the o...
This hash is only slightly slower than the fast one (well, about double the time, but it's only 50 ms). The real difference shows itself in the Hash Right Join node - also, one smallint in the 10+ column list cannot cause such a big change, in my view. — dezso37 secs ago
Howdy folks. Odd question: would it be crazy of me to move sp_Blitz/sp_BlitzIndex/sp_BlitzCache/etc support questions over to Stack? We're using Uservoice, and I hate it.
I work for a small software start-up and I love Stack Overflow. Is it acceptable to encourage our customers to post questions on Stack Overflow so we can answer them there and also let the community benefit from it?
Would customers shy away from the fact that it is too public?
@BrentOzar Could I also humbly and politely ask you to check with the community on meta before creating new tags like sp_blitz and sp_blitzindex, especially if you're planning a mass retagging exercise. Also: what the CM said :)
@BrentOzar Sure, I just remember Ola's tag was burned though I don't recall the exact circumstances. Seems like something the community might want to express an opinion about. Also I like making work for you.
Yeah, I don't wanna do a tweet or an email to the list and say, "Head over here now to ask a question!" I'm trying to be more careful these days about using my megaphones.
@BrentOzar Oh I'm sure we'd welcome the extra visitors, I just meant to limit the rate of retagging (home page bumps). Don't forget to add/suggest an excerpt and wiki for those tags when you get a moment.
Yeah, I really want sp_Blitz output to email - specifically, the differences from the last run.
It's gonna require me writing the results to history in a database, and doing a diff between passes, and then getting that out via database mail. It seems doable. Then just like set it up in a weekly Agent job.
We wanted that really bad, and the sp_Blitz app we had a while back was supposed to be the first step down that road. We hit a small roadblock though. It was called "user tech support."
Howdy folks. Odd question: would it be crazy of me to move sp_Blitz/sp_BlitzIndex/sp_BlitzCache/etc support questions over to Stack? We're using Uservoice, and I hate it.
I know @bluefeet posted an SO link, which seemed pretty helpful, but it can't hurt to find out how the local regulars feel about it as well.
@PaulWhite Thanks! We didn't do a public round of hiring this time. When we decided to buy Jeremiah & Kendra out of the company, I knew I had to backfill a couple of spots fast, so I contacted Tara because we'd talked to her in the past.
I do love it when we do public hiring rounds - that's by far my favorite way to do it - but I just had the chance to get Tara, and I couldn't pass that up. She's awesome.
One of these days, we'll earn enough to hire you. I gotta get my Gold Bar Generating Script to work right though. Still some debugging to do on that one.
we are recently Migrated our DB from 2008R2 Enterprise to 2014 Enterprise.on new server,I am having 2 sockets,20 cores and 40 processors(768 RAM ,windows 2012R2) with SQL Server 2014 Enterprise.there is no performance Improvement. just 10-11% CPU being using and memory 46% is using.please help m...
This comment appears to me to be pure speculation.
With slow performance while both CPU and RAM use are low my first suspicion would be that you have a write-heavy workload and disk/network IO is a bottleneck. It could also be that it is CPU-busy but with few concurrent tasks that aren't paralisable (so the 10% could be 4 cores pegged and the rest idle because the problem isn't paralisable) Without much more detail we can't really help further than that. — David Spillett1 min ago
I have a problem with a massive amount of INSERTs that are blocking my SELECT operations.
Schema
I have a table like this:
CREATE TABLE [InverterData](
[InverterID] [bigint] NOT NULL,
[TimeStamp] [datetime] NOT NULL,
[ValueA] [decimal](18, 2) NULL,
[ValueB] [decimal](18, 2)...
@YperSillyCubeᵀᴹ the "Blocking Text" column contains the definition of the stored proc; what is actually "executing" is the statements inside the stored proc.
some of the columns that are not shown in the output contain the starting and ending offset of the actual statement within the stored proc being executed.
@BrentOzar FYI meta.dba.stackexchange.com/q/2423/72091 I appreciate the great work you do and that you've decided to share the scripts your consulting company creates. I'm not trying to call you to task, I'm just curious about the policy to see if I should do the same thing moving forward. Either way I want to make sure you are aware of the post in case you want to respond.
Howdy folks. Odd question: would it be crazy of me to move sp_Blitz/sp_BlitzIndex/sp_BlitzCache/etc support questions over to Stack? We're using Uservoice, and I hate it.
I've noticed a recent retagging/tag creation push where Brent Ozar added tags to questions about scripts released/maintained by his consulting company. Is this appropriate behavior? If so should we retag/create tags for Ola's scripts and so on for various GitHub repositories/collections?
To be c...
So you're looking at an aggregation but you don't know ahead of time what they'll be looking to aggregate over time-wise, yeah?
If so, that's what non-clustered columnstore index is designed for. Makes it the awesomesauce for rando-aggregation queries
Then from a usage perspective, I do whatever is easier on the caller. If they like views so they can suck it into Excel, so be it. They write some thing where they actually used procedures, have some of those
@billinkc kinda. it's pre-aggregated historical data. what's unknown is which slice of the aggregate the user will want at any given time
they may want the aggregate for feb 29th ... they may want the aggregate for april 1, the aggregate for all of june, or the aggregate for the 3rd of every month.
a view makes sense to me ... but just want to make sure i'm not doing something naughty
You've got your data down to whatever the granularity is, probably daily. The users won't be constrained into actually telling you what they want to do with the data, likely because they really don't know what they want. Meanwhile, if you try and provide some preaggregrations assuming they'll look at every third Friday and monthly totals, you miss that We obviously need the 4 Wednesday of prime months requirement
So, again my battles, the best you can do is make the data as snappy as possible and then work with them to understand how they want to consume it and then get out of the way.
I have a new data source sitting on a SQL Express instance on a VM in Azure that is VPNed back into the local network. I can RDP into the server, open SSMS and access the database. But I can't access it from a different Azure VM on the same network.
I just installed SQL Server Express 2012 on my home server. I'm trying to connect to it from Visual Studio 2012 from my desktop PC, and repeatedly getting the well-known error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was...
@PaulWhite - I cannot seem to locate anything in either chat or meta about the script-name-here tag issue, where it was decided to burminate the ola tag. I'd love to re-read it.
Thanks, @swasheck. I usually have people to do this stuff for me, some time to go google a guide to walk me through all the steps since I do this about once a year max. Instead I inherited a random server that developers frantically stood up and we needed to get access to RIGHT NOW.
Next thing to tackle: They have a dbo.Users table with plain text username, email, password, full name.
@TomV one of two things. Either it's accepted, just like the support we offer for PostgreSQL, MySQL, and SQL Server, etc; or it's not supported by us and the vendor goes somewhere else.
This question has been merged, and as a result cannot be directly "edited".
I'd like to remove the books tag from the question since that tag needs to go away. In my opinion, that tag would be very similar to databases; it is of limited value and doesn't help define the question. From help:
...
@MaxVernon Yeah I agree. Asking questions about specific DB products an using them makes sense. It's when people just sales pitch their product that I get touchy.
With SQL Server 2008R2, we have analysis services, reporting services, and data moving and manipulation services with SQL Server Management Studio. So why do we need SSIS, SSRS, and SSAS?
Are questions about the following considered off-topic?
How do I get certified for [xyz]
What are the necessary course requirements to become an [xyz]
How to validate and upgrade my knowledge of [xyz] with [abc]
If these types of questions are "off-topic", should we create tag wikis for certi...
this is a more abstract question. number of rows is N, queries depend on the approach, output: list of anything. cars in the example above. — mojovski10 hours ago
good luck getting an answer with it being that abstract.
@swasheck Ok, well let me try again then: yes I have experienced it, but then I work with a lot of betas and pre-releases, so I can't be sure it's ever happened to me in a release version.
@bluefeet He's everywhere at all times, like he-who-shall-not-be-named