Viewing 15 posts - 13,861 through 13,875 (of 22,224 total)
PAH-440118 (12/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
December 2, 2010 at 6:08 am
The one place where I consider using table variables is when I'm having issues with excessive, or long running, recompiles on a query. In that instance, I might choose 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
December 1, 2010 at 6:10 pm
GilaMonster (12/1/2010)
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent developers)
The Chief Enterprise...
"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
December 1, 2010 at 6:48 am
joerg.kannengiesser (12/1/2010)
maybe it's a bug in 2005R1 - I will check this again after installation of SP3.
Does anyone know if there's a...
"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
December 1, 2010 at 6:24 am
The thing to remember is, despite it's unfortunate name, TIMESTAMP has nothing whatsoever to do with time. It's simply an incrementing number that is automatically updated each time a row...
"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
December 1, 2010 at 5:44 am
I'm sorry, I don't understand the order that you're trying to achieve. It doesn't look like you're ordering by managerid or by employee id. Are you trying to retrieve 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
December 1, 2010 at 5:42 am
For what it's worth, foreign keys, constraints, statistics, and indexes can all affect the execution plan, so simply pointing at a query and asking which table is accessed first can'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
December 1, 2010 at 5:32 am
WayneS (11/30/2010)
To all the Threadizens that have presented - how have you incorporated this public speaking into your resume? Examples would be great!
Oooh, good question. I haven't. I have listed...
"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
December 1, 2010 at 5:17 am
Kit G (11/30/2010)
Grant Fritchey (11/30/2010)
Jeff Moden (11/30/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 30, 2010 at 7:42 am
This is piling on, but I agree with Gail & Lowell. I've had the situation where certain tables (badly designed tables I might add) needed stats updated hourly, with a...
"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 30, 2010 at 7:40 am
It sounds like the regressions I've heard from other people. In general, SQL Server 2005 and 2008 are much better with execution plans, etc, than 2000. But, there were some...
"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 30, 2010 at 7:35 am
Basically you install the management pack and you're off & running. But, you'll need to adjust the alert levels, etc., for your system. You'll also want to review the counters...
"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 30, 2010 at 7:33 am
Jeff Moden (11/30/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 30, 2010 at 6:48 am
deva21v (11/29/2010)
Since i can't use this dmv's for following reason1) When sql server services stop data in dmv will be cleared
Yes, but how often is that occurring? In production...
"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 30, 2010 at 6:07 am
Not only is it running on SQL Server, but you can watch the monitoring on the system, live, from here[/url]. Check out how well it operates and see Red Gate's...
"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 29, 2010 at 1:18 pm
Viewing 15 posts - 13,861 through 13,875 (of 22,224 total)