Thank you for a great article. This made the process so much clearer to me. Thanks again.

Lee

Thank you for posting this solution. However, I ran into an issue and received. this error:

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from...

Thanks for the swift reply. I have now looked at that idea but found that although we use CommVault for backups, we are not using it on all of our...

This may be useful:

https://www.sqlservercentral.com/scripts/sql-server-performance-base-line-script

Lee

That is very true. I did run into that also but at least it did not throw an error. Thanks for the heads up. 
I really like this script and...

Toby,

Thanks so much for the quick response.
I tried your excellent suggestions and found that the 2nd approach using REPLACE fixed my problem perfectly.
I have...

Yusuf,
Thank you for sharing this script. However I ran into to some problems where it returned way too many rows. The issue is that sys.indexes and sys.objects are database...

Patrick,
Thanks for posting. This is a very useful script.

Lee

Thanks Allan for taking the time to share this with us.
I was wondering if it would be easier to use the msdb.dbo.agent_datetime function  to replace all that code...

Eric,

Sorry, but one other thing. In your example output for 2015 several of the Monday holidays are showing 5 for the DayOfWeek value and Presidents Day is showing...

Eric,
Thanks for taking the time to share this code with us. Very handy. I am confused though with the New Years Day computations. You have these 2 lines:
when...

Thanks for taking the time to share this with us. Great script. I did however find one issue that was easily fixed though. The same index name can exist in...

Thank you for taking the time to share this with us. I made 2 minor changes though to restrict the output to just the current database:
1. I changed this:...

Thanks Jim for a very handy script. I did notice a few minor 'gotchas' though. Nothing major:
1. If the UDF name is included ONLY as a COMMENT in the...