Depending on what you think, look at Itzik's book or Kevin Kline's T-SQL in a Nutshell. Both good books.

I like Lynn's solutions. #1 moves the function to a scalar instead of a column that is indexed and should improve performance.

Thanks for the update and glad you found it.

Double Clicking on the error should take you to the line. It might not be always exact, but it should get you...

The mature third party backup tools provide utilities, for free, without license, that convert their compressed/encrypted backups to native formats. You can get those for SQL Backup (Red Gate) and...

Look at restore filelist only - http://msdn.microsoft.com/en-us/library/ms173778.aspx

I recommend you not back up multiple backups to one file. It's a risk that's unnecessary and any problem with that file means you...

Dev @ +91 973 913 6683 (10/17/2011)

---

Your boss shouldn't really run your schedule, but tracking down the things you spend time on and examining them later is a good...

GilaMonster (10/15/2011)

---

I...

BTW, in my last presentation on Friday I was trying to give a brief overview if indexing and testing. Not enough of a detailed explanation according to Gail as she...

I'm definitely an Apple guy overall. I love my iPhone and the iPad is nice, but I found I needed more than a tablet. Went with an Air, and all...

Late, here, but that does seem like a lot of time on overhead things. I don't know that I think documentation should be cut, but I might try to cut...

Chad Crawford (10/14/2011)

---

Here's a shot of Steve giving his presentation[/url]. If you look close, you can see his Kilt peeking out from behind the podium. Hope the...

😛

:w00t:;-):cool:

Isn't that already the case? (at least if my wife isn't reading this...

I'm not that old....yet

Ninja is correct. The verifyonly will not necessarily prevent corruption. You need to do a restore, or mount the backup file using one of the tools, such as Red Gate's...