How do you know if there is an open transaction before you restart a server? DBCC OPENTRAN shows the oldest active transaction in your database.
Nested Loops Join: When It Is the Right Choice
Loops in a plan are not always the villain. Count the inner executions and the reads before you force another join type.
SQL SERVER – Fix – Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
Login failed, the user is not associated with a trusted SQL Server connection, Error 18452? Usually it is a wrong username or Windows-only login mode.
SQL SERVER – Check for Database Integrity – Notes from the Field #011
In this Notes from the Field episode, Tim explains why you should check database integrity often, so corruption is caught before it is too late.
Finding What Depends on a Table
Finding What depends on a table starts with sys.dm_sql_referencing_entities, then checks cross-database code and dynamic SQL.
Data Governance: Catalog, Lineage and Data Quality
Data Governance is how you know what data you have, where it came from, who can see it and whether it is right. This post covers the catalog, lineage, access and data quality, with T-SQL checks you can run.
TRUNCATE Permission: Letting a User Empty One Table
Your loader needs to empty a staging table, not redesign it. Here is a small procedure that gives it exactly that.