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+...

Without a lot more details, it's hard to know for sure, but on a guess, you've got the GUID clustered. That's going to lead to huge amounts of page splits...

There must be a function or something that's radically changing the execution plan. You'll need to post both execution plans and please make them actual execution plans, not estimated.

Instead of intentionally violating the key (not something I'd encourage), why not just change the query slightly so that it selects the TOP 1 value and inserts that? You wouldn't...

A backup of a database is just a file, so you can move it any way you want. Copy & paste, as mentioned before will work. XCopy will work. If...