We have the database_name, object_name, object_schema_name but don’t have index_name. So when accessing information in sys.dm_db_index_usage stats, it becomes troublesome to find out index name
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
Login failed. The login is from an untrusted domain…
Troubleshooting Failed Login, login is from an untrusted domain and cannot be used with windows authentication.
A Microsoft SQL Server DMV/DMF Cheat-Sheet
I am asked this question by Microsoft SQL Server customers again and again: “What dynamic management views (DMV) or dynamic management functions (DMF) should I
PAL (Performance Analysis of Logs) Issues
Created few issues on http://pal.codeplex.com for the new functionality added in version 2.2. Where you can enter in SQL Server Instance name in a dialog
Creating a Simple Counter List in PAL (Performance Analysis of Logs)
In my previous post, I talked about how implement the counters in Windows 2003. However I went about getting the list of counters from PAL
Getting List of Top Queries by Query Hash
Starting SQL 2008, we have had Query Hash column in sys.dm_exec_query_stats. It helps group common queries together, because when SQL Server is generating execution plan
SQL Canada (SQLCAN) 