Batch Archives - SQL Authority with Pinal Dave

Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?

January 25, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Batch, SQL Extended Events

Some of the learnings can lead to another exploration when someone does stump you with something you didn’t know. To understand the basics of batch mode and row mode, read the blog SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode where I have explained the concepts. This…

SQL SERVER – Combined Multiple .SQL files into One Single File

October 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Batch

Here is an interesting problem which I enjoyed solving yesterday. There were multiple SQL Files in my one folder. When I had to send it to my friend I had to collect all the files into a folder and zip it to send it via email. My friend who was…