are you linking from a SQL 2000 server to a SQL 2005 server?

we might go to R2 next year, but will probably wait until 2011. for the 2005 upgrade we waited until SP2 was released and PSS was still swamped with support...

great article

some time ago i played with something similar to import csv files with performance data but never got it to work in importing only the files that haven't been...

bob 54859 (11/12/2009)

---

SQL Noob (11/12/2009)

---

bob 54859 (11/11/2009)

---

Ok,

So... here is a question we have debated in our shop for quite a while.

The question is...

Given a table where they is no...

one time we got a script to create a table from development. it had a PK but no indexes. we asked if we should add any indexes to the new...

bob 54859 (11/11/2009)

---

Ok,

So... here is a question we have debated in our shop for quite a while.

The question is...

Given a table where they is no good candidate for a...

hlam-1032421 (11/11/2009)

---

With comments like this I run for the exit:

… good clustering. One school says to put the clustered index on the column or set of columns that would be...

most of our clustered indexes are from the 2nd school. unique, ascending, etc

but i do break the rules sometimes and created clustered indexes on date columns and we had a...

GilaMonster (11/11/2009)

---

A RID is 8 bytes. An integer column defined as...

a diff backup will backup every page or extent that has been modified. even if it was a bit value that was changed, it will backup the entire page or...

yes

netbackup and other third party products use Microsoft's API's and build upon them. if you do an sp_who2 during the process you will see it execute backup database and restore...

call MS PSS or check out Microsoft Connect and file a bug report. Windows 2003 SP2 has better memory management than Windows 2000 and this could be a reason

I would...

another bad thing about shrinks is it will cause your db files to become physically fragmented on the disk

Todd Williams-416222 (11/4/2009)

---

Thank you for your response.

This is not my database. It is someone's who contacted me for help with recovering after a HDD crash. They said their...

i do db shrinks on archive databases once in a while to clear up space or to delete unused data files. otherwise i always create data files to be twice...