I am sure everyone has realized, when it comes to configure Servers I am the last person that should get near them. I am good
Online Index Operation – Doc Bug –
In SQL Server 2012, Index Online operation is supported for VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX), and XML. However the ALTER INDEX states it is not supported. In
Index_Name Function for SQL Server
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
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
SQL Canada (SQLCAN) 