Be careful of what version of Windows Server you are running. If it is 2003, there is a requirement for running the MSDTC Service under a local account - something...

My point is that BOL is vague, and so it is a perfect MS certification-type question. You always have to think "what are they really meaning", instead of religiously adhereing...

BOL is very vague about this topic. Consider the following quote: "Because the name of the mark is the same as its transaction, a transaction name is required. The optional...

Clip from BOL:

Inserting Named Marks into a Transaction Log

To insert marks into the transaction logs, use the BEGIN TRANSACTION statement and the WITH MARK [description] clause....

This is one of those certification-type questions. You know, where in the real world you wouldn't do any of the options listed, but you have to pick the "best" one...

Hello,

     I admit I haven't heard of this feature before, but I'm not sure the answer is correct. The question refers to "creates named transactions that include the...

I recently wrote a script(with a bit of help from an article on this site) to do what you are talking about. Here's what I use:

set nocount on

create table #reccount...

Hello,

     With equal servers, you should see roughly the same preformance if you are using an Active/Active cluster (one instance of SQL normally runs on Server A, and the second...

Yep, I just realized the ERWin left the wrong kind of quote in, and I didn't catch it. Thanks for the info.

Thanks for your ideas, but maybe I didn't really explain very well.

The application is an in-house developed application that is not cluster aware. I am not going to run...

The Murach series of books are great, and their SQL for SQL Server book specifically addresses the T-SQL that every db developer should know (and more). Great way to get...

I'm kinda scared by the CLR integration - Don't get me wrong, it is a GREAT thing. I just think a lot of developers are going to start writing Stored...

beautiful. That works perfectly. I shoulda though of that...

Chris

Personally, I found it a great solution for keeping a reporting server relatively up to date. I just had to kill the reporting (read-only) users on a published timeline. Our...

I had to incorporate a step that killed all of the users of the reporting database before applying the log. Here's a copy of the sp that I used (created...