SQL Canada (@SQLCAN)
Use to be originall called SQL Learnings, but on recommendation from a friend. Going to start using SQLCAN, lets see what I can do with this. Purpose of the blog is to put lessons learned from my experinces in PFE.
Help! I have -2, -3, or -4 Session ID!
We can kill a session by using KILL command. However, KILL command requires a positive number;...
Author: Mohit K. Gupta Date: 06/21/2016
Dissecting SQL Server Execution Plans
I remember my days before, Microsoft SQL Server PFE. I wanted to learn everything and know...
Author: Mohit K. Gupta Date: 05/31/2016
How to get orphaned logins for all databases?
Following script gives you all user database users, that do not have a server login mapped or where...
Author: Mohit K. Gupta Date: 04/04/2016
Changing @@SERVERNAME causes SQL Server Backups to Fail for AlwaysOn Availability Group
One of customers changed the value returned from @@SERVERNAME. SQL Server works no problem,...
Author: Mohit K. Gupta Date: 01/13/2016
sys.foreign_keys does not have matching row in sys.indexes
Running DBCC CHECKDB you are getting following error message: Check Catalog Msg 3853, State 1:...
Author: Mohit K. Gupta Date: 11/19/2015
Index Creation Date
Often when troubleshooting performance related issues, it is beneficial to know when new indexes...
Author: Mohit K. Gupta Date: 10/18/2015
SQL Server 2012 NUMA Node Imbalance–Conclusion
Final post in the series, I hope to summarize my findings for everyone. Thanks for all the...
Author: Mohit K. Gupta Date: 10/04/2015
SQL Server 2012 NUMA Node Imbalance – Cont’d
Yesterday, I had posted an issue I been troubleshooting with memory allocation. That was...
Author: Mohit K. Gupta Date: 10/01/2015
SQL Server 2012 NUMA Node Imbalance
One of my client has been fighting a very strange problem and there is not much literature on the...
Author: Mohit K. Gupta Date: 09/30/2015
Service Principal Names for SQL Server
Service Principal Names (SPN) get used for Kerberos authentication. SQL Server require that all...
Author: Mohit K. Gupta Date: 06/17/2014
A Microsoft SQL Server DMV/DMF Cheat-Sheet
I am asked this question by Microsoft SQL Server customers again and again: “What dynamic...
Author: Mohit K. Gupta Date: 05/24/2012
Adventures in Installing the SQL Server AdventureWorks Sample Database
I was thinking of writing an article about Microsoft SQL Server T-SQL Basics; however, in order to...
Author: Mohit K. Gupta Date: 11/07/2011