Use profiler and run a trace to see where the drop statement is coming from. This is not data corruption.

Again, it doesn't need to be installed on the server.

If they (or you) insist, you need to find the SQL installation DVD and install from there. The link that Steve...

Yes, you can kill it.

Rollback time - unknown. As far as I know, it won't undo the entire thing, so should be relatively quick. If I'm wrong and it does...

Ratheesh.K.Nair (5/6/2010)

---

GilaMonster (5/6/2010)

---

You could download the entire of SQL Evaluation version, it'll probably be in there. It's not a separate download afaik.

Why are you installing BIDs on a server in...

The link wasn't for troubleshooting, I need the table defs for that. The link was a comment on performance.

Table definitions? Query looks right, but hard to tell without definitions.

Also... http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

Lynn Pettis (5/6/2010)

---

GilaMonster (5/6/2010)

---

Same,...

Same, sometimes because after...

Grant Fritchey (5/6/2010)

---

Hmmm... They never even asked me how many questions I answered. I think if you took away the number of times I said "do you have an execution...

It'll have an indirect impact. It'll increase the time to rebuild those indexes. Plus there's the space considerations.

You don't insert/update/delete any other time than the overnight load?

NewBeeSQL (5/4/2010)

---

Nope..you misunderstood..

overlapping indexes are the indexes which overlapped over the columns...for example..if i have 3 indexes..

index 1 is on Table1 on col1,col2,col3

index 2 is on Table1 on col1,col2

index 3...

Please post your question in a new thread, put it in the correct corruption forum for the version of SQL that you have and include the output of the following...

As I said, highly unlikely to be useful, there are edge cases, but they are rare. It is very uncommon to have a useful perf improvement by adding a NC...

Steve Jones - Editor (5/6/2010)

---

Not a bad thing, but for those of you that are MVPs, keep that in mind when reporting. I tend to report about 3/4 of my...

5.9% of my points come from this thread.

Grant - 11.7%

Steve - 2.9%

Jason - 15.4%

Lynn - 11.9%