So, is this the simplest and quickest way to get the last day of any month?

DATEADD(MONTH,x,'2010-Jan-01')

Where x is the month you are looking for the last day.

I've seen a...

I guess I'm 'nitpick mode' on as well; backup was to disk 'D:\db1.bak' but the restore was from 'D:\main.bak', technically we have no idea what was restored 😛

TravisDBA (10/12/2010)

One of the first things my father told me when I was old enough...

Agreed gtho.

I think the largest factor is maturity. If we all acted as adults, and focused on getting our jobs done, and helping those around us when we can,...

I'd also like to add that many of the differences pointed out here are just behaviors. Behaviors can be exhibited by any gender, and being an idiot or a...

Excellent followup article Steve, and JenMidnightDBA, where do I find your blog?

I don't think sex is the concern that someone also pointed out of relationships, and possibly preventing them. ...

OK, I'm the dummy this morning: Why wasn't (3,1) one of the inserted rows?

It would be convenient, when adding events like this, to include a calendar download (ics file or similar) like the SQLLunch.com people do. I like it because it auto...

Duh. Yes, of course, you are correct.

So....

Why not just fail over to the secondary full time, so that you can upgrade the primary offline. If all goes well, fail back to the primary, if not,...

So, this example is only intended for fail implementations? You plan on reverting back to mirroring when the implementation is complete?

Or, did you mean to include a statement to...

Items 9 and 14 are missing from the screen shots. I assume you are referring back to the main 'Transaction Log Shipping' page in the properties view. It...

I'll have to tell my wife... "See, the guys at SQLServerCentral.com said 'material relations' will help me solve this problem I'm having with my project at work" 😛

I find that...

I thought I might get it wrong, but not only was I wrong, but for the wrong reason. Learned something. Thanks for the question.

I shocked that no one...

Man you guys are finicky.

Many of you prove your point by quoting MS documentation, but others of you claim MS Documentation isn't good enough.

Which is it?

So do all questions have...