Hello!

To me, the strategy that I have followed is:

1. Get the database online as soon as possible - non-current data allowed

2. Attempt to restore the most-recent data first - mostly...

I think one title...

Good question.

That being said, I fail to understand what the purpose of the question was - to test whether or not the user notices the "UNION", or that TRUNCATE can...

Very good, basic question, Hardik!

This QotD reminds us to be cautious when working with the IN keyword, especially in dynamic SQL.

Have a Happy New Year ahead!

Hello, Andy!

In the new year, I have spun off a new blog series based on the discussion that members of the community have been having in response to your editorial.

The...

Exactly - as a matter of fact, that's when this question was thought of.

Doug Bishop (12/27/2010)

---

When I saw the subject on the SSC home page, I though to myself, "Oh no, not another article with connection strings cut-and-pasted from any number of the...

Is this what you are looking for?

DECLARE @CYBeginDate VARCHAR(10)

DECLARE @CYEndDate VARCHAR(10)

DECLARE @LYBeginDate VARCHAR(10)

DECLARE @LYEndDate VARCHAR(10)

DECLARE @CYDate DATETIME

DECLARE @LYDate DATETIME

SET @CYDate = GETDATE()

--Test Data

--SET @CYDate = '04/01/2010'...

You can add the validation to an INSTEAD OF INSERT trigger and raise an error if the input is not within the required range.

ashkan siroos (12/27/2010)

---

Ok, Now I have installed and run Upgrade Adviser.

There will be some errors, Most Of them on MS DB!:D

It is strange! why Microsoft Cant upgrade his product without...

All child references must go away before you attempt to delete the record.

In this case, the records of Table B must be updated to NULL before removing data from Table...

You can try to use CTE (Common Table Expressions).

Can you post the INSERT statements for your table so that it becomes easy for us to come up with a properly...

This is very, very ugly. Flags like these must have only two distinct values. With 1,0 and NULL, you now have 3 values, one of which is an UNKNOWN (NULL).

BIT...

This question and it's response will invite mixed response, I am sure.

While it is good to know that DATETIME2 removes the "1753" restriction, it should also be known that logical...

The result set of sp_help_job has a column - "current_execution_step", which provides the "Current execution step in the job."

This is mentioned in Books On Line, and hence would request you...