Viewing 15 posts - 8,266 through 8,280 (of 22,214 total)
I think Chris has a real improvement there, but we're just guessing. Without seeing the execution plan, I'm not sure why your original query is running slow.
May 3, 2014 at 4:33 am
Regardless of the exact definition of Midwest states, I'm extremely adverse to nesting views within views, or functions within views or functions within functions.
I recognize that creating a view means...
May 3, 2014 at 4:29 am
Sounds like it's probably blocking from other resources accessing the table. Otherwise, it shouldn't take that long at all.
May 3, 2014 at 4:24 am
I'd use Jonathan's query to find the plans.
Also, yours only includes procedures. It doesn't include ad hoc queries. You'd need to hit sys.dm_exec_query_stats for that.
May 3, 2014 at 4:21 am
The core setup for a 2014 server isn't going to be any different than for a 2008 server. After that, it completely depends on if you're using functionality that wasn't...
May 3, 2014 at 4:14 am
sqlvogel (5/2/2014)
Bill Talada (4/30/2014)
The number one rule of a primary key is that it must be "meaningless" yet unique.
That's your number one rule but definitely not the number one rule....
May 2, 2014 at 5:58 am
But you can check the compile time of the plan by looking at the SELECT operator properties (or the DELETE operator, etc.). 30 minute compiles are abnormal as hell, but...
May 1, 2014 at 5:21 pm
OPTIMIZE FOR UNKOWN is a query hint and must be applied to each individual query. It has to be a part of the text, no options. There is no central...
May 1, 2014 at 9:06 am
I have not tested it, but there's no reason why it won't work just fine. Each instance of SQL Server and each version gets it's own installation.
May 1, 2014 at 9:03 am
hisakimatama (5/1/2014)
Anyone else from The Thread planning to attend this week's SQL Saturday...
May 1, 2014 at 7:55 am
Erin Stellato is here? Where is she?
Ha! Thanks. It's not true, but it's nice to hear.
May 1, 2014 at 7:33 am
Scroll down in the documentation here (down to Remarks). It shows all the causes for the clearing of the cache and procedure cache. I'll bet they're doing one (or more)...
May 1, 2014 at 6:16 am
1) DBA work is usually, by definition, 24/7. It's just the nature of the beast. We're frequently on call to handle emergencies. That said, most of the time, it's a...
May 1, 2014 at 4:59 am
One argument against error handling in T-SQL is that there is already error handling in the calling application. To which I'll respond that there are unique error events within SQL...
May 1, 2014 at 4:54 am
I'm not sure Grant Fritchey knows the answer to this. Is it a home-grown shipping process? I don't think the normal one flushes the cache.
May 1, 2014 at 4:51 am
Viewing 15 posts - 8,266 through 8,280 (of 22,214 total)