Viewing 15 posts - 16,996 through 17,010 (of 22,210 total)
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...
July 16, 2009 at 5:59 am
No, there really isn't. Once the transaction is committed, it's done.
July 16, 2009 at 5:52 am
Jeff Moden (7/15/2009)
Grant Fritchey (7/15/2009)
J.D. Gonzalez (7/15/2009)
Execution plans attached.I'm sorry, but can you zip those up & reattach them. I'm having a hard time getting them to open as is.
They're...
July 16, 2009 at 5:35 am
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.
July 15, 2009 at 2:59 pm
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.
July 15, 2009 at 1:12 pm
J.D. Gonzalez (7/15/2009)
Execution plans attached.
I'm sorry, but can you zip those up & reattach them. I'm having a hard time getting them to open as is.
July 15, 2009 at 12:45 pm
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...
July 15, 2009 at 11:12 am
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...
July 15, 2009 at 7:50 am
frecal (7/15/2009)
I am using sql 2008...is this easy to do..are there any examples i can work with?thanks
Fred
It's very easy to do. Look it up in the Books Online for examples....
July 15, 2009 at 7:31 am
mchid (7/15/2009)
My investigations are now with the code itself where I have found some issues (LINQ...
July 15, 2009 at 7:31 am
Randy (7/15/2009)
July 15, 2009 at 7:29 am
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...
July 15, 2009 at 7:03 am
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.
July 15, 2009 at 6:59 am
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...
July 15, 2009 at 6:56 am
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...
July 15, 2009 at 6:53 am
Viewing 15 posts - 16,996 through 17,010 (of 22,210 total)