Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

P.S. The filter you have in the HAVING should be in the WHERE clause. Having is for filters on...

Bhuvnesh (12/31/2012)

---

It should be but...

Everything I've said stands. You are looking at a huge amount of development and testing and probably a tonne of bugs and irritations. This isn't a 5 minute job.

john 60195 (12/31/2012)

---

I appreciate the fact that it would be easy to mess up. If a user needs to work on a specific record for a few minutes and during...

For that you'd need to manually reimplement SQL's locking mechanism, probably with a locking table, manual checks, manual notifications in all code that you have. You then need to consider...

You don't need it and frankly you probably shouldn't be using readuncommitted without a very good reason.

See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

(nolock is much the same as read uncommitted, just one's a hint)

Figure out what's preventing the log from being reused (there's either some actual replication or CDC that's not working) and fix that.

That's a completely nonsensical request as the concept of 'fragmentation size...

burgergetsbored (12/30/2012)

---

I managed to get it working now by adding a ORDER BY count DESC LIMIT 1 to the end to return only the highest value. If there's a better...

Pluralsight was started by Aaron Skonnard,...

Jeff Moden (12/29/2012)

---

Understood. Found that out in the very early...

Yggaz (12/29/2012)

---

Gail, this is just the question. I know how the things are - I do not understand why. The table only exists once - why is it so? We...

opc.three (12/29/2012)

---

I am under the impression that the clustered index requirement is a function of the way the Azure database team decided to replicate data behind the scenes to accomplish...

michael merrill (12/28/2012)

---

The idea that the table was actually corrupted (not by a user- but say a disk array error) and it still allowed inserts is the paranoid DBA in...

Because the table only exists once. The clustered index, as you note, is the table. Yes, you can create secondary indexes with all the columns if you want, they're not...