Viewing 15 posts - 16 through 30 (of 86 total)
I like your solution, however, that method would NOT show the stored procedures that do NOT have a cached stored procedure plan. The Right JOIN Vignesh used was to...
September 1, 2016 at 10:31 am
Thanks for sharing this procedure. Very useful. However I ran into a problem when executing against a folder with several levels of nested folders. The problem is caused by declaring...
August 18, 2016 at 9:06 am
I'm strictly a DBA so I cannot answer from a developer standpoint. As a DBA I can see several uses for the script. It can show you how big the...
July 18, 2016 at 7:33 am
Excellent script. Thanks for sharing. I did however notice a problem with the ORDER BY. Since the values for FreeSpacePct are VARCHAR, they are sorted by the value of the...
July 14, 2016 at 12:03 pm
You can also get erroneous output if the object_id of an object exists in more than 1 database. In my testing a stored procedure was reported as having last executed...
May 23, 2016 at 8:29 am
Again, thank you for this incredible document. Very helpful. I've had to perform several migrations/upgrades recently and can suggest a few additions to already useful document:
01. In addition to checking...
March 24, 2016 at 1:03 pm
Or this:
SELECT name, create_date FROM sys.procedures WHERE is_auto_executed = 1
Lee
March 24, 2016 at 8:37 am
In your query you have this WHERE clause: select count('x') Total_DeadLock_Count from #error where etext like '%Deadlock encountered ....... Printing deadlock information%'
This causes it to return 0. There are too...
March 4, 2016 at 10:21 am
Excellent scripts! Thanks for sharing them. I did run into one issue however. If the database has multiple data files, the generated sp_attach_db statements do NOT include the additional files....
March 3, 2016 at 1:27 pm
Sathya,
Thanks for sharing the script with us. To add to SQL Guy 1's comment, you should also include I (Differential) to backup types. Thanks again.
Lee
November 25, 2015 at 6:14 am
Dooh! Brain Cramp on my part. My bad. Thanks.
Lee
November 24, 2015 at 7:35 am
Sean,
I created the test table but when I ran your version of Doran script the ONLY data returned was for the queue_messages_xxxxxxxx internal tables with 'Unique Index' shown for the...
November 24, 2015 at 7:16 am
Vasan,
Thanks for taking the time to share this script. Very useful. If I could make a suggestion, would it not be easier to use xp_enumerrorlogs to find the number of...
November 18, 2015 at 7:21 am
Simon,
Excellent script! Thank you for sharing it. May I suggest using this line of code to retrieve the object name:
[Object] = OBJECT_SCHEMA_NAME(qt.objectid,qt.dbid) + '.' +OBJECT_NAME(qt.objectid,qt.dbid),
That would eliminate all the cursor...
October 23, 2015 at 12:02 pm
Thanks for sharing, but I'm not real clear what the intent is.
Lee
August 31, 2015 at 7:49 am
Viewing 15 posts - 16 through 30 (of 86 total)