image

Jaymin Soni

Data Engineer/Architect

  • About Me
  • Resume
  • Blog
  • Contact
Copyright © 2022 Jaymin Soni | ALL RIGHTS RESERVED.
image
Jaymin Soni

All posts by jayminsoni

Microsoft Azure

Incrementally load data from multiple tables in SQL Server to an Azure SQL database

April 30, 2019 jayminsoni
ADFazureAzure Data FactoryIncremental Load
MSSQL

Would you disable CLUSTERED index before bulk insert? Disabling only NON-CLUSTERED indexes for load performance.

February 2, 2019 jayminsoni
bulk insertclustered indexdisablemass insertMSSQLnon-clustered indexsql query
MSSQL

How to avoid cursor in SQL Server stored procedures to loop over records?

April 4, 2018 jayminsoni
avoid cursorMSSQLstored procedureTSQL