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...

1) if you have too few spindles in your IO subsystem, multiple files can actually degrade performance

2) moving data to new filegroups is done via a clustered index, specifying what...

jswong05 (4/9/2010)

---

chileu17 (10/21/2008)

---

Sorry SqlGuru :hehe: I think I couldn't explain to you my question. I do understand your point, BUT how do I implement what you are talking about?More indexes?new...