Ben Snaidero

Ben Snaidero has been a Database Administrator for just over 10 years. Starting out working mainly with Oracle he got into SQL Server in 2005 and has worked primarily with SQL Server for the last 3 years. His main focus with both Oracle and SQL Server is in the area of performance tuning.

2018 Awards
  

2017 Awards
  

2016 Awards
  

2015 Awards
  

2014 Awards
  

2013 Awards
  

• Audit SQL Server Logins Using SQL Profiler (last update: 2/24/2017)
  

• Monitor SQL Server AlwaysOn Availability Groups (last update: 1/4/2012)
  

• Options to Improve SQL Server Backup Performance (last update: 11/17/2011)
  
• Testing SQL Server Backup Performance with Trace Flag 3042 (last update: 5/11/2015)
  

• Use Powershell to Send Email Notification for SQL Server Cluster Failover (last update: 1/15/2014)
  

• Comparing SQL Server and Oracle datatypes (last update: 4/25/2013)
  

• Capture SQL Server Schema Changes Using the Default Trace (last update: 10/9/2015)
  

• Adjust TARGET_RECOVERY_TIME to Reduce SQL Server IO Spikes (last update: 11/4/2016)
  

• Compare SQL Server Page Splits for INT vs BIGINT vs GUID Data Types (last update: 11/16/2017)
  
• Compare SQL Server Table Join Performance for INT vs BIGINT vs GUID Data Types (last update: 10/19/2017)
  
• Comparing SQL Server CPU usage with arithmetic for float versus numeric datatypes (last update: 12/11/2018)
  
• Solving the SQL Server Multiple Cascade Path Issue with a Trigger (last update: 8/7/2012)
  
• SQL Server Performance Comparison INT versus GUID (last update: 9/29/2017)
  
• SQL Server Performance Testing for Check Constraint vs Foreign Key (last update: 4/21/2020)
  
• Surrogate Key vs Natural Key Differences and When to Use in SQL Server (last update: 4/16/2018)
  
• Using DELETE CASCADE Option for Foreign Keys (last update: 8/1/2012)
  

• Rebuilding SQL Server indexes using the ONLINE option (last update: 1/31/2012)
  

• Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions (last update: 8/21/2013)
  
• Using the SQL ISNULL() Function (last update: 3/18/2021)
  

• Gather Storage Subsystem Performance Metrics Using the Diskspd Utility for SQL Server Applications (last update: 3/24/2017)
  

• Compare PUSH vs PULL Data Copy Performance in SQL Server (last update: 10/17/2018)
  
• Options to Improve SQL Server Bulk Load Performance (last update: 12/31/2014)
  

• Compare SQL Server Performance of In-Memory vs Disk Tables (last update: 9/25/2014)
  
• Comparing Performance of In Memory table vs Regular Disk Table Part 2 (last update: 10/30/2014)
  
• SQL Server In-Memory Tables Impact on Startup and Recovery (last update: 10/2/2014)
  

• Identify SQL Server Indexes With Duplicate Columns (last update: 5/1/2015)
  
• Importance of Update Statistics in SQL Server (last update: 2/3/2021)
  
• SQL Server Column Store Index Performance (last update: 9/1/2015)
  
• SQL Server Index Column Order - Does it Matter (last update: 6/20/2012)
  
• SQL Server Insert Performance for Clustered Indexes vs. Heap Tables (last update: 7/7/2017)
  
• SQL Server Query Performance After Index Maintenance for Reorganization vs Rebuild Operations (last update: 3/3/2015)
  
• Types of SQL Server Indexes (last update: 12/24/2019)
  

• Using the Data Profiling SQL Server Integration Services Task (last update: 1/16/2013)
  

• Configure Generic SQL Server Linked Server Names (last update: 12/22/2011)
  

• Find Blocking Processes Using SQL Server Profiler (last update: 9/27/2016)
  
• Using a Clustered Index to Solve a SQL Server Deadlock Issue (last update: 10/28/2011)
  
• Why is INDEX REORGANIZE and UPDATE STATISTICS causing SQL Server blocking? (last update: 1/17/2019)
  

• SQL Server Query Performance After Index Maintenance for Reorganization vs Rebuild Operations - Part 2 (last update: 4/23/2015)
  
• Using WITH ROWCOUNT and PAGECOUNT option of SQL Server UPDATE STATISTICS (last update: 1/30/2013)
  

• Automate Alerting for SQL Server Suspect Database Pages (last update: 1/25/2016)
  
