A script to sync logins between availability group replicas, keeping the SID so users do not orphan on failover. What to copy and what to check after.
Collapsing Repeated Spaces and Line Breaks With REGEXP_REPLACE
Tabs, line breaks and a sneaky character 160 can all hide in a name that looks fine. Here is how to clean them on purpose.
SQL SERVER – Msg 1105 – Could Not Allocate Space for Object Name in Database ‘DB’ Because the ‘PRIMARY’ Filegroup is Full
Msg 1105 says SQL Server could not allocate space for an object because the PRIMARY filegroup is full, even with free disk. Here is how to reproduce and fix it.
SQL SERVER – AlwaysOn Availability Group Backup fn_hadr_backup_is_preferred_replica Not Working Correctly
A client’s backups to the secondary never ran because fn_hadr_backup_is_preferred_replica returned 0 on every node. Here is what I found in its code.
How Many Temporary Tables are Created So Far in SQL Server? – Interview Question of the Week #149
How many temporary tables are created so far in SQL Server? No DMV gives this directly, but here is an easy workaround to find the answer.
SQL SERVER – TCP Provider – An Operation On a Socket Could Not be Performed Because the System Lacked Sufficient Buffer Space or Because a Queue was Full
Sometimes, I am contacted by blog readers via email and trust me, I get to learn something new. One of my blog reader contacted me for below error about buffer space.
Partition Elimination: Proving a Query Reads Only What It Needs
Prove partition elimination with the actual plan, test date predicates, and use $PARTITION to check which slice SQL Server targets.