Viewing 15 posts - 14,401 through 14,415 (of 22,232 total)
After the silly work I had to go through to get this to function, I went ahead and made it into a blog post[/url] if anyone is interested.
"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
September 3, 2010 at 6:55 am
If it's running faster it makes sense. 😉
But seriously, 16ms is hard to argue with, however it might still be possible to tweak it more. I'd try the suggestions offered...
"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
September 2, 2010 at 7:39 am
ramboabc (9/2/2010)
a
b
"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
September 2, 2010 at 7:29 am
Either the interviewer was trying to trap you (possible) or you've just found the first place you can help that business. Yes, deleting logs because "not much, or nothing, has...
"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
September 2, 2010 at 6:47 am
Horatio (9/2/2010)
Just another question, the database server is currently running on Windows Server 2003 Enterprise R2 (x86), with SQL 2008 Standard (x86) with SP1.
Would upgrading the server...
"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
September 2, 2010 at 6:44 am
Just curious why you thought it might matter? Would it matter if the opening paren was on the same line as the column or on a different line? Just wondering...
"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
September 2, 2010 at 6:40 am
Just curious, why would you take a differential immediately after a full? There can be little or no changes between the two.
Basically, if you have a differential that you mean...
"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
September 2, 2010 at 6:29 am
Your estimated & actuals are a bit off, especially at the end of the query. Are your statistics up to date?
The amount of data you're moving seems to be leading...
"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
September 2, 2010 at 6:26 am
Alvin Ramard (9/1/2010)
Lynn Pettis (9/1/2010)
GSquared (9/1/2010)
Must have advanced proficiency and extensive knowledge of web development...
"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
September 1, 2010 at 6:41 pm
Brandie Tarvin (9/1/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
September 1, 2010 at 1:24 pm
CirquedeSQLeil (9/1/2010)
Grant Fritchey (9/1/2010)
GSquared (9/1/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
September 1, 2010 at 12:57 pm
GSquared (9/1/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
September 1, 2010 at 12:23 pm
goksly (9/1/2010)
I do like the idea of a view, but do I have any...
"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
September 1, 2010 at 6:01 am
pankushmehta (8/31/2010)
pankushmehta (8/31/2010)
If your database is in simple recovery mode, you can...
"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
September 1, 2010 at 5:55 am
WayneS (8/31/2010)
CirquedeSQLeil (8/31/2010)
Any chance this thread will breach 20,000 posts by the second anniversary?
Just a wee bit over 2000 to go to get it by 11/18 - 2.5 months is...
"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
September 1, 2010 at 5:47 am
Viewing 15 posts - 14,401 through 14,415 (of 22,232 total)