Monthly Archives: December 2013

T-SQL: Simplified CASE expression

My last article is providing in depth tutorial about these statements: ISNULL COALESCE IIF CHOOSE The main purpose of introducing these statements is improving code readability and achieving cleaner code. Using these statements may result to poor performance in some … Continue reading

Posted in Best Practices, Joy of T-SQL, T-SQL Tips & Tricks

[Fixed] SSMS – Create script duplicates the statements for Grant or Deny Column Permissions…

I was reported a bug in Microsoft SQL Server (all versions) that related to generate script for database permissions on August 20, 2013. Steps to Reproduce Open SSMS >> Connect to Server >> In Object Explorer expand a Sample Database … Continue reading

Posted in Database Administration, SQL General Information