After my SELECT One by Two puzzle, I played with a small extension: three queries mixing 1. and 1/2. Can you guess what each one returns and why?
Understanding Database Scalability – Vertical and Horizontal
One server with 64 cores or two with 32 cores? A customer asked me to help decide. Here is a simple look at Database Scalability, vertical and horizontal.
SQL SERVER – Computed Column and Conditions with Case Statement
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.