In this blog post, we are going to talk about how to undo human errors in SQL Server with the help of Point in Time Recovery. Let us learn today.
Solve Puzzle about Data type – SQL in Sixty Seconds #108
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback.
How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290
Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? One of the most popular questions, I often receive from my client.
Do MAX(col) Scan Table? – SQL in Sixty Seconds #106
While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.
Rollback TRUNCATE – Script – SQL in Sixty Seconds #105
One of the most popular questions, I keep on receiving is that – Is it possible to Rollback Truncate operation? The answer is YES.
SQL SERVER – Offline, Detach and Drop – Differences – SQL in Sixty Seconds #103
if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences.
Are Not Equal to Operators Equal to Not In? – SQL in Sixty Seconds #102
What I love most about my job, is that I get to work with different people and answer questions. Are Not Equal to Operators Equal to Not In?