it's like the index in a non-fiction book

say you want to find out about replication, you look in the index and go right to the page instead of looking at...

interesting, while looking through a bunch of our statistics i found that most of the wa ones are for more than one column. will have to add this to my...

if anyone wants i can post the scripts we use. we have a blocking table on each server that has selecte rows from sysprocesses. and a job runs every 2...

for memory select a large number of rows and do an order by. something like 2 million rows should be a nice test

i've passed at least 10 MS tests and never took a class. Even started as a paper MCSE 7 years ago by studying for at least 20 hours a week...

search for my posts, i posted a bunch here a month or two ago. Or you can email me and i can send them

we use VMWare here, but on the original webinar a year ago they specifically said that they don't recommend SQL or Exchange due to I/O. if you put SQL or...

finally got a 64 bit SQL installed for testing and setting it up now. We are using HP DL 380 G5 with the Xeon 64bit CPU's.

Set up was a snap....

we had similar issues

we had 2 queries that under sql 2005 spiked the CPU to 100% and didn't do it on sql 2000. solution is to change the query.

also had...

the disk usage report and the new t-sql things like try/catch. it's all in BOL.

you have to search, but i think there was a known bug where you have to remove the office 2003 web components and maybe something else to get it to...

we are on sql 2005 SP1 and getting this error. Opened a case with PSS. Many possibile causes.

We did the following:

upgraded the drivers and some software for our Emulex HBA's...

Dev edition won't upgrade from SQL 2000 Enterprise, not sure about MSDE.

are you rebooting the server or restarting sql service? i get this whenever i have a query window open in SSMS and the server or service has been restarted

try connecting via management studio with the user account/password and see if it works and what you can do. if it works, change the password in the website code and...