Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

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.

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 (2/24/2017)

Availability Groups

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

Backup

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

Clustering

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

Data Types

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

Database Administration

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

Database Configurations

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

Database Design

Compare SQL Server Page Splits for INT vs BIGINT vs GUID Data Types (11/16/2017)
Compare SQL Server Table Join Performance for INT vs BIGINT vs GUID Data Types (10/19/2017)
Solving the SQL Server Multiple Cascade Path Issue with a Trigger (8/7/2012)
SQL Server Performance Comparison INT versus GUID (9/29/2017)
Surrogate Key vs Natural Key Differences and When to Use in SQL Server (4/16/2018)
Using DELETE CASCADE Option for Foreign Keys (8/1/2012)

Fragmentation and Index Maintenance

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

Functions - System

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

Hardware

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

Import and Export

Options to Improve SQL Server Bulk Load Performance (12/31/2014)

In-Memory OLTP

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

Indexing

Identify SQL Server Indexes With Duplicate Columns (5/1/2015)
SQL Server Column Store Index Performance (9/1/2015)
SQL Server Index Column Order - Does it Matter (6/20/2012)
SQL Server Insert Performance for Clustered Indexes vs. Heap Tables (7/7/2017)
SQL Server Query Performance After Index Maintenance for Reorganization vs Rebuild Operations (3/3/2015)

Integration Services Control Flow Transformations

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

Linked Servers

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

Locking and Blocking

Find Blocking Processes Using SQL Server Profiler (9/27/2016)
Using a Clustered Index to Solve a SQL Server Deadlock Issue (10/28/2011)

Maintenance

Monitoring

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

Other Database Platforms

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

Paging

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

Partitioning

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

Performance Tuning

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

PowerShell

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

Profiler and Trace

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

Query Optimization

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

Query Plans

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

Security

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

SQL Server 2016

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

SQL Server Agent

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

T-SQL

Best Practices For Deleting SQL Server Data (12/2/2015)
Comparing performance for the MERGE statement to SELECT, INSERT, UPDATE or DELETE (4/19/2012)
SQL Server Stored Procedure to Safely Delete Data (4/20/2016)
SQL Server Temp Table vs Table Variable Performance Testing (3/14/2018)
Testing SQL Server Performance of Database Inserts and Updates (3/17/2016)

Table Valued Parameters

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

Triggers

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

XML

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

More SQL Server Solutions