Do make sure before you drop the NON-unique non-clustered index that you do two things:

1) Verify EVERY OPTIONAL PARAMETER for both indexes (pad index, fill factor, etc) to make...

1) Narendra, let me start by saying that I have NEVER had a client try to do partitioning with no prior experience and without getting a professional to help them...

My understanding is that BizSpark gives you licenses that are straight-up what they say they are and don't carry any additional restrictions (other than perhaps the BizSpark duration which is...

I will say that I do have more experience than most at both ends of the extreme as far as numbers of databases per server goes. I have a client...

Sorry, but average databases per instance really is a nonsensical metric for many reasons, including (but not limited to): hardware capabilities (RAM/CPU/IO/NETWORK/ETC), size of individual databases and overall size of...

Ahh, Azure. So some external wait perhaps? But still, if a query is just sitting there and not progressing, there should be SOME wait type exposed in sp_whoisactive for the...

Run sp_whoisactive while doing ANYTHING (i.e. not just drop/restore db) to see what is actually happening from MANY metrics. This includes the ability to get query plans, actual wait metrics,...

Different plans can have different executions.

Take a look at the SQL Server MVP Deep Dives 2 book - GREAT resource on LOTS of useful topics! The best chapter in that...

thbaig (12/12/2015)

---

Yes, it is crazy requirement. I can write custom ETL to sync few tables but write routine for all tables and specially if you have 50+ databases , it...

tcronin 95651 (12/11/2015)

---

Moving to new job in a week that currently has a high usage OLTP on SQL 2012 on vmware that also has heavy reporting. They probably should...

Good luck with this one!! If you find something that does even half of that stuff please post here so I can learn about something I don't know about yet!!...

kiril.lazarov.77 (12/10/2015)

---

TheSQLGuru (12/9/2015)

---

Handling gaps with my mechanism really is simple and efficient. Been there, done that, got the tshirt.

But your new requirement about category makes it much more likely...

VM and AV both hold potential to flush your RAM, which flushes your SQL Server performance. 🙂 I would look at those first.

I note I have seen various driver bugs...

Handling gaps with my mechanism really is simple and efficient. Been there, done that, got the tshirt.

But your new requirement about category makes it much more likely you will...

You simply MUST NOT order all rows to get one!! That is an immensely costly operation!

One quick-and-easy way is to get min and max ID values and create a WHILE...