Viewing 15 posts - 15,121 through 15,135 (of 22,219 total)
vijay82 (5/6/2010)
DISK is running out of disk space.what methods should be taken to over come it ?plz reply
thankyou:-)
First time as a DBA huh?
You really, really should hit the books. I...
"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
May 6, 2010 at 6:11 am
I'm in agreement with David & Henrico. The one point I would add, and it was touched on by Henrico, is that you really should put growth limits 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
May 6, 2010 at 6:09 am
A query is not selective or not. The data it is accessing may or may not be selective. I don't understand where you're trying to go with this.
You can query...
"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
May 6, 2010 at 6:07 am
Lynn Pettis (5/5/2010)
Grant Fritchey (5/5/2010)
Lynn Pettis (5/5/2010)
Paul White NZ (5/5/2010)
Lynn Pettis (5/5/2010)
Grant Fritchey (5/5/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
May 6, 2010 at 6:03 am
I just did some tests with fonts on my desktop. What I do to my operating system (windows 7) happens to my object explorer. I don't know of any other...
"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
May 6, 2010 at 5:59 am
Jeff Moden (5/5/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
May 6, 2010 at 5:20 am
The only reference to that error I saw on MSDN was here. It wasn't related to log backups.
"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
May 5, 2010 at 8:20 pm
what events are you tracing? You could see this if you were tracing statement and rpc complete, for example.
"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
May 5, 2010 at 8:16 pm
R2 is basically an upgrade. Depending on your licensing with MS, you'll need to buy a new one to move to it. It's not simply a service pack.
"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
May 5, 2010 at 8:15 pm
CirquedeSQLeil (5/5/2010)
Grant Fritchey (5/5/2010)
Lynn Pettis (5/5/2010)
Paul White NZ (5/5/2010)
Lynn Pettis (5/5/2010)
Grant Fritchey (5/5/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
May 5, 2010 at 8:12 pm
Can you post the specific error?
"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
May 5, 2010 at 5:31 pm
I agree with Jeffrey, but not because I'd be sweating the SAN just going down. By and large those things don't go away. I'd do it because you never know...
"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
May 5, 2010 at 5:30 pm
Maybe you mean you validated the backup and it failed, or you ran DBCC against the restored database and that failed.
"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
May 5, 2010 at 5:29 pm
tosscrosby (5/5/2010)
Strappado
Pass, thank you, and that's without following the link.
"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
May 5, 2010 at 5:23 pm
Lynn Pettis (5/5/2010)
A gauntlet has been thrown down. Am I up to challenge? We shall see.
He does seem completely certain that there is no possible solution. I'd hesitate...
"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
May 5, 2010 at 5:22 pm
Viewing 15 posts - 15,121 through 15,135 (of 22,219 total)