Frankly? I've died and gone to heaven. I won the lottery. I asked the prettiest girl to the prom and she said yes. My code compiled the first time. I...

mtassin (4/14/2011)

---

Grant Fritchey (4/14/2011)

---

GilaMonster (4/14/2011)

---

Grant Fritchey (4/14/2011)

---

I'm looking at multiple books and articles and blog posts over the last eight years or so and I don't doubt for one second...

Stefan Krzywicki (4/14/2011)

---

A few years ago I was interviewing for a SQL Server position and the initial phone interviews went fine. I was able to answer all their questions to...

I would look at sys.dm_os_wait_stats. It shows accumalative waits for SQL Server itself. That will give you an idea of what's causing problems on the machine without having to try...

It depends on how you're making the call. If you want to run the PowerShell script directly from the 2005 server, you need to go and get Powershell installed there...

I just want to reiterate and reinforce one statement. Hints are a last resort. You need to do every other method of tuning before you get to hints. Not only...

No way I would run any kind of load generation tool against a live production server, regardless of circumstance on the monitoring.

Have you looked at wait stats? You can start...

Just remember that auto-growth is a safety valve, not a management plan. You should set the database to be bigger than it needs to be and then monitor the space...

It sure sounds like contention. Next time it's running slow, start with sys.dm_exec_requests and see what the process is waiting on and if it's blocked. You can proceed from there...

I wouldn't go down to a single file or filegroup on the new system. 5 seems like overkill, but I'd still have at least 2.

This is just a SWAG, but do you have a system backup that runs that might be locking files? We ran into a similar issue when our system backup would...

GilaMonster (4/14/2011)

---

Grant Fritchey (4/14/2011)

---

I'm looking at multiple books and articles and blog posts over the last eight years or so and I don't doubt for one second I've got horrific...

Craig Farrell (4/14/2011)

---

Alright, there's any number of things to take my article apart for, half of it's an opinion... but there's vs. there are?

I'm going to assume I'm just too...

mohammed moinudheen (4/14/2011)

---

Craig, thank you very much for the article. This would be very helpful for most of us.

I have seen many job postings which requires people knowledgebale in...

Nice article Craig. The company I left put up a SQL Superman job to try to replace me, despite my protests. My old boss just kept saying "Let's see what...