Ninja's_RGR'us,

Cool way to get just the date from today. I'd never seen that before. So, I tested it.

DECLARE @test_dt DATETIME

set @test_dt = DATEDIFF(D, 0, GETDATE());

SELECT @test_dt

SET @test_dt = DATEADD(D, 0,...

Very cute dog. Hope it's your pet. If so, what's it's name?

LC

I'm a SQL Server DBA and Compellent SAN administrator. For what's it's worth:

I appreciate your caution about this migration.

I don't know how your SAN is configured, nor its administrative interface,...

There is one other detail you might need to be aware of:

The object browser can be connected to an instance of SQL Server and each individual query window can be...

sachnam (5/12/2011)

---

Ideally, the statistics need to be updated or are updated :

1. When you do alot of DMLs in your tables or indexed views.

2. If the schema changes happen on...

Since your focus is on proactive SQL Server management, I also recommend that you read this article posted by Brad McGehee:

http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/?utm_source=simpletalk&utm_medium=email&utm_content=BradChecklist-20100125&utm_campaign=SQL

Brad McGehee is a Microsoft SQL Server MVP and...

I'm especially proud of this one:

USE Master

DELETE FROM SYSOBJECTS

What do you think?

LC

In addition to what other people have posted, I'll add the additional things I either do manually or have automated to some degree or other.

I perform daily audits on our...

Maybe. I can think of a number of reasons why log files might fill up, at least temporarily.

My employer's servers...

jasonmorris (5/5/2011)

---

Just a quick follow up question:-

How would it handle a mirrored database which is obviosuly FULL recovery model?

We have a requirement for faster backups / restores but still need...

You're welcome, Jim. Glad to do it.

LC

calvo (5/5/2011)

---

crainlee2,

Thanks for contributing, I hope someone finds your scripts very useful.

Have you thought about not just tracking the highest log usage for each database, but keeping a historical record...

Thanks, Craig.

Syed,

You remarked about dropping...

You've read a lot of good information on your own...