Ben Snaidero

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
MSSQLTips award

MSSQLTips award

2017 Awards
MSSQLTips award

MSSQLTips award

2016 Awards
MSSQLTips award

MSSQLTips award

2015 Awards

MSSQLTips award

2014 Awards
MSSQLTips award

MSSQLTips award

2013 Awards
MSSQLTips award

MSSQLTips award

Auditing and Compliance

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

Availability Groups

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

Backup

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)

Clustering

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

Data Types

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

Database Administration

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

Database Configurations

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

Database Design

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)
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)

Fragmentation and Index Maintenance

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

Functions - System

Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions (last update: 8/21/2013)

Hardware

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

Import and Export

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)

In-Memory OLTP

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)

Indexing

Identify SQL Server Indexes With Duplicate Columns (last update: 5/1/2015)
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)

Integration Services Control Flow Transformations

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

Linked Servers

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

Locking and Blocking

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)

Maintenance

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)

Monitoring

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)

Other Database Platforms

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

Paging

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

Partitioning

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

Performance Tuning

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)
SQL Server Query Performance Guidelines Tutorial (last update: 2/26/2014)
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)
Using SolarWinds Database Performance Analyzer to Diagnose Performance Issues (last update: 9/14/2017)

PowerShell

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

Profiler and Trace

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)

Query Optimization

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)

Query Plans

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

Security

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)

SQL Server 2016

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

SQL Server Agent

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

T-SQL

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 Server CTE vs Temp Table vs Table Variable Performance Test (last update: 9/4/2018)
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)

Table Valued Parameters

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

Triggers

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

XML

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

More SQL Server Solutions

download

get free sql tips