My standard answer would be to add an int indentity column if you can. Narrow, unique and ever increasing is a good candidate for your clustering key. Keep in mind,...

Personally I love framing

Free ebook: Introducing Microsoft SQL Server 2012

Is the SQL Server service running as a domain user?

First of all, I am really a fan of CTEs, as they give a lot of flexibility and readable code. However, in this case I find that the CTE is...

No, this is not possible. SQL Server 2012 have...

Basit Farooq (3/12/2012)

---

okbangas (3/12/2012)

---

As mentioned in my article our backup drive that contains the file backup of the system databases got corrupted as well. So this is not option in...

I really dislike to rebuild system databases, thus I will have a file backup of the system databases (database and log). In the case of such a scenario that you...

First of all, today I would install SSMS fro SQL Server 2012 RTM, not RC0. And yes, they do very well co-exist on my laptop.

Sorry, no offensive intended. I'll try to remember 🙂

A few thoughts: Why are you concerned about locking of the temp tables, they're only accessible from your own session.

Furthermore, option maxdop 8 does allow for parallelism yes, but...

Gail is correct in his definition. To elaborate a bit: If you use 4 cores for 2 seconds, you'll see a CPU time of 8s whereas the elapsed time is...

what is the result of the following statement?

exec master.dbo.xp_readerrorlog 0, 1, 'Using Locked Pages For Buffer Pool';

Please have a look at this article: Managing Transaction Logs in SQL Server[/url]. Transaction logs are crucial to SQL Server, and you really have to understand how it works.

Totally agree with Gail. Itzik is great, and if you should happen to get the opportunity to attend one of his sessions or courses, do so.