Interview Questions

Leave a comment Go to comments

SQL Server Interview Questions:

5. SQL Server Interview Questions – Part 5

4. SQL Server Interview Questions – Part 4

3. SQL Server Interview Questions – Part 3

2. SQL Server Interview Questions – Part 2

1. SQL Server Interview Questions – Part 1

Comments (7) Trackbacks (0) Leave a comment Trackback

Gayatri

December 27, 2011 at 11:47 am

Reply

step by step process for Sync-Initilizing Snapshot from Backup with scripts.
Ajay

December 24, 2017 at 6:09 pm

Reply

HI Sir, DO you also Give SQL and power BI Classes
Minny

May 7, 2018 at 11:36 am

Reply

Hello There,

Your blog is such a complete read. I like your approach with SQL Server Interview Questions:. Clearly, you wrote it to make learning a cake walk for me.

I would like to running C program is full screen and Meteor shower Effect.

I am so grateful for your blog. Really looking forward to read more.

Many Thanks,
Minny
Manoja

October 27, 2020 at 11:05 pm

Reply

Hi Manoj,
I have a question below, could you please answer in detail
“What is the need for a right join when a left join does the same thing if we reverse table order “
Manoj Pandey

November 15, 2020 at 10:37 am

Reply

Yes you are right, a RIGHT JOIN can be replaced simply by LEFT JOIN by switching tables, and there is no performance impact using either of them. But there are certain use cases where this can let you write simpler and cleaner code just by introducing RIGHT JOIN instead of refactoring your code by swapping tables and JOIN conditions. Will write a blog post on this to show a complex scenario made simple by using this type.
- Manoja
  
  November 16, 2020 at 3:55 pm
  
  Reply
  
  Waiting for your post. Thanks Manoj
Veer Taran

December 10, 2021 at 4:41 pm

Reply

Hi, Thank you for this informative blog, I have just started to learn sql online and this is a nice collection regarding interviews questions.