I have a job that polls periodically by calling a stored proc to alert me to new, offline or deleted databases on the servers that I monitor. I have...

Sorry for the confusion. I was waiting for a note saying that no one else had taken the subject. Unfortunately now I am too busy to do the...

KD - This would not work for an AlwaysOn failover because on the secondary all services are always up. I think to get an alert for an AlwaysOn failover...

The code does try to notify of a restart on a cluster. If the SQL cluster is active on nodeA and for some reason you take the cluster offline...

jdbrown - That is a very large table to try to rebuild indexes on. The index size you provided shows that all indexes are about 91 GB so if...

Gerald Britton - That is the first thing that I always ask my clients. What I usually find is that many small and even some larger shops are simply...

Have you had someone submit an article for this? If not, I can take it since I need a new topic to blog on. Let me know.

Julie, By chance is your database used for an app named something like Health Master?

Gila, Here is my error message: Check Catalog Msg 3854, State 1:...

I am certain that syskeys is the right table. The database that I have was just recently upgraded from 2000 to 2005.

Paul or Julie,

I have this exact same error on a client database that I just started managing. Has there been a resolution? If so, what was it?

Thank you...

A boss and co-workers who are supportive and not trying to play office politics.  A business where I do not have to worry about being laid off.

We used Kimball's books recently and were also new to DW. We have been highly praised for our DW design by some very experienced DW people.  Kimball is the way to...

I have jobs that tell me what is going on.  I have one that runs every hour that checks disk space and will both page and e-mail me when free...

Actually, either way will work.  With separating the tables, you will need to put each table into a separate file group.  What you want to concentrate on is physically separating...

Noel,

I agree that column order matters on idexes, but I guess I am trying to go for a covering index.  My thought is why should I have to maintain 2...