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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2013 at 4:34 am
Take a look at these
http://www.sqlskills.com/blogs/paul/more-businesses-than-you-think-are-on-the-cutting-edge/
http://www.sqlskills.com/blogs/paul/more-businesses-than-you-think-are-still-using-sql-server-2000/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2013 at 4:31 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2013 at 3:54 pm
SQL error log. Recovery process is logged in there
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2013 at 12:37 pm
Please note: 8 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2013 at 10:02 am
Please note: 9 year old thread. Also, neither SSIS nor SSRS exist in SQL 2000, they're in 2005 and onwards
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2013 at 10:01 am
Viewing 15 posts - 13,096 through 13,110 (of 49,552 total)