1. generally, you should create an index on columns used in your where criteria. Use "database engine tuning advisor" to see what MSSQL suggests

2. "alter index rebuild or "alter index...

Or use something like

select top 10 * from dbo.MyTable

where ActualTime NOT like '0%'

but this construction is a performance killer.

Windows Cluster is a shared-nothing concept, which means the database can only be seen from the active cluster. This is probably on your S: drive. After a failover, your S:...

Lesson: Stop trusting the index tunig advisor. It will always come up with new indexes. There are some scripts on this site which shows the effectiveness of an index (number...

I suggest to ask these consultants what they did. Do you have a SAN administrator in your company? Maybe he implemented some job on the SAN box (i.e. some synchronizing...

Forgot to tell you:

The Active server will be a dedicated server (no VMware), only the passive node wil be virtual.

Thanks for your replies

WOW, describing a DBA job in just a few lines 🙂

Start reading this article:

http://www.sqlservercentral.com/articles/Database+Administration/62480/

This has only to do with the CPU installed on your server. All the MSSQL operations are equal. For an application which uses MSSQL, there's no difference between 32 and...

Besides REBUILDING, there's also REORGANIZING indexes.

As mentioned, there are a lot of articles about rebuilding/reorganizing indexes

Hi,

I prefer a DBCC CheckDB in the weekend, I do a rebuild/reorg and update stats on a daily base, but that's up to you.

Shrinking logfiles is not recommended unless you're...

Try Idera SQLSafe freeware!

I'm confused :hehe: UNION is...

You could use a cursor to select the column names and build a dynamic statement. By using this, you could also commit your statement after each row (which keeps your...

You forgot to backup MASTER, MSDB and MODEL 😀 (also important)

If you want to backup these databases also, you could strip the script to something like this:

exec sp_msforeachdb 'if ''?''<>''tempdb''...

Note: Snapshots are not a backup solution. You cannot backup a snapshot. A a result, you cannot restore a database from a snapshot if your original database is gone.

See http://msdn.microsoft.com/en-us/library/ms189940.aspx...