Viewing 15 posts - 1 through 15 (of 86 total)
This may be useful:
https://qa.sqlservercentral.com/scripts/sql-server-performance-base-line-script
Lee
May 9, 2019 at 12:59 pm
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...
November 20, 2018 at 1:32 pm
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...
November 19, 2018 at 7:36 am
Thanks for taking the time to develop and share this code. Very useful.
I have run into an issue that has me stumped. When I run the...
November 16, 2018 at 1:36 pm
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...
June 20, 2018 at 8:29 am
Patrick,
Thanks for posting. This is a very useful script.
Lee
February 27, 2018 at 6:41 am
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...
June 22, 2017 at 6:57 am
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...
May 24, 2017 at 8:52 am
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...
May 24, 2017 at 8:35 am
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...
May 16, 2017 at 8:58 am
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:...
April 20, 2017 at 7:18 am
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...
March 22, 2017 at 2:05 pm
You might want to filter on just capturing rows with 'sa' as the login name. Also, if you want to query ALL the default trace files you need to remove...
November 3, 2016 at 9:24 am
Angel, Thanks for taking the time to share this with us. I did run into one problem with the script. On some servers I would get this error message:
Msg 8152,...
September 30, 2016 at 6:18 am
Thanks for taking the time to share this with everyone. I did run into a problem though. I would get an error message similar to this:
Msg 567, Level 16, State...
September 13, 2016 at 7:35 am
Viewing 15 posts - 1 through 15 (of 86 total)