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
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
ETL with Azure: Buy here
Apache Spark books:
- Spark: The Definitive Guide
- Learning Spark 2Ed
SQL Server - Certification exam books:
- TSQL: 70-761 , 70-762
- DBA: 70-764 , 70-765
- DW/BI: 70-767
Apache Spark books:
- Spark: The Definitive Guide
- Learning Spark 2Ed
SQL Server - Certification exam books:
- TSQL: 70-761 , 70-762
- DBA: 70-764 , 70-765
- DW/BI: 70-767
SQL Tags
annual report Apache Spark APPLY Operator Azure Databricks BCP Clustered Index ColumnStore Index Cpp CROSS APPLY Databricks Denali Download SQL Server Excel Exception Handling FileTables Graphics in Cpp Hekaton Hekaton 2014 IDENTITY In-Memory Tables Install SQL Server Java Applet Programs Java Basic Programs Java File Handling Java IO Programs Java OO Programs JSON JSON SQL Linked Server msdb MSDN TSQL forum multiple values to Stored Procedures PRIMARY KEY Python Runnable Interface sp_configure SQL Agent SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server Certification SQL Server Interview Questions SQL Server on Linux Stored Procedure Temporary Tables TRY-CATCH WordPress Annual Report XML XML SQL
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
Categories
- Big Data (13)
- Apache Spark (6)
- Hadoop (5)
- DBA Stuff (37)
- Interview Q (8)
- Microsoft Azure (37)
- Azure Data Factory (1)
- Azure DevOps (2)
- Cosmos DB (5)
- Databricks (7)
- MS BI (9)
- Analysis Services (1)
- DW and BI (1)
- Integration Services (1)
- Power BI (4)
- Reporting Services (2)
- Tabular Model (1)
- Others (205)
- Blockchain (1)
- Certifications (9)
- Cloud Computing (1)
- Cpp (32)
- Cpp Graphics (21)
- Excel (10)
- Informatica (5)
- Java (56)
- Linux (8)
- Microsoft (15)
- MS.net (2)
- Oracle (1)
- Powershell (3)
- Python (6)
- Reviews (5)
- Security (1)
- Spark SQL (3)
- SQL Server (9)
- SQLwithManoj (12)
- Uncategorized (7)
- VBA Macro (1)
- Visual Studio (1)
- Windows (6)
- SQL Server Conferences (1)
- SQL Server Internals (85)
- Datatypes (5)
- DB Concepts (28)
- Indexes (11)
- JOINS (4)
- ML Python (2)
- SQL DB Engine (8)
- SQL Server Migration (1)
- SQL Server Upgrade (1)
- Stored Procedures (11)
- tempdb (3)
- XML (16)
- SQL Server Questions (41)
- SQL Server Versions (137)
- SQL Azure (4)
- SQL Server 2005 (7)
- SQL Server 2008 (5)
- SQL Server 2012 (33)
- SQL Server 2014 (18)
- SQL Server 2016 (50)
- SQL Server 2017 (20)
- SQL Server 2019 (2)
- SQL Server 2022 (1)
- SQL Server Express (1)
- T SQL (184)
- Differences (31)
- JSON (6)
- Misconception (7)
- Optimization Performance (14)
- SQL Basics (15)
- SQL Built-in Functions (6)
- SQL Errors (45)
- SQL Tips (67)
- SQL Trivia (9)
Archives
Top Posts
- SQL Error - The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE
- Reading JSON string with Nested array of elements | SQL Server 2016 - Part 3
- SQL DBA - Windows could not start the SQL Server... refer to service-specific error code 17051 - SQL Server Evaluation period has expired
- Python error: while converting Pandas Dataframe or Python List to Spark Dataframe (Can not merge type)
- Using IDENTITY function with SELECT statement in SQL Server
- Spark - Cannot perform Merge as multiple source rows matched...
- SQL Error - SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs'
- New syntax option "IF EXISTS" with DROP and ALTER statements - in SQL Server 2016
- SQL DBA - Query to check Status of last running SQL Jobs
- Databricks Notebook error: Your administrator has only allowed sql and scala commands on this cluster.
Blog Stats, since Aug 2010
- 4,953,649 hits
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
Disclaimer
This is my personal blog site.
The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MS Books On Line and/or MSDN/TechNet.
My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have documented my personal experience on this blog.
Join 802 other subscribers
SQL with Manoj 
step by step process for Sync-Initilizing Snapshot from Backup with scripts.
HI Sir, DO you also Give SQL and power BI Classes
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
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 “
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.
Waiting for your post. Thanks Manoj
Hi, Thank you for this informative blog, I have just started to learn sql online and this is a nice collection regarding interviews questions.