A few questions:

1) How busy is the server?

In my experience it's not all that unusual for signal waits as a percentage to be unusually high if a server's idle, since...

John Mitchell's approach (a job that periodically checks for new database mirrors) would be the way I would go if automatically changing that setting really were necessary, perhaps because of...

This is probably your best option without any auditing in place. Of course, you'll need those log...

A nice article indeed, Alessandro!

It hit all the major points and required a significantly smaller investment of time and coffee than the white paper at https://msdn.microsoft.com/en-us/library/dn673537.aspx, which coincidentally enough I...

I would also point out that here the amount of memory involved is very ,very low. About 167 MB of total "memory" used, of which only 77 MB was in...

This is one query that should at least get the data as you want it.

It's pretty inefficient, as it requires a couple table scans, so you might want to look...

That message is expected when a database in an AG is started up (on server restart or failover, for example).

If you see that when you are intentionally restarting a...

The primary (sadly, pun intended) advantage of running a normal full backup is that you can leverage differential backups to cut down on backup time and resources used when you...

Koen Verbeeck (3/16/2015)

This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not in 2014....

You can also get some idea of what's been used by querying sys.dm_db_index_usage_stats. That includes information for the last scan, last seek, last lookup, and last update for each index...

It does take an exclusive lock, but only while it is actually altering the database.

Once that's completed, it holds the S lock.

Cheers!

I would also check how you are confirming that the ALTER DATABASE command is actually being executed.

I tested your code to see if there were any strange quirks with...

Just to point out something for the more paranoid of us, I believe Luis' solution assumes that all rows with the same MEMBER_ID use consecutive IDs with no gaps.

If there...

@mbhandari: Glad we could help!

Life got pesky, so it took me longer than I wanted to post the comparison of the IF EXISTS and IF COUNT(*)>0 queries, but...

You would think so, but it didn't when I ran the tests many moons ago. What the OP is seeing is the same thing I remember seeing from my tests.

The...