Viewing 15 posts - 121 through 135 (of 19,564 total)
April 14, 2017 at 3:45 pm
April 14, 2017 at 3:44 pm
In addition to index usage stats, it is sometimes helpful to also query the statistics in the database.
Personally, I use Extended Events to figure out this sort of...
April 14, 2017 at 3:38 pm
April 14, 2017 at 3:23 pm
April 14, 2017 at 2:24 pm
April 14, 2017 at 2:23 pm
alex.sqldba - Friday, April 14, 2017 12:27 PMaha! found it here: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-hadr-cluster-transact-sqlwhilst searching for something unrelated!
Glad you found it.
April 14, 2017 at 2:08 pm
sgmunson - Friday, April 14, 2017 10:14 AMDon't forget to test the installation in some kind of test environment...
+100
April 14, 2017 at 2:05 pm
It is not yet in the Microsoft Git repo, but I would imagine it should get moved at some point.
April 14, 2017 at 12:29 pm
April 14, 2017 at 11:05 am
I would just like to say that you and all the guys at...
April 14, 2017 at 12:51 am
Nice job. I had just finished writing up a similar query for the same reasons. Integrating it into a report would be helpful.
April 12, 2017 at 2:23 am
Ok so the actual relationship is 1 link to many IDs
Here is the execution...
April 12, 2017 at 2:16 am
Viewing 15 posts - 121 through 135 (of 19,564 total)