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 comment 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 SQLM | 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
- AI & ML (1)
- 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
- SQL Error - SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs'
- Python error: while converting Pandas Dataframe or Python List to Spark Dataframe (Can not merge type)
- Clustered Index do "NOT" guarantee Physically Ordering or Sorting of Rows
- SQL Error - The database owner SID recorded in the master database differs from the database owner SID
- Learn SQL
- SQL Error - Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option
- Databricks Notebook error: Your administrator has only allowed sql and scala commands on this cluster.
- SQL Server CURSOR and it's Life Cycle
- Querying Excel 2010 from SQL Server in 64-bit environment
Blog Stats, since Aug 2010
- 5,077,256 hits
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 735 other subscribers
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.