Viewing 15 posts - 10,696 through 10,710 (of 22,219 total)
Brandie Tarvin (6/25/2012)
Matt Miller (#4) (6/25/2012)
SQLRNNR (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
Or...
"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
June 25, 2012 at 10:24 am
SQLRNNR (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
Or VarChar(1)
Oh yes! I think varchar(1)...
"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
June 25, 2012 at 10:06 am
You can query directly against the msdb tables for SQL Agent, if Agent is running the backups. But if the schedule is external... you're probably out of luck.
"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
June 25, 2012 at 10:01 am
The quickest method, but not necessarily the most accurate, is to use the dynamic management objects (DMOs). If you select from sys.dm_exec_query_stats, you can see aggregate calls for all queries...
"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
June 25, 2012 at 9:59 am
All that's telling you is that the object id's listed, one was waiting on the other. Look up the name of the object using object_name(objectid).
Instead of focusing directly on 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
June 25, 2012 at 8:35 am
I'm not sure what to do about the Red Gate backup logs, but that software works directly with the SQL Agent on the servers, so you should be able 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
June 25, 2012 at 8:33 am
Saravanan_tvr (6/25/2012)
"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
June 25, 2012 at 5:39 am
Prior to upgrading any of these databases, run the free tool from Microsoft, the SQL Server 2012 Upgrade Advisor. It will validate if you have any T-SQL coding issues or...
"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
June 25, 2012 at 5:09 am
Take a look at the execution plan for the query. When looking at the execution plan, drill down to the properties of the joins and you should be able 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
June 25, 2012 at 5:06 am
From what I can tell, everyone has a slightly different take on this. My goal is #1, the promotion of Red Gate Software, the company and it's products. I really...
"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
June 25, 2012 at 4:59 am
Once you've moved it up to the new version, yes, it will get the new limit. Be sure you set the compatibility level on the database too so that you...
"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
June 25, 2012 at 4:57 am
The only way to know for sure whether or not changing the location of the clustered index is going to speed things up is to test it.
If your primary access...
"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
June 25, 2012 at 4:30 am
So DB2 never, ever has a backup that they're unable to restore? Wow! that's pretty cool.
Oh, wait[/url]. Well that was just one... ummm... Well it's... ahhh...[/url] .... Nevermind.
And that was...
"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
June 22, 2012 at 9:39 am
I really don't want to sound mean, but what a mess. Why do you have so many different instances all running on the same machine?
But, to answer your question, yes,...
"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
June 22, 2012 at 5:13 am
Instead of loading temporary tables first, just join to the original tables in the DELETE statements. That eliminates a step of processing right there.
"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
June 22, 2012 at 5:06 am
Viewing 15 posts - 10,696 through 10,710 (of 22,219 total)