Compartilhar via


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;...

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