Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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;...
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...
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...
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,...
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:...
Date: 11/19/2015
Index Creation Date
Often when troubleshooting performance related issues, it is beneficial to know when new indexes...
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...
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...
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...
Date: 09/30/2015
Service Principal Names for SQL Server
Service Principal Names (SPN) get used for Kerberos authentication. SQL Server require that all...
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...
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...
Date: 11/07/2011