The top 5 new features of SQL Server Management Studio 2008, the tool that replaced Enterprise Manager and Query Analyzer, with upgrades DBAs asked for.
SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
Dropped the database your logon trigger writes to? Every login then fails with Error 17892 Logon failed. I recreate the problem and show how to get back in.
SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
Why does a logon trigger on all servers fire several times for one login? The answer: several SQL Server services are running and IntelliSense is on.
Delete Duplicate Rows in SQL Server and Keep One Copy
To delete duplicate rows in SQL Server and keep one copy, number the rows in each group with ROW_NUMBER and delete every row after the first. This post finds the duplicates first, previews the rows that will go, and deletes them inside a transaction while saving a copy of what was removed. It ends with a unique index on a cleaned column, so the same address can’t come back.
SQL Server – Understanding Table Hints with Examples – 2
A plain guide to understanding table hints in SQL Server: the three kinds of hints, what NOLOCK really means, and a checklist before you use one.
SQL SERVER – List Schema Name and Table Name for Database
A quick query on sys.tables with SCHEMA_NAME() that lists the schema name and table name of every table in a database, in bracketed form.
SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You
What does the query optimizer hint ROBUST PLAN do? I explain query hints in simple words and ask you for a practical example of ROBUST PLAN in action.