I don't know how long they persist data, or if you can completely remove it. I have had friends disable their accounts, and all their data disappears from viewing, but...

If you have an identity column, DBCC CHECKIDENT will help you reseed the column. If you have other types of PKs, just add new data.

A primary key is the column(s) that uniquely identify each row. You don't set a PK to anything, you set the PK in each row to a unique value. That...

Tobar (10/11/2010)

---

Men and women communicate differently. That is not going to change. We all need to speak and understand the "foreign" language of the other sex. I did not hear...

Missed the weekend camping, but nice to see the Rays coming back. Sorry the Reds didn't put up more of a fight.

gtho (10/10/2010)

---

Honestly, I expected that the caricature of IT males as being blind to anything outside their narrow world was annoying, but not really true. But here I am...

I think that the medical device relies on physical security, which is OK. I know I have an ICE (In case of emergency) entry on my phone so that first...

GilaMonster (10/11/2010)

---

I have, but it's hardly a cheap...

Adding in, the indexes are much, much, smaller (typically) than your data. So if you are scanning these, it is quicker than scanning the CI (as Gail noted).

Licensing highly depends on company size. Some companies get Enterprise agreements that allow upgrades at minimal cost.

SQL 2008 was supposed to be the same upgrade cost as moving to 2008,...

If you search index rebuild on this site, there are numerous scripts to help here.

I believe these are full text indexes in 2005.

Does this help? Look for the moving full text : http://msdn.microsoft.com/en-us/library/ms345483.aspx

For some reason "California Girls" runs through my head when I read that

"...Daisy Dukes, bikinis on top..."

JenMidnightDBA (10/8/2010)

---

Steve,

Both in person and in your editorial today, you directly addressed the elephant in the room, the subject we all skirted: sex, and the issues surrounding it. ...

This help?

http://www.sqlservercentral.com/scripts/foreign+keys/69110/