GSquared (1/13/2010)

---

I have to say I haven't yet run into a situation where I'd want to do this.

Does RedGate's backup product use the SQL backup engine? I don't see...

Daily differential and weekly fulls of what drive? No need to try and backup your data or log volumes since the database files won't be backed up anyways.

With this...

I really don't understand your question - sorry.

Why would someone have access to the server and be able to change/modify SQL Server files? The files SQL Server needs to...

How are you taking snapshots? Are you using a tool that understands SQL Server and is capable of freezing the databases before you take your snapshot?

If not, then you...

First - pinning a table in memory is no longer supported and shouldn't be considered. SQL Server 2005/2008 manages this much better.

Second, define first time you are running your...

I don't follow - what output are you expecting and what output is missing?

I would try rebuilding that index before doing anything else. All of those errors are related to the same index (it looks like) and it appears that the index...

Just one note - for MonthsInService using that calculation are you aware that this will give you a value of 1 month even though there is only one day difference?

DATEDIFF(month,...

I would look at using 3 databases - not servers.

DatabaseA has application code and access to the data.

DatabaseB and C alternate between build cycles. When B is active, C...

Look for a scheduled job that performs a reindex operation on that database. I would bet that the log file is growing to that size during this maintenance.

Also, look...

If you want the data from the day one year ago, calculate that day first:

DECLARE @startDate datetime;

SET @startDate = dateadd(year, -1, dateadd(day, datediff(day, 0, getdate()), 0));

Now, you can perform you...

http://www.sqlservercentral.com/articles/Administration/2960/

Here is the code I use:

Declare @dbname sysname

,@execSql varchar(max);

Declare dbname Cursor Local Static For

Select...

I do...

That procedure needs to be run in the context of the database where you want the stats updated. Basically, you are running your procedure over and over in the...