PageIOLatches often indicate slow disks. Try the following counters

Physical Disk avg sec/read

Physical Disk avg sec/write

Physical Disk % idle time

SQL Buffer manager checkpoint pages/sec

SQL Buffer manager lazy writes/sec

Pages/sec just gets you...

Aikido 2-3 nights a week and archery every second weekend. I also do a little weightlifting and other gymnastic-style workouts from time to time, purely for fitness.

Please note that the post you are answering is almost a year old.

jcrawf02 (8/6/2008)

---

Had to throw this one in for good measure. I know you all love to hate on developers, and here's a good lesson in why you shouldn't comment things...

Bit of both.

Other thing that was discovered is that you can't just go back through...

Look over the new...

By 1st time, do you mean the order with the lowest order date?

Peter Schott (8/7/2008)

---

And sadly, those of us with Visual Studio 2008 and no SP1 cannot install SQL 2008 without a lot of pain. Either uninstall Visual Studio 2008 or...

Lol.

Read through these three and see if they help. If you have questions afterwards, plelase ask.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/

SQL 2005's encryption allows you to encrypt specific columns in tables. It does not allow you to encrypt the entire database. (SQL 2008 has that)

Perhaps look and see if you...

It shouldn't need any extra permissions, and that is not a standard error message. It's custom and specified within the trigger (message number of > 50000)

What's the code of the...

a_lindeman (8/7/2008)

---

that there's a seperate download from sqlcmd. Is sqlcmd no longer in the regular packages (even for Express), or does this download provide more functionality for sqlcmd than...

I started downloading it last night, stopped when I noticed the size. 3 GB download will use my entire month's...

The other problem is that that format of where clause tends to confuse the optimiser and has no single fixed optimal plan. You're probably getting a table scan for the...