Viewing 15 posts - 10,546 through 10,560 (of 22,219 total)
naga.rohitkumar (8/17/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
August 17, 2012 at 5:57 am
There's not enough information here to give you a step-by-step action plan to handle database growth. I don't see the indications for how fast the database is growing. There's no...
"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
August 17, 2012 at 5:35 am
That's interesting. I didn't know SQLIO was gone. Hmmm... Maybe they just renamed it. It never should have been called SQLIO in the first place, just IO. It never tested...
"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
August 17, 2012 at 4:51 am
Doubly important not to switch to simple recovery because you're already potentially in a position where you may have an issue and might need to recover the database to a...
"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
August 17, 2012 at 4:43 am
SSRS is almost a completely different field of study from being a DBA, so, while I like SSRS, support it's use and all that, I don't know that I'd concentrate...
"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
August 17, 2012 at 4:41 am
And don't forget spatial data. That's a huge bit of functionality introduced in 2008.
"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
August 17, 2012 at 4:31 am
Drop does exactly what it says. It's going to drop the existing index and then rebuild it. No, it won't leave the existing index available while it does the rebuild......
"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
August 17, 2012 at 4:20 am
And make sure your backups have been running for the last several days. Make a copy of the backups. If you have log backups prior to the error, make sure...
"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
August 17, 2012 at 4:13 am
Index intersection might work with the 2 indexes, but it might not. If not, you could try the same two indexes and then use a UNION ALL query to put...
"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
August 16, 2012 at 5:16 am
asranantha (8/16/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
August 16, 2012 at 5:12 am
This isn't something I've set up in my Availability Group work so far, but here's a blog post where someone ran into a similar issue.
"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
August 16, 2012 at 4:37 am
You're still attempting to stuff multiple files into a single location. You can't do that this:
MOVE N'TELE_1_Log' TO
N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVERMSSQL\DATA\TELE_log.ldf',
Needs to be changed to something else, maybe...
"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
August 16, 2012 at 4:30 am
These questions really sound like either an interview or homework. If I answer the questions, do I get the pay or the grade?
"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
August 16, 2012 at 4:26 am
Itzik Ben Gan has a number of examples on how to find islands and gaps in sets of numbers in his book Inside T-SQL Querying. I'd suggest picking up a...
"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
August 16, 2012 at 4:24 am
This is administrator information. Either you need to get view server state permissions or you need to work with someone who does.
"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
August 16, 2012 at 4:23 am
Viewing 15 posts - 10,546 through 10,560 (of 22,219 total)