Interview Questions



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

  1. Gayatri
    December 27, 2011 at 11:47 am

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

  2. Ajay
    December 24, 2017 at 6:09 pm

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

  3. May 7, 2018 at 11:36 am

    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

  4. Manoja
    October 27, 2020 at 11:05 pm

    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 “

  5. November 15, 2020 at 10:37 am

    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

      Waiting for your post. Thanks Manoj

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: