Viewing 15 posts - 15,286 through 15,300 (of 22,219 total)
izdede (4/28/2010)
I set up the perfom from my machine. I select the computer I want to monitor by select remote computer to run perfmon...
"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 12:53 pm
I'm sorry, I can't understand entirely what you're describing.
Why can't you use referential integrity?
BTW, you mention a view that enforces integrity. Views are simply select statements. They can't enforce integrity...
"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:39 am
Without more details, it's kind of hard, but basically, assuming TableA is the parent and TableB & TableC have foreign key relationships to the table, and that the column 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 11:37 am
At this juncture, I'd go straight to 2008 R2, skip 2005 and 2008 entirely.
As far as the upgrade process, if you can, the safest way to do it 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
April 28, 2010 at 11:32 am
Maybe it's just me, but it sounds like you just need to delete stuff off the server.
If this location also has your data files, one thing to look for 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
April 28, 2010 at 11:29 am
Ninja's_RGR'us (4/28/2010)
Grant Fritchey (4/28/2010)
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...
"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:12 am
only4mithunc (4/28/2010)
So do you mean to say, if the table has an index (on the column on which WHERE condition is applied ) the above order of execution...
"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:11 am
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
Viewing 15 posts - 15,286 through 15,300 (of 22,219 total)