How to write conditions with CASE statement in a computed column, using a simple AdventureWorks script you can adapt for any complicated logic.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
SQL SERVER – What is WRK file in Log Shipping?
Even if you have used log shipping for years, you may never have noticed the WRK file in log shipping. Here is what I learned about it.
What is Difference Between HAVING and WHERE – Interview Question of the Week #068
Clients sometimes interview me, and my answers from experience do not always match the textbook. Last week’s Interview Question: HAVING versus WHERE.
PowerShell Script – Backup Every Database In SQL Server
A client wanted to automate backups with a script instead of a GUI. Here is the PowerShell and SMO script I have used for years to backup every database.
SQL SERVER – Unable to Open Maintenance Plan in Management Studio
SSMS refused to open a maintenance plan and showed an error instead. Here is what I did when I was unable to open Maintenance Plan in Management Studio.
SELECT One by Two – Why Does SELECT 1/2 Returns 0 – Interview Question of the Week #067
Why does SELECT 1/2 return 0 in SQL Server and not 0.5? Beginners often think it is a bug. Here is the SELECT One by Two answer, explained simply.