Viewing 15 posts - 10,696 through 10,710 (of 22,224 total)
Assuming we're talking about a data file and not a log file, something had to have filled that space. Do you have load processes or queries that use tables for...
"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 26, 2012 at 4:47 am
The majority of people do, but it's not a guaranteed approach.
"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 26, 2012 at 4:45 am
You're right, every organization attacks that differently. The best documentation I've seen for laying out roles & responsibilities is an older book called "Database Administration" by Craig Mullins. It's still...
"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 26, 2012 at 3:58 am
Without seeing & testing the code, it's hard to make a definitive answer. But based on what you've said, yes, I suspect strongly that the cursor is going to affect...
"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 26, 2012 at 3:50 am
I only do a little bit of consulting. I know that others do more.
"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:50 am
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
Viewing 15 posts - 10,696 through 10,710 (of 22,224 total)