SQL Kiwi (1/11/2012)

---

This function is one I don't use much. I know what it does, but I hovered between single-user and suspect as the second option to the obvious...

Such an easy question that feels refreshing and points out an excellent feature for international dates.

Thank you, Steve, Hugo and Mark for the additional explanations and opinions.

Best regards,

This has to be the best article I've read about traces ever.

Please keep them coming with real world examples like the one from Listing 5 and 6.

Much appreciated.

Best regards,

Thank you, Hugo. I'll keep that all in mind and I will do some tests in my development server.

Best regards,

Thank you for the question.

A related question of you allow me (I didn't want to create a topic):

What are the main advantages of using a backup compression over using a...

Priceless! :laugh:

Best regards,

I'm not sure if that's what you want but you can use BACKUP DATABASE <etc.> WITH...

Could you please explain?

Best regards,

Guys, it's Christmas! Just that, Christmas. C'mon... 😛

Merry Christmas.

Best regards,

Oh, and Merry Christmas to all of you!!!

Sorry for the double post but I thought this message needed its own post. 🙂

Best regards,

I think they don't mean that people will "eat reindeers" over the weekend but more likely it's associated with Santa Claus's transportation. 😀

But it took me a while to dismiss...

I'd say that if you study SQL Server 2008 R2 material it will still be valid for the new certifications (unless you're talking about Training Kits which may become outdated...

You can have WHO and WHEN available to you using CT with the CHANGE_TRACKING_CONTEXT method posted in one of my last posts. Storing WHAT changed would be limited by the...

Or maybe use a loop "WHILE @@TRANCOUNT > 0 ROLLBACK TRAN..." or something. 🙂

Sorry for the double post. I clicked the wrong button.

Best regards,

Hi, Carl.

You could use it to make sure that the transaction will be either committed or rolled back when the script ends. There won't be a missing COMMIT TRAN after...