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
Getting List of All Files and Their Growth Information
SQL Server defaults to growing data files by 1MB and transaction logs by 10%; neither of those are best practice. If your database is small