A follow-up to my post on hash collisions: DMV queries that help with identifying InMemory OLTP Hash Collisions caused by a poorly chosen bucket count.
SQL SERVER – SQL Profiler vs Extended Events
SQL Profiler or Extended Events? I compare how each one works, why SQL Trace adds overhead on a busy server, and why Extended Events is my choice.
SQL SERVER – FIX – Linked Server Error 7416 – Access to the remote server is denied because no login-mapping exists
Linked Server Error 7416: access to the remote server is denied because no login-mapping exists. What the message means and how to fix the login mapping.
SQL SERVER – Event ID 7000 – The service did not start due to a logon failure
SQL Server did not start after a reboot and the event log showed Event ID 7000, the service did not start due to a logon failure. Here is the cause and the fix.
What is a Master Database in SQL Server? – Interview Question of the Week #076
A reader told me he had dropped his master database. So here is the basic question: what is a master database in SQL Server, and why does it matter?
SQL SERVER – Installation Error – The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive.
Installing SQL Server 2008 SP4 on a cluster failed with: The wrong diskette is in the drive. Here is what the setup logs showed and how we fixed it.
Who Changed This Row? Temporal History With FOR SYSTEM_TIME ALL
Read FOR SYSTEM_TIME ALL with LAG to compare row versions, choose temporal window boundaries, and record an actor when identity matters.