Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is […]
SQL in Sixty Seconds
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – […]
Compressed Backup and Performance – SQL in Sixty Seconds #196
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that can […]
Pinned Tab – SSMS Efficiency Tip – SQL in Sixty ...
This is a follow up of my earlier blog which got instant popular Split Screen for SSMS […]
Recent Execution of Stored Procedure – SQL in Sixty Seconds ...
What I enjoy the most is working with different clients on Comprehensive Database Performance Health Check. Every […]
Recover Crashed Query in SSMS – SQL in Sixty Seconds ...
Has it ever happened to you when you are working on a large SQL Server query and […]
Activity Monitor and Running Query – SQL in Sixty Seconds ...
Activity Monitor can come handy when you are in trouble as well. In this video, we will […]
Email an Execution Plan – SQL in Sixty Seconds #114
Most part of my day is spent doing Comprehensive Database Performance Health Check with different organizations. During […]
Execution Plan – Estimated vs Actual – SQL in Sixty ...
During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution […]
Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. […]
Single Column Single Row and TABLE SCAN – SQL in ...
Can a single column and single row result do an entire table scan? I recently got this […]
Undo Human Errors in SQL Server – SQL in Sixty ...
In this blog post, we are going to talk about how to undo human errors in SQL […]
Solve Puzzle about Data type – SQL in Sixty Seconds ...
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged […]
Move TempDB for Performance – SQL in Sixty Seconds #107
Just another day while working with a client Comprehensive Database Performance Health Check, we figured out that […]
SQL SERVER – Live Query Statistics – SQL in Sixty ...
It is very easy to know what is the queries past and future with the help of […]
SQL SERVER – Offline, Detach and Drop – Differences – ...
During the recent consulting engagement of Comprehensive Database Performance Health Check, I was asked by my client, […]
Are Not Equal to Operators Equal to Not In? – ...
What I love most about my job Comprehensive Database Performance Health Check, is that I get to […]
Negative Identity Column – SQL in Sixty Seconds #101
I had a very interesting story to tell about a negative identity column from my recent Comprehensive […]
List All Parallel Queries – SQL in Sixty Seconds #098
During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query […]
Keyword Join or Inner Join – SQL in Sixty Seconds ...
Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same […]
Alter Index Add Column – Workaround – SQL in Sixty ...
During the recent Comprehensive Database Performance Health Check, I identified at my client’s place that we needed […]
Fastest Way to Retrieve Rowcount for a Table – SQL ...
Whenever I am helping my clients with their SQL Server Performance Comprehensive Database Performance Health Check, every […]
Where are Table Variables Stored? – SQL in Sixty Seconds ...
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted few […]
Install MongoDB on Windows – SQL in Sixty Seconds #091
SQL Server is my passion and I have been keeping busy most of the time in my […]
Creating Covering Index to Eliminate Join – SQL in Sixty ...
Last week, I had published Remove Bookmark Lookup – SQL in Sixty Seconds #089 and I got […]