You cannot. Dont try killing the SPID - you may end up with a corrupt database(although SQL Server will try to respawn the rollback process).

No - we would not want to supply individual query hints. I would shy away from second guessing the optimizer with any sort of query hint - Index / join...

patrickmcginnis59 (12/12/2012)

---

I'm always on the lookout for surprises like this, having just recently learned that Microsoft still cannot fundamentally manage storage (http://support.microsoft.com/kb/307487 "can't resize tempdb while in...

🙂 Thank you for the replies. The code unfortunately, is confidential. However, it would still be too complex even if I could post it. This is part of the code...

No thoughts ? Anyone ?:Whistling:

You seem to have a fairly decent plan, given that you have a range type query(date based). I also see that it was a sub second response for 8 rows...

My guess would be that the BULK INSERT operation is serial and with a distributed switch the packets are being routed through different hosts, some of which may be...

Too generic and brief a description. Please provide more details of a specific issue. For instance:

What is the performance issue ? You have to expect some overhead with tables...

They're not indexes - they're column level statistics. They are created automatically by the query processor, and are linked to the table stats. I cannot imagine why you would ever...

if you mean on user tables, SQL Server does not generate system indexes on user tables. It does create statistics though. Maybe you mean that ?

You cannot. What they probably mean is that you attach their database and run somee script(possibly a part of the vendor's install process), which will migrate the data from their...

fluffydeadangel (12/5/2012)

---

Doing a recreate is an interesting idea and will be addressed. I don't have the exact queries that are being run, but I was an application user at one...

If you have a clustered index on this table, maybe you want to drop all the non clustered indexes first, rebuild the clustered index and then recreate the non clustered...

You definitely want to defrag this table. However, the approach would depend on several factors like what is the downtime you can afford, whether this is a DW table which...

Your code seems to be incomplete. I can see a begin try ... but no end to the try block, and no catch block either. A simple fix would be...