Thanks to Craig for the question and Paul for the link to Kalen's article.

It's really good to know that SQL Server will exclusively lock the pages that were truncated until...

Sorry then, I thought that he was after an "unique ID" and that a UNIQUEIDENTIFIER would be an option but as almost everyone here said NO to using a UNIQUEIDEINTIFIER...

Me too. Great question. Keep them coming! 🙂

Brigadur (2/1/2012)

---

L' Eomot Inversé (2/1/2012)

---

That's a good idea! With the warning option, i was thinking of all existing code out there (not mine of course 😉 ) that relies on...

Hi, guys.

Adding an IDENTITY column wouldn't solve his problem?

ALTER TABLE dbo.TableObject ADD Id INT IDENTITY UNIQUE;

I once had faced the same network related problem and was able to solve it by changing the service which the SQL Server process connected with to Local Service or...

I would have chosen "All of the above" if it wasn't for two contradictory options. 🙂

Excellent article and highly practical examples! Thank you!

One question though: when having to restore to a specific point in time using STOPAT can I trust the "BackupStartDate" column returned by...

Loved the question and got it right because I had issues with some old code before.

Thank you for this straightforward question!

Could you please give my point back if possible? 🙂

I answered YES on the spot. I didn't know that there's a situation where one of them would fail though.

Great question...

I deserve to be punched for that.

I was trying to destroy a mosquito with a nuclear weapon....

I've never used the HashBytes() function so I learnt something new.

I got it right at first because of logic thinking but the options had me wondering and I had to...

And a more simplified version of Example 2 below: :blush:

SELECT YEAR(SaleDate) AS Year,

SUM(CASE MONTH(SaleDate) WHEN 1 THEN SaleProfit ELSE 0 END) AS Jan,

...

zuber.patel (1/24/2012)

---

Hi Rookie,

The Article is really helpful, just want to know how we can display data in horizontal form like

...

A really good question anyway. Thank you, Steve.

I never thought about using Resource Governor to limit CPU on a database backup.

Sometimes making a backup will eat almost 100% CPU and...