1) the BEST way to learn how to interpret and make use of the wait stats is to have a professional tuner mentor you while giving your system a review...

MarkusB (4/22/2010)

---

SQLGuru,

thanks for your reply and I totally agree with you that a lot of SAN implementations are not very well done.

Unfortunately I joined my current company just...

MarkusB (4/21/2010)

---

SQLGuru,

do you have some links or other information about NetApp Iscsi problems. I'm i the unfortunate situation that we use a NetApp and yes we have problems with it....

I use a simpler approach: Jasper Smith's Reporting Services Scripter (http://sqldbatips.com/showarticle.asp?ID=62). Keep everything saved off onto a separate machine and you can migrate pretty quickly. Clearly not...

brett.hawton (4/9/2010)

---

Great article!

Just some personal observations:

1. On larger queries SQL Server read-ahead kicks in and it reads 512KB blocks at a time. In my observations disks are much better at...

RBarryYoung (4/13/2010)

---

TheSQLGuru (4/13/2010)

---

RBarryYoung (4/13/2010)

---

TheSQLGuru (4/13/2010)

---

Why bother converting the int to date at all? Every human can read and understand 20100411 is April 11 2010. 🙂 And if you...

RBarryYoung (4/13/2010)

---

TheSQLGuru (4/13/2010)

---

Why bother converting the int to date at all? Every human can read and understand 20100411 is April 11 2010. 🙂 And if you need a...

Why bother converting the int to date at all? Every human can read and understand 20100411 is April 11 2010. 🙂 And if you need a 'pretty' date,...

From the types of questions you are asking Tara, and the amount of data you have and the complex environment, I strongly recommend you get a professional SQL Server tuning...

1) what are the IO stalls on your disk system, especially writes? see sys.dm_io_virtual_file_stats in BOL

2) as others have mentioned, indexes/triggers. also unindexed FKs maybe?

3) growth rates on...

If you are going to detach with the...

Bhuvnesh (4/11/2010)

---

Kimberly L. Tripp (4/9/2010)

---

I would first check to see if these are single columns stats (the simple answer will be YES if all of the index names start with...

Hey - look at the "newbie" who is posting on SSC now!! Welcome aboard Kimberly! 🙂

More than one way to skin this cat correctly, and probably more than one way to do it INcorrectly as well! 🙂

Forums are designed for short, quick, targeted advice since they are 'staffed' by volunteers. This isn't any of those. 🙂 It could take many hours of time to...