Viewing 15 posts - 5,131 through 5,145 (of 5,843 total)
Just to make sure everyone understands here, LEAST bad in this case still means greater than 1 ORDER OF MAGNITUDE greater runtime! The fastest TSQL cursor took 13.917 seconds...
June 16, 2008 at 7:59 am
Wilfred van Dijk (6/16/2008)
June 16, 2008 at 7:17 am
You guys REALLY need to listen up when TheSQLGuru speaks!! 😀
1) The first post I did on this thread way back requested someone test the result with...
June 14, 2008 at 7:31 am
Backup and restore will allow you to move databases that exist on a cluster. Note that there other items to attend to such as creating and sync'ing up logins....
June 14, 2008 at 6:51 am
Did anyone run that test code with other than the default cursor settings (which are not optimal)? Can someone try LOCAL STATIC FORWARD_ONLY READ_ONLY and see how the performance...
June 13, 2008 at 1:21 pm
Here (again) is the Bible on deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
June 13, 2008 at 1:16 pm
If you are not on SP2+, get there. There are SIGNIFICANT proc cache issues with earlier versions, including the ridiculous situation where proc cache can take up SEVENTY FIVE...
June 13, 2008 at 1:15 pm
Make sure that every single driver and firmware component between the CPUs and the physical disks are patched to the latest available level. That is likely the first thing...
June 13, 2008 at 1:12 pm
rbarryyoung (6/11/2008)
Robert klimes (6/11/2008)
Having tempdb on its own drive (raid 10 preferable) and having same number of tempdb file as you have cores would be optimal configuration.
This is a SQL...
June 12, 2008 at 8:09 am
Since you will likely be faced with different drive configurations when moving to cluster/SAN, you should probably use the BACKUP and RESTORE commands. Explicitly script them out. They...
June 11, 2008 at 8:33 am
Peso (6/10/2008)
grevesz (6/9/2008)
If you start a load testing batch process in 10 parallel threads and let it run for an hour and a half, you exhaust your number range...
You have...
June 11, 2008 at 8:10 am
sp_recompile is not required after either of these events. They both will lead to recompile of all necessary objects.
June 11, 2008 at 8:04 am
My recommendation is that you hire a SQL Server DBA to do SQL Server DBA work. It just boggles the mind that a company is having an unqualified person...
June 11, 2008 at 8:03 am
Are you sure that what you are seeing isn't just the extra IO and overhead to maintain the clustered index?? Don't have time to run the tests at the...
June 5, 2008 at 4:23 pm
1) I bet there are plenty of things in your database that can be tuned. Haven't found a client yet where that wasn't the case!! :w00t:
2) Do a...
June 5, 2008 at 6:18 am
Viewing 15 posts - 5,131 through 5,145 (of 5,843 total)