Have yet to use it.

I don't mean to be negative at all. This is a great script. However, what this doesn't tell you at all is what the improvement is, how much...

It sounds like you are unfamiliar with debugging what could possibly be slowing down your system.

Are you familiar with SQL Profiler to capture long running queries and then see...

This is sort of on topic but not.

By running this command you will see how fragmented the transaction log is. It is very important to have as few extends...

Sure there is. Here is a table to load and a Stored Proc to load it. Simply schedule this SP to run, once a week or once a...

look at the server application and system log and see what errors the services are throwing. Also locate the ERRORLOG for sql server and see if there is anything...

Yes, I believe I have heard MSDTC is not supported in the Always On configuration. But it will be in SQL 2016.

Works great. Very nice, Thanks!

Great code. I am going to set this up on all of my high profile SQL Servers. Thanks.

It was nice to drive home from work Tuesday and hear a Spring Training game on the radio.

I saw the release from Microsoft a couple of weeks ago about how CU's have been hardened and you are to treat them like SPs... instead of fixes for specific...

We have virtualized almost everything here. With the exception of our large volume I/O ones that service our entire business and are CPU hungry. The small, low data...

My bank doesn't allow special characters either. I found that very odd. One would think banks would have been the absolute first ones to implement strong passwords.

Is it possible to run profiler and see what userid is connecting and running that query?

My banks website refuses to allow special characters in the password. Shameful if you ask me.

Password managers to me are a false sense of security to a certain degree....