Viewing 15 posts - 9,751 through 9,765 (of 22,219 total)
Short answer, yeah, the files will be available. Longer answer, go here to get Microsoft's word on how this works.
"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
June 14, 2013 at 2:43 am
Yeah, I'm with everyone else. Really sounds like query tuning needs to happen immediately. Sometimes throwing hardware at a problem doesn't make it better. In addition to Gail's articles, check...
"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
June 14, 2013 at 2:41 am
You don't need to see the actual plan to see if it's doing a parallel execution. You can pull the plan out of cache for the query, while it's running....
"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
June 14, 2013 at 2:39 am
Since you're on SQL Server 2008, you don't actually have to rely on the traceflags any more. The system_health extended event session will record deadlock graphs that will allow you...
"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
June 14, 2013 at 2:34 am
You might try using a derived table and getting TOP 1 with an ORDER BY to get the latest version instead of the > operator. Something like the code 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
June 14, 2013 at 2:32 am
SQLRNNR (6/13/2013)
You guys have a "widget" on your blog that allows the display of certain icons or badges (e.g. MVP...
"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
June 14, 2013 at 1:13 am
Stefan Krzywicki (6/13/2013)
Grant Fritchey (6/13/2013)
Stefan Krzywicki (6/13/2013)
The Dixie Flatline (6/13/2013)
Sean Lange (6/13/2013)
Steve Jones - SSC Editor (6/13/2013)
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/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
June 13, 2013 at 10:06 am
Stefan Krzywicki (6/13/2013)
The Dixie Flatline (6/13/2013)
Sean Lange (6/13/2013)
Steve Jones - SSC Editor (6/13/2013)
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/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
June 13, 2013 at 9:33 am
Gary Varga (6/11/2013)
chrisn-585491 (6/11/2013)
I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by...
"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
June 11, 2013 at 11:38 am
Gary Varga (6/11/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
June 11, 2013 at 7:47 am
Eric M Russell (6/10/2013)
Oh, those of us who just finished our 2012 certifications are looking forward to this.
And I only finished updating three different books last year. I get to...
"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
June 10, 2013 at 10:37 am
jcrawf02 (6/10/2013)
Grant Fritchey (6/10/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
June 10, 2013 at 10:36 am
After visiting TechEd, I'm more and more convinced, the damn is going to break and we'll see tons of people using Azure, or, Microsoft is going to fold up 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
June 10, 2013 at 3:54 am
Brandie Tarvin (6/3/2013)
I've never found a reason to use it or a need that made sense, so I'd love to hear...
"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
June 3, 2013 at 2:38 pm
Jack Corbett (5/31/2013)
Jack Corbett (5/31/2013)
1. I can't stand ORM tools and the queries they create
2. I can't stand...
"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
May 31, 2013 at 3:17 pm
Viewing 15 posts - 9,751 through 9,765 (of 22,219 total)