For those that just want to download the PDF from the Microsoft site it is also free here.

http://www.microsoft.com/sqlserver/en/us/learning-center/sql-server-library.aspx

Was able to save it to the ipad books app as well as...

I've taken someone elses query of fn_virtualfilestats and slightly modified it so I can see the drive letter so if you want you can break it down to that level...

Bear in mind our company went through some financial issues so we are not quite running 2008 yet so others may have better ideas on newer features.

1) If you...

Site/page doesn't appear to be there anymore but there was a notice out in late Dec 2009 that suggested the Office 2010 (beta) had 64 bit jet drivers. So definitely...

User posted question also on msdn and answered their own question. Apparently the full job/script included a partially commented version of the default backup job but the parameters were not...

The rollback is affecting the insert into the error_log as well as the insert into t. At a minimum the rollback should be before the insert into error_log statement. Normally...

I agree with bitbucket on forcing them to test on a sandbox. I presume you don't have to abide by any SOX or other auditing rules if that is the...

We reviewed several products and in the end choose Active Batch http://www.advsyscon.com/

more to do with some of the non-SQL related jobs we needed to manage.

We manage...

Don't think the below code is complete but might get you in the right direction. For instance the type list is not going to be complete if you have more...

Regardless whether your database is in Simple or Full recovery the log tracks update, insert, delete statements.

The actual delete statement was not complete or had an extraneous quote character...

See if this works for you

Select * from testTable

Where ISNULL(

Case DATEPART ( dw , getdate())

When 1 -- Sunday

Then acce_sunday

When 2 -- Monday

Then acce_monday

...