Viewing 15 posts - 14,401 through 14,415 (of 22,227 total)
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
No, it shouldn't. If you've got appropriate log backups in place, in general, the size of the log is how big it needs to be to suppor the transaction load...
"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
August 31, 2010 at 9:19 am
CirquedeSQLeil (8/31/2010)
homebrew01 (8/31/2010)
CirquedeSQLeil (8/31/2010)
Once you have re-grown the log - then defrag your indexes.
Does defragmenting indexes apply to shrinking log files as well as data files ?
In this case 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
August 31, 2010 at 9:09 am
Probably that's the original size of the log file. You can't shrink below the original file size (well, not without other work & stuff, just go with it). You'd need...
"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
August 31, 2010 at 8:17 am
9 Million tables?
I suspect that's the issue. I've never even heard of a database with that many tables. I'm not sure what kind of problems you can expect to see...
"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
August 31, 2010 at 7:35 am
I'm in agreement with Gail. Just because they're currently in a potentially dire position doesn't mean they wish to remain there. The best recommendation is to have them get together...
"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
August 31, 2010 at 7:26 am
Viewing 15 posts - 14,401 through 14,415 (of 22,227 total)