Viewing 15 posts - 9,886 through 9,900 (of 22,219 total)
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
Looking at os_wait_stats is looking at waits aggregated. There's no way to know if those waits correspond to problems during your restore. That's why I suggested looking at sys.dm_exec_requests. That...
"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 1:10 pm
rodjkidd (4/5/2013)
Steve Jones - SSC Editor (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!
I'm in Castle Marina...
"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 8:41 am
ChrisM@Work (4/5/2013)
Grant Fritchey (4/5/2013)
ChrisM@Work (4/5/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 5, 2013 at 7:55 am
ChrisM@Work (4/5/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 5, 2013 at 7:05 am
To get to premier support, yeah, you've got to cough up cash. If you have a very well documented bug, you can try posting it to the Connect web site....
"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 5:11 am
Viewing 15 posts - 9,886 through 9,900 (of 22,219 total)