The server is a dual Xeon quad-core machine with 12GB of RAM.

I will certainly do that if the need arises. I need to sit with the developers first and figure out what's going on with the code. I'm running...

Thank you, thank you, thank you! Now off to battle the deadlock issue.

Jake (1/1/2009)

---

Great article. I have some questions though:

Recovery Modes

Is there a performance difference between the recovery modes?

Or are the recovery modes really providing the feature for database...

I thought about just mirroring the drives the OS and SQL binaries are on, but was hoping to eek out a little faster read speeds using RAID 10. If...

Good point, Apurva. I do that with our Oracle servers, but for some reason I have never done it with our SQL Servers. Our main application has tons...

Thanks for your input, BOT. I'm not too worried about filling up the drives. This is for development purposes, so no mission critical databases to worry about. ...

I still disagree about the hyper-threading thing. It disappeared when the first dual-core procs were released. It will apparently make a comeback this year in Intel's Nehalem processor,...

I'm pretty sure Xeon quad-cores do not support Hyper-Threading, so no problem there. Eight tempdb files seems excessive, and I don't have the disk space to span them out...

I actually uninstalled and reinstalled and left all default settings. Next week, I will be modifying the procedure to not use a cursor. I'll post the results here...

You could use a modeling tool like CA Erwin Data Modeler, or PowerDesigner DataArchitect. Both will let you reverse engineer your database and generate scripts. You can download...

But that would require me doing the research. 😉 All kidding aside, SQLServerCentral.com has been a life saver. If I can't Google something quickly, then I head straight...

I think that's a valid question. I'm relatively new to the company I work for, and some of the queries are inherited. I need to spend some...

WOW! So I came in this morning expecting the script to still be running, and was pleasantly surprised to see that a script that took 17 hours and 32...

The 32-bit version on a 64-bit OS did not help. My next step is to grab another disk, install Windows 2003 Server 32-bit, SQL Server 32-bit, and give it...