Viewing 15 posts - 15,301 through 15,315 (of 22,227 total)
Ninja's_RGR'us (4/28/2010)
Grant Fritchey (4/28/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
April 28, 2010 at 11:07 am
Lynn Pettis (4/28/2010)
Brandie Tarvin (4/27/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
April 28, 2010 at 8:35 am
Nope. I'm not seeing 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
April 28, 2010 at 8:28 am
I was thinking the same thing, plus, how the heck big are the transaction logs?
"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
April 28, 2010 at 8:22 am
Check the TSQL to see the execution plans & tune as needed. Validate that the SSIS package is not performing scripts or operations that prevent the pipeline from acting in...
"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
April 28, 2010 at 8:18 am
Wesley Brown (4/28/2010)
I'd seriously think about calling MS support on this one.
Concur. That sounds like a serious problem.
"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
April 28, 2010 at 8:13 am
Yeah, I figured updateusage was a total waste of time, but it was niggling at my head, so wrote it down.
If consistency is good.... it's the OS or the SAN...
"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
April 28, 2010 at 7:22 am
Personally, I'd say yes, use the APPLY operation, but, as with all things, you should test both, look at the execution plans, the performance time, and then make the determination...
"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
April 28, 2010 at 7:15 am
Depending on the data types, of course a few million records could produce a difference of 20gb. Actually, the data types involved must be quite small for several million records...
"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
April 28, 2010 at 7:13 am
d.srikanth50 (4/28/2010)
on monday to saturday at 3:30a.m.i have to schedule diferential backups also on everyday.
please guys let me...
"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
April 28, 2010 at 7:10 am
Will do. I was being lazy with the link and got caught. Sorry :crying:
"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
April 28, 2010 at 6:59 am
Although, again, I'd suggest a quick query against sys.dm_exec_query_stats. Order by physical/logical reads or physical/logical writes and you'll see the queries currently in cache that are hitting the system hard...
"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
April 28, 2010 at 6:57 am
Ninja's_RGR'us (4/28/2010)
Assuming this job has already run succesfully in the past :
1 - Either the permissions changed (NTSF or sql login)
2 - You're out of space on...
"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
April 28, 2010 at 6:53 am
GilaMonster (4/28/2010)
p.s. In SQL 2005, you cannot force an index seek. You can force an index to be used but you have no control over how it will...
"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
April 28, 2010 at 6:47 am
The fact is that data is neither stored nor retreived in precise order. Without the ORDER BY, that I'm not telling you to use, you have no guarantee how 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
April 28, 2010 at 6:44 am
Viewing 15 posts - 15,301 through 15,315 (of 22,227 total)