After searching MSDN for hours, I was unable to find the correct answer. So I had to guess. Luckily, I somehow managed to guess correctly but was very disappointed to...

Should scheduled maintenance be counted against your downtime SLA?

I try to avoid any controversy by making sure the vendor has included language in the SLA that specifies whether scheduled maintenance...

Oleg Netchaev (12/9/2010)

---

... In other words, if create temp table part were moved out then the temp table would be visible to the exec batch and after, i.e.

if object_id('tempdb.dbo.#tmp') is...

A lot of people seem to think the QOTD is only about learning, especially when...

I have one of these 2 stations going all day long and find that it helps me block out all the distractions of the office and stay focused on what...

It looks like the majority here have had the same or similar experiences to my own. The consensus seems to be that approaching your current employer is usually detrimental...

I've changed jobs several times over the last 30 years of being in the workforce. Some were my decision to move and others were because the company was restructuring,...

"...if there is a chance that you can see a good portion of your administration, monitoring, or even daily work done from some device that isn't a full size laptop?"

At...

Great discussion. I think I've learned more from reading the discussion than I did when researching the question.

For those concerned with maintenance nightmares or the difficulty in writing query...

Thanks for the question. Very instructive topic and discussion.

I'm a little confused by the wording of the question though.

"What do you anticipate the outcome of the following T-SQL code to...

sknox (9/22/2010)

---

... --other data changes (e.g, by other users) are not rolled back. In this case, the items related to a backup are the backup file itself, and the metadata...

cengland0 (9/22/2010)

---

No, because that will bring the database back to a previous state. ...

I think the proper way to "rollback" a backup is to do a restore. 😉

I like composing questions that are on the tricky side. Must be...

Hugo Kornelis (9/1/2010)

---

...

I don't really see the hard-coded string as a problem. The only requirement is that you use the same date twice, it doesn't matter what date you choose....