In the case of multiple SELECT statements, the "GO" separator is simply...

Jeff Moden (7/7/2008)

Ummm... maybe not directly, but...

You can't do this directly,...

You have to be more specific about what you mean by "restore time." If you are talking only about the amount of time to restore a backup into SQL Server,...

The thing with LiteSpeed is, if you use top-level LiteSpeed compression and then try to compress the files with something like bZip2 or WinRAR, your compressed files are actually larger...

Anchelin:

Careful what ya ask for, pal. It's more than one script. 🙂

All objects described below are located in the [master] database on each server. The tables are populated and the...

None of these are bulk-logged. Some are full recovery and some are simple. The full-recovery databases are the only ones...

What we do here is the following:

Full backup every Sat night at midnight (Sun morning, actually)

Differential backups midnight every other day of the week

Log backups evey 15 minutes

These are backed...

IMHO, if you are generating change scripts every day to promote to production, it sounds like you are in need to a release scheduling process. Doing things on the fly...

Try this on for size:

/*********************************************************************/

SET NOCOUNT ON

DECLARE @START_DT Datetime

DECLARE @BatchSize INT

DECLARE @RowsDeleted BIGINT

DECLARE @MyRowcount BIGINT

--SET @START_DT TO THE FIRST OF THE MONTH 6 MONTHS AGO

SET @START_DT = GETDATE() - 180...

Matt, I couldn't agree with you more, hence the new policy. My philosophy is going to be similar to the NSA's computer security division: "We found a problem, now YOU...

You're right. If the SET RECURSIVE_TRIGGERS ON option has been set, then it will. You can avoid this by changing the code as follows:

create trigger trgFubar_UPD on Fubar AFTER Update

...

The only downside to having everything in SPs is that it would mean that developers have the ability to write SQL code. It's been my experience that, unless they are...

There is a way to get around this problem, but it involves a lot of legwork and can be very time-consuming to run. Basically what you will be doing is...

My preference would be a single database and use partitioned views to allow segregated access to the data. There is a possibility of a minor performance hit, but it would...