Bhavesh Patel

Bhavesh Patel is a SQL Server database professional with 10+ years of experience. Most of his career has been working on database development and administration. He has a strong interest in continuous learning and likes facing challenges to learn new things. In his spare time, he spends time with his family. Currently, his main role is query tuning with respect to optimization and server performance.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2019 | Rookie of the Year Contender - 2017
Title Category Date
Different Ways to Flush or Clear SQL Server Cache Performance Tuning2026-03-24
Group By in SQL Server with CUBE, ROLLUP and GROUPING SETS Examples TSQL2025-02-05
Refresh Power BI Dataset by Integrating Power Automate in the Report Power BI2022-10-19
Custom Page Navigation in Power BI for Multi-Page Reports Power BI Formatting2022-06-14
Interactive Power BI Reports with a Toggle Button Power BI Charts2022-03-01
SQL Server SET QUOTED_IDENTIFIER and SET ANSI_PADDING Proper Usage Examples TSQL2020-03-19
Prevent SQL Server Blocking using Lock_Timeout Locking and Blocking2020-01-07
SSIS Raw File Source and Destination Example Integration Services Development2019-11-15
Import Text and CSV Files into SQL Server with SSIS Script Task Integration Services Development2019-08-30
SQL Server Logon Trigger Examples Triggers2019-07-26
Pass SSIS Variable from Parent to Child Package Integration Services Development2019-07-03
SSIS Transfer Error Messages and Master Stored Procedures Tasks Integration Services Development2019-04-12
SSIS Zip and Unzip files using 7-Zip Integration Services Development2019-03-19
Find Current Executing SQL Queries Consuming Transaction Log Space Performance Tuning2019-02-21
UPDATE Statement Performance in SQL Server Performance Tuning2019-01-04
Character Map Transformations in SSIS Integration Services Data Flow Transformations2018-11-14
SQL Server Multi Statement Table Value Function (MTVFS) Performance Query Plans2018-10-25
Capturing SSIS Package Errors Using OnError Event Handlers Integration Services Error Handling2018-09-13
Fuzzy Transformation and Fuzzy Grouping in SSIS Integration Services Development2018-08-28
Understanding SQL Server Recompilations Query Plans2018-07-23
Optimize Moving SQL Server Data From One Table to Another Table Performance Tuning2018-07-13
SQL Server error query processor ran out of internal resources and could not produce a query plan Query Plans2018-04-12
SQL Server CTE and XML Recursion Script Scripts2017-11-16
Synchronize Table Data Using a Merge Join in SSIS Integration Services Data Flow Transformations2017-11-08
How to find compiled parameter values for SQL Server cached plans Performance Tuning2017-08-18
Optimize SQL Server Database Restore Performance Restore2017-08-04
Query plan returns NULL when using SQL Server DMV sys.dm_exec_query_plan Query Plans2017-06-16
Validate Integer and Decimal Values in SQL Server Functions User Defined UDF2017-05-11
SQL Server Transaction Remains Open After Stored Procedure Error Error Handling2017-05-02
Clone a SQL Server login and password to a new server Security2017-01-26
Drop SQL Server Views with N Levels of Dependencies Views2017-01-02