Viewing 15 posts - 9,886 through 9,900 (of 22,224 total)
You can even create filtered statistics in a similar fashion to help the optimizer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 24, 2013 at 8:40 am
As long as they are calling procedures or creating parameterized queries, not really. It might tend to bloat the cache a little depending on how the calls are generated since...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 24, 2013 at 4:42 am
WayneS (4/18/2013)
Grant Fritchey (4/18/2013)
Late to the game, but well done Jason & Wayne.Thanks Grant.
BTW... are you the next MCM from the SSC group?
Ha! Doubtful. That requires actual brains & skills....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2013 at 4:47 am
dbursey (4/18/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2013 at 4:44 am
Late to the game, but well done Jason & Wayne.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 18, 2013 at 6:08 am
You can query the execution plan from the plan cache. The execution plan will show how the query was resolved and will include if indexes were referenced at all and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2013 at 7:15 am
Yeah, it's a server level setting.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2013 at 7:07 am
Congratulations on your first article. Nice work.
For the future, a few suggestions that might help. Doing a how-to article like this is great. But you also need to include guidance...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2013 at 5:39 am
Any of the Threadizens going to be in Vegas for SQL Intersection this week?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2013 at 6:47 am
For larger data sets, I'd work on getting rid of that DISTINCT operator. It's going to lead to issues because of the aggregation. But, leaving everything roughly the same, I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 7, 2013 at 5:38 am
What kind of database server are you connecting to? If it's a 2000 box, or a database set to 2000 compatibility on a 2005 or 2008 box, then you won't...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2013 at 3:41 am
I'd suggest using the scripting wizard or right-clicking on individual objects as well. That generates the script you need and then you can run them on multiple different machines.
But, if...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2013 at 3:37 am
Since you're running SQL Server 2008, you can get the deadlock information out of the system_health extended event session without ever setting a traceflag. Here's an introduction to the system_health...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2013 at 3:33 am
You can contact support. But for premier level support, it's as we've both said. You have it through your MSDN license or you pay for it. That's just how it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 5, 2013 at 3:30 pm
You can contact support. But for premier level support, it's as we've both said. You have it through your MSDN license or you pay for it. That's just how it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 5, 2013 at 3:27 pm
Viewing 15 posts - 9,886 through 9,900 (of 22,224 total)