• Automate SQL Server Monitoring with Email Alerts (last update: 12/8/2011)
  
• Monitoring SQL Server 2012 - Capture and Parse sp_server_diagnostics output (last update: 4/3/2014)
  
• SQL Server Monitoring Checklist (last update: 10/19/2011)
  
• SQL Server Performance Troubleshooting Database Health Checklist (last update: 3/16/2018)
  
• SQL Server Performance Troubleshooting System Health Checklist (last update: 2/26/2018)
  
• Using Powershell to Monitor the SQL Server system_health Extended Event Session (last update: 3/11/2014)
  
• Using SolarWinds Database Performance Analyzer to Diagnose Performance Issues (last update: 10/22/2020)
  

• Comparing SQL Server and Oracle background processes (last update: 6/28/2013)
  

• Comparing performance for different SQL Server paging methods (last update: 5/15/2012)
  

• Archiving SQL Server data using partitioning (last update: 10/11/2012)
  
• How to Partition an existing SQL Server Table (last update: 2/21/2013)
  

• Analyzing SQL Server Performance Impact of Parameter Sniffing (last update: 2/24/2016)
  
• Collecting and Storing Poor Performing SQL Server Queries for Analysis (last update: 2/7/2012)
  
• How Incorrect SQL Server Table Statistic Estimates Can Cause Slow Query Execution (last update: 1/23/2017)
  
• Removing Function Calls for Better Performance in SQL Server (last update: 7/10/2012)
  
• SQL Server Performance Impact of Querying Unnecessary Columns (last update: 12/6/2017)
  
• Testing SQL Server Query Performance Using Different Levels of Parallelism (last update: 8/8/2014)
  
• Tuning SQL Server Code with T-SQL Commands (last update: 9/22/2014)
  
• Using a SQL Server Explain Plan to View Cached Query Plan Parameters in Management Studio (last update: 12/13/2016)
  
• Using DBCC DROPCLEANBUFFERS When Testing SQL Server Performance (last update: 6/9/2014)
  

• Monitor a SQL Server Cluster using PowerShell (last update: 1/27/2014)
  

• Associate a SQL Profiler Trace With Performance Monitor Data (last update: 11/21/2016)
  
• Configure SQL Server Distributed Replay feature (last update: 10/22/2013)
  
• Find Long Running SQL Server Queries Using Profiler (last update: 8/5/2016)
  
• How to Replay a SQL Server Trace on a Different Server (last update: 11/14/2016)
  
• Using the REPLAY feature within SQL Server Profiler (last update: 9/18/2013)
  
• Using the SQL Server Distributed Replay feature (last update: 11/1/2013)
  

• How column COLLATION can affect SQL Server query performance (last update: 4/24/2014)
  
• How to Change the COLLATION of a SQL Server Column (last update: 5/2/2014)
  

• Checking SQL Server Query Cardinality Estimator Version (last update: 4/27/2017)
  

• Register a SPN for SQL Server Authentication with Kerberos (last update: 5/3/2013)
  
• SQL Server Transparent Data Encryption (TDE) Performance Comparison (last update: 3/6/2012)
  

• Test Performance Overhead of SQL Server Row Level Security (last update: 3/3/2016)
  

• SQL Server Agent History Custom Purge (last update: 10/30/2012)
  

• Compare SQL Server Stored Procedure Performance for Table Valued Parameters vs Multiple Variables (last update: 1/27/2015)
  

• Using a DDL Trigger to Block Schema Changes in SQL Server (last update: 3/29/2012)
  

• Best Practices For Deleting SQL Server Data (last update: 12/2/2015)
  
• Comparing performance for the MERGE statement to SELECT, INSERT, UPDATE or DELETE (last update: 4/19/2012)
  
• SQL Convert Function Examples and Alternatives (last update: 1/20/2022)
  
• SQL ORDER BY Clause (last update: 5/26/2021)
  
• SQL Server CTE vs Temp Table vs Table Variable Performance Test (last update: 9/4/2018)
  
• SQL Server LIKE Examples (last update: 1/28/2021)
  
• SQL Server Stored Procedure to Safely Delete Data (last update: 4/20/2016)
  
• SQL Server Temp Table vs Table Variable Performance Testing (last update: 3/14/2018)
  
• Testing SQL Server Performance of Database Inserts and Updates (last update: 3/17/2016)
  

• SQL Server Performance Comparison - Storing XML data in-row versus out-of-row (last update: 12/18/2013)