Great back-to-basics question and I got it wrong because I wasn't paying enough attention. Err...

I think there is a copy and paste mistake in SELECT #2 and SELECT #3 as...

Very nice little article from some years ago! Thanks.

I agree with others that just dropping obsolete objects is a dangerous task, especially when you just got the job and don't...

Same here. 🙂

mtassin (5/24/2012)I think that's what it is... I got it wrong.

The description makes sense... but I was looking at it as

A AND B OR C

In order to return from...

dwain.c (5/20/2012)

---

Here's yet another way:

DECLARE @t TABLE (status VARCHAR(30))

INSERT INTO @t

SELECT 'On Hold' UNION ALL SELECT 'On Hold' UNION ALL SELECT 'On Hold'

UNION ALL SELECT 'On Hold' UNION ALL...

2 million rows from all tables don't seem too much.

Do you have many VARCHAR(MAX), TEXT, VARBINARY(MAX), etc. columns in your tables?

I would...

This would work as well 🙂

SUM([column]) OVER () AS AllTotal

Thank you for the question. I found it easy because we have three INSERT statements there. Each one is an implicit transaction. Now nothing would be returned if it was...

I wasn't paying enough attention to detail here.

Table2's int column was just an int and nothing else. :hehe:

Time to go to bed for me.

Thank you for the question.

I still see...

Thank you, ColdCoffee.

I totally forgot about DATENAME. :w00t:

DECLARE @Year INT = 2011;

SELECT TMP.lastDay,

DATENAME(WEEKDAY, tmp.lastDay)

FROM (SELECT DATEADD(DAY,

...

How about this:

DECLARE @Year INT = 2011;

SELECT TMP.lastDay,

CASE (DATEPART(dw, tmp.lastDay) + @@DATEFIRST) % 7

WHEN...

Glad to have answered it right because I had some issues with COALESCE and ISNULL before so I had to research a little. Thank you for the excellent question. 🙂

I loved this article. Very interesting to some of us who are learning the SQL Server internals and need to simulate disaster recovery.

Sorry, guys, for not adding a note on how many answers should be selected.

Next time I'll pay more attention. 🙂

BOL had me a little confused on this concept because the...

You can't assign permissions to object types in SQL Server. But you could create a schema with only the procedures and tables you need to give permissions for and then...