Viewing 15 posts - 13,096 through 13,110 (of 49,552 total)
IgorMi (5/20/2013)
I'm dropping the indexes and the data is only 90GB. I added three more files and re-created...
May 20, 2013 at 9:48 am
I hope the book didn't say RAID 0, because that's something you never want to use for a database.
IO throughput is a function of the number of spindles you have...
May 20, 2013 at 7:22 am
Identify what is using lots of TempDB via the task_space_usage and session_space_usage DMVs, tune the offending queries to use less TempDB space.
May 20, 2013 at 6:40 am
Probably neither. Cursors should be avoided wherever possible, and I don't see a reason for a temp table here.
You just want to delete the data relating to Project P1? If...
May 20, 2013 at 4:41 am
That's a very low number of drives for each RAID array. Low usage DB I presume, since they are pretty small...
May 20, 2013 at 4:34 am
Eugene Elutin (5/17/2013)
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
I don't think so. It's model database for all databases...
May 20, 2013 at 4:17 am
m.rajesh.uk (5/17/2013)
5. does sql starts if model database is corrupted. if so how to bring it to normal operation.
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
May 20, 2013 at 4:15 am
About the only thing I use Maint plans for is backups and CheckDB and even for backups they're not ideal as you can't set some options on the backups (like...
May 20, 2013 at 3:23 am
A transaction that's been started (via BEGIN TRANSACTION or by running a data modification) that has not yet been committed or rolled back (via COMMIT TRANSACTION/ROLLBACK TRANSACTION or by the...
May 20, 2013 at 3:16 am
Doesn't matter.
SQL is a declarative language, you tell SQL what you want and it figures out how to get that. Part of that figuring out is picking a good...
May 19, 2013 at 3:54 pm
SQL error log. Recovery process is logged in there
May 19, 2013 at 12:37 pm
Ow, that trigger is nasty.
Yes, the declaration of ID as int in the trigger is the cause of the update error. Change it to match the table and the updates...
May 19, 2013 at 12:37 pm
Please note: 9 year old thread. Also, neither SSIS nor SSRS exist in SQL 2000, they're in 2005 and onwards
May 19, 2013 at 10:01 am
Viewing 15 posts - 13,096 through 13,110 (of 49,552 total)