Viewing 15 posts - 13,981 through 13,995 (of 22,232 total)
CirquedeSQLeil (11/2/2010)
GilaMonster (11/2/2010)
Grant Fritchey (11/2/2010)
"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
November 2, 2010 at 1:03 pm
GilaMonster (11/2/2010)
Grant Fritchey (11/2/2010)
"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
November 2, 2010 at 1:01 pm
Jeff Moden (11/2/2010)
Grant Fritchey (11/2/2010)
"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
November 2, 2010 at 11:07 am
Fixed it on the post.
"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
November 2, 2010 at 9:41 am
Alvin Ramard (11/2/2010)
Grant Fritchey (11/2/2010)
"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
November 2, 2010 at 8:38 am
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories...
"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
November 2, 2010 at 8:24 am
I agree. Every US citizen should go and vote.
And everyone should go and vote.
And then go and vote again[/url].
Specifically, support our local Gila[/url] Monster[/url] or PowerShell FTW[/url].
"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
November 2, 2010 at 8:13 am
Nelson Williams-487553 (11/2/2010)
I think...
"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
November 2, 2010 at 8:08 am
Ninja's_RGR'us (11/2/2010)
Grant Fritchey (11/2/2010)
"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
November 2, 2010 at 6:48 am
Yep, what he said. Generally the size of the data stored will define, in pretty close approximation, the size of the database. You can get the size a number of...
"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
November 2, 2010 at 6:10 am
I'd have to see the execution plans for both queries before I could hazard a guess. It might be that adding the index caused the query to recompile. It might...
"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
November 1, 2010 at 6:57 pm
vgv8 (11/1/2010)
From this citation I can understand that Full CL-IX (Clustered Index)...
"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
November 1, 2010 at 11:40 am
GilaMonster (10/31/2010)
Just noticed that I missed spotting a milestone. Better (a little) late than never
Congrats. You worked hard for 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
November 1, 2010 at 5:36 am
GilaMonster (10/30/2010)
Grant Fritchey (10/30/2010)
The default trace does not store data manipulation calls. In order to track those you'll have to create your own server side trace.
Or put triggers on the...
"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
October 30, 2010 at 11:44 am
The default trace does not store data manipulation calls. In order to track those you'll have to create your own server side trace.
"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
October 30, 2010 at 10:21 am
Viewing 15 posts - 13,981 through 13,995 (of 22,232 total)