Viewing 15 posts - 45,256 through 45,270 (of 49,571 total)
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...
August 8, 2008 at 1:56 am
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.
August 8, 2008 at 1:52 am
Please note that the post you are answering is almost a year old.
August 8, 2008 at 1:42 am
jcrawf02 (8/6/2008)
August 8, 2008 at 1:31 am
Miles Neale (8/7/2008)
Was that word of mouth or is there a URL that advises such?
Bit of both.
Other thing that was discovered is that you can't just go back through...
August 8, 2008 at 1:13 am
Kristin Echols (8/7/2008)
We just did our last upgrade from 2000 to 2005 this week (seriously). Maybe we can skip 2008 and wait for 2011?
Look over the new...
August 7, 2008 at 11:13 am
By 1st time, do you mean the order with the lowest order date?
August 7, 2008 at 10:55 am
Peter Schott (8/7/2008)
August 7, 2008 at 10:54 am
Adam Bean (8/7/2008)
Stupid third party vendor applications.
Lol.
August 7, 2008 at 10:31 am
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/
August 7, 2008 at 10:05 am
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...
August 7, 2008 at 10:01 am
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...
August 7, 2008 at 9:56 am
a_lindeman (8/7/2008)
August 7, 2008 at 8:56 am
rbarryyoung (8/7/2008)
Downloaded RTM last night, can't install it until tomorrow though...
I started downloading it last night, stopped when I noticed the size. 3 GB download will use my entire month's...
August 7, 2008 at 8:28 am
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...
August 7, 2008 at 7:59 am
Viewing 15 posts - 45,256 through 45,270 (of 49,571 total)