Oh... I see how it is. :rolleyes:

We put weird and misleading wording in answers #1 & #2 so people get it wrong.

John.Sansom (4/9/2012)

---

Hi Ryan,

Consider that the article theme is to encourage the development of a mind set that looks to automate all processes, where applicable. It is not the aim of...

SQL_EXPAT (4/6/2012)

---

Still on the topic of automating maintenance tasks.. consider the following monthly security patch maintenance steps on 100+ SQL Servers with 500+ databases:

1. install monthly security patches on all...

support 79032 (1/6/2010)

---

Or perhaps sexism is OK if it a matter of telling men that they can't can't look after their children?

Of course what is *really* important in a basically...

I see very little sexism in the region I live in (A very red-state area in the midwest). I work with many females and have never personally questioned or...

Very nice work, thank you. I would have 5-starred it, but I don't like the script writing to the master database. I realize others might disagree with me,...

Ha... well let's hope the meteorite scenario doesn't come to fruition then.

I think I found the problem. After I did the original LOG backup, I did a log backup...

Surely it must be possible. In a real-world scenario (which thankfully this is only some concept testing), backing up the tail of the t-log may not always be possible.

For...

I restored what I have, but when I query sys.database_files, I get...

DWPROD ONLINE

DWPROD_log ONLINE

DWPROD_F1 RESTORING

DWPROD_F2 RESTORING

DWPROD_F3 ONLINE

I'd just like to bring those two files online in their current state.

Speaking of queries, the ones in the article are simple examples, but when you're pulling many columns and joining on multiple keys, repeating full table names over and over gets...

I work in a large corporation that gets most of it's funding from state government, so all our salaries are open and set on scale. No one really talks...

"Row_Number makes pagination a breeze..."

Um.

With all due respect to the author (and I truly mean that. It's a great article.) but was this statement a joke? I wouldn't...