Read a workload capture by grouping related queries, comparing total resource use, and separating one slow execution from repeated work.
SQL SERVER – Reverse String Word By Word
A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.
SQL SERVER – Customization of New Query in SQL Server Management Studio
A junior DBA was fired for dropping a table on production. Here is how to customize the New Query window in SSMS so it opens with the commands you need.
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run
After a backup restore mistake, SQL Server would not start and ERRORLOG said the database ‘model’ is marked RESTORING. This is how I got it running again.
SQL SERVER – User Defined Audit with SQL Server
Bank security checks taught me patience about audits. Here is how a user defined Audit in SQL Server lets you write your own events to the audit log.
Why SELECT 28F3 Returns 28: Float Literals and Hidden Aliases
Explain float literals, why SELECT 28F3 creates an alias, how 28E3 uses scientific notation, and why explicit AS prevents confusion.
SQL SERVER – Unable to Restore From Backup After Detach Operation
A young guy came to me and said – “I found a bug in SQL Server Restore”. How to fix Unable to Restore From Backup After Detach Operation.