As far as I know, it's just a limit. In SQL Server 2008, the limit is 999.

Was he asking why you would not want that many indexes? Or was he...

Inserts will absolutely be slower. There's no way to get around the fact that you'll have to udpate the index as part of the insert. So, as previously stated, you...

The variable can only be loaded once. So it's going to be set a single time and then when you reference it in the second select statement it will only...

Take a look at the OUTPUT clause in the Books Online. That will allow you to capture the ID's as you create them and then use those ID's in the...

As you insert records, the index will get updated. If there's no clustered index on the table, the non clustered index will point to a hidden row id value instead...

No, there really isn't. Once the transaction is committed, it's done.

Jeff Moden (7/15/2009)

---

They're...

It's clear now. I'm not sure why it was revoked, but I guess they recognize the mistake. I won't be using the word "Porn" again any time soon.

My Twitter account just got suspended for suspected abuse. I wasn't abusing anything. This stinks. According to the documentation, they can suspend it for up to 30 days.

I'm sorry, but can you zip those up & reattach them. I'm having a hard time getting them to open as is.

I love it. Integrating our builds with the development builds makes everything so much easier. The power that comes from knowing exactly what has changed, when, by whom, makes all...

In 2000, it's a pain and you can't really do it unless you post a text plan. In 2005/2008, it's easy. Just right click on the execution plan, assuming it's...

It's very easy to do. Look it up in the Books Online for examples....

mchid (7/15/2009)

---

Thanks Grant. So should I use a clustered index on the Guid FKs then?

My investigations are now with the code itself where I have found some issues (LINQ...

Randy (7/15/2009)

---

I have a question on that: is it better to have a clustered index on a high selectivity value like a date field where you might have 1000+...