Performance
6. SQL Server 2012 (a.k.a. Denali) – Best Practices Analyzer
5. Using CROSS APPLY & OUTER APPLY operators with UDFs, Derived tables & XML data
4. Clustered Indexes, Non Clustered Indexes & why?
3. Avoid CURSORS? why not use them optimally…
2. UNION vs UNION ALL | which one is faster?
1. Why UNION ALL is faster than UNION?
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
Informatica
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
Polybase
PRIMARY KEY
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
XML
XML SQL
Categories
- Big Data (12)
- Apache Spark (5)
- Hadoop (5)
- DBA Stuff (35)
- Interview Q (8)
- Microsoft Azure (36)
- Azure Data Factory (1)
- Azure DevOps (2)
- Cosmos DB (5)
- Databricks (6)
- MS BI (9)
- Analysis Services (1)
- DW and BI (1)
- Integration Services (1)
- Power BI (4)
- Reporting Services (2)
- Tabular Model (1)
- Others (199)
- Blockchain (1)
- Certifications (9)
- Cloud Computing (1)
- Cpp (32)
- Cpp Graphics (21)
- Excel (10)
- Informatica (5)
- Java (56)
- Linux (8)
- Microsoft (14)
- MS.net (2)
- Oracle (1)
- Powershell (3)
- Python (4)
- Reviews (5)
- Security (1)
- Spark SQL (2)
- SQL Server (7)
- SQLwithManoj (11)
- 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 (136)
- 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 Express (1)
- T SQL (182)
- Differences (31)
- JSON (6)
- Misconception (7)
- Optimization Performance (13)
- SQL Basics (15)
- SQL Built-in Functions (6)
- SQL Errors (44)
- SQL Tips (67)
- SQL Trivia (9)
Archives
Top Posts
- C++ Program to implement Toll Tax Problem by using CLASS Access Specifiers and SWITCH CASE - Q12
- C++ Graphics - 02 - Line program by Incremental Algorithm
- SQL Error - The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE
- Download & Install SQL Server Management Studio (SSMS) 2016 (decoupled from SQL Server engine setup)
- Reading JSON string with Nested array of elements | SQL Server 2016 - Part 3
- SQL Error - Windows could not start the SQL Server (MSSQLSERVER) on Local Computer (moved Master DB)
- SQL Error - The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
- SQL DBA - Windows could not start the SQL Server... refer to service-specific error code 17051 - SQL Server Evaluation period has expired
- Getting started with SQL Server 2014 | Download and Install Free (Express) or Full version
- Powershell error - The term 'Login-AzureRmAccount' is not recognized as the name of a cmdlet, function, script file, or operable program
Blog Stats, since Aug 2010
- 4,496,614 hits
StatCounter …since April 2012

Leisure blog: Creek & Trails
- I got full refund of my flight tickets during COVID lockdown (AirIndia via MakeMyTrip)
- YouTube – Your Google Ads account was cancelled due to no spend
- YouTube latest update on its YPP (YouTube Partner Program) which may affect your channel
- Starting your own blog !!!
- How to file ITR (Income Tax Return) online AY 2017-18 (for simple salaried)
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.
I am using XML Data type and want to index on it but read somewhere that if CROSS APPLY is used, we cannot index the column. is CROSS APPLY required if we index?