Products
Overview
Monitoring Features
Database Monitoring
SQL Sentry
DataOps
Task Factory
Database Mapper
DBA xPress
Free Tools
Plan Explorer
Solutions
By Role
DBAs
IT Managers
BI Pros
Leaders
Monitoring
SQL Server
Azure SQL Database
SSAS
VMware
Windows Hyper-V
DataOps
Overview
Data Integration
Documentation
Data Lineage Analysis
Cloud Migration
AWS
Azure
How To Buy
Download Free Trials
Schedule Demo
Request Quote
Product Pricing
SentryOne Resellers
Resources
Blog
Webinars
Events
Resource Library
Popular Topics
SQLPerformance.com
Support
Documentation
Support Overview
Submit a Support Case
Support Community
Pro Services
Product Renewal
Partners
Find a Partner
Partner Portal Login
About
Overview
Our Team
Our News
Locations
Careers
My Account
Download Free Trial
Quote
Blog Home
SentryOne Newsletter
Authors
Categories
Category: Execution Plans (3)
#BackToBasics: DATEFROMPARTS()
Aaron Bertrand continues his #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.
July 6, 2016
|
Aaron Bertrand
|
Execution Plans
,
#BackToBasics
,
T-SQL
0
Rob Farley: What's "Actually" going on with that Seek?
Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE..
June 10, 2016
|
SQLPerformance.com
|
Execution Plans
,
Plan Explorer
0
#BackToBasics: An Updated Kitchen Sink Example
Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
June 1, 2016
|
Aaron Bertrand
|
Execution Plans
,
#BackToBasics
,
T-SQL
3
STRING_SPLIT() in SQL Server 2016 : Follow-Up #2
Aaron Bertrand shows that, at least for a large number of...
April 22, 2016
|
SQLPerformance.com
|
Execution Plans
,
T-SQL
,
STRING_SPLIT
0
STRING_SPLIT() in SQL Server 2016: Follow-Up #1
Aaron Bertrand follows up on a recent post about the performance...
April 19, 2016
|
SQLPerformance.com
|
Execution Plans
,
T-SQL
,
Statistics
,
STRING_SPLIT
0
Performance Surprises and Assumptions : DATEADD()
Aaron Bertrand explores yet another scenario where a date/time...
April 11, 2016
|
SQLPerformance.com
|
Execution Plans
,
T-SQL
,
Query Plan Analysis
0
More ways to discover changes in new versions of SQL Server
Following up on an earlier post about metadata, Aaron Bertrand reveals a few more of his sources for discovering changes in SQL Server.
March 30, 2016
|
Aaron Bertrand
|
Execution Plans
,
SQL Server 2016
,
Extended Events
0
Bad cardinality estimates from SSMS plans - redux
Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
March 4, 2016
|
SQLPerformance.com
|
Execution Plans
,
Plan Explorer
,
Query Plan Analysis
0
Can ColumnStore Help Pagination Workloads?
Aaron Bertrand revisits whether or not ColumnStore can help pagination workloads.
January 15, 2016
|
SQLPerformance.com
|
Execution Plans
,
T-SQL
,
ColumnStore
0
Plan Explorer Update Just in "Time" for the New Year
Jason Hall shows off some of the new features in a brand new update for Plan Explorer.
January 5, 2016
|
Jason Hall
|
Execution Plans
,
Plan Explorer
,
Query Plan Analysis
2
Paul White: Another Reason to Use NOEXPAND hints in Enterprise Edition
Paul White goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition.
December 30, 2015
|
SQLPerformance.com
|
Execution Plans
,
Query Plan Analysis
0
Paul White : Optimizing Update Queries
Paul White spends some time optimizing update queries in order to explore some SQL Server internals.
December 16, 2015
|
SQLPerformance.com
|
Execution Plans
0
Aaron Bertrand : More showplan improvements? Yes, please!
Aaron Bertrand highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in...
December 8, 2015
|
SQLPerformance.com
|
Execution Plans
0
Learning all about the SQL Server Plan Cache
The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.
November 16, 2015
|
Kevin Kline
|
Execution Plans
,
Performance
,
Plan Explorer
,
Query Plan Analysis
,
Slide Decks
2
Hash Joins on Nullable Columns
Paul White discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash join...
November 3, 2015
|
SQLPerformance.com
|
Execution Plans
,
Query Plan Analysis
0
Top Categories
SQL Server
(227)
SQL Sentry
(155)
Community
(147)
T-SQL
(131)
SentryOne
(105)
Execution Plans
(67)
SQLFamily
(63)
Monitoring
(62)
Azure
(61)
Plan Explorer
(54)
SQL Server 2016
(51)
Performance Analysis
(50)
Performance
(49)
Cloud
(47)
T-SQL Tuesday
(47)
Career
(41)
Advisory Conditions
(40)
Alerting
(39)
Query Plan Analysis
(34)
System Configuration
(34)
SQLVacation
(31)
Azure SQL Database
(30)
PASS Summit
(30)
SQLSaturday
(28)
PASS
(26)
Best Practices
(24)
Security
(24)
Professional Development
(22)
Virtualization
(22)
#BackToBasics
(21)
Event Calendar
(20)
SentryOne Builds
(18)
Statistics
(18)
SQL Server Builds
(17)
Slide Decks
(17)
Wait Stats
(17)
DevOps
(16)
Documentation
(16)
Events
(16)
Global Partner Network
(16)
Data Lineage
(15)
I/O
(15)
Indexes
(15)
Engineering
(14)
PowerShell
(14)
Custom Conditions
(12)
Database Documentation
(11)
Extended Events
(11)
SSAS
(11)
Support
(11)
Windows
(11)
AWS
(10)
CPU Performance
(10)
Data Mining
(10)
Database Mapper
(10)
Database Performance
(10)
Fragmentation
(10)
Migration
(10)
PowerBI
(10)
Bad Habits
(9)
SQLBits
(9)
Tips and Tricks
(9)
Analysis Services
(8)
Baselines
(8)
Data Compression
(8)
Disk Performance
(8)
Management Studio
(8)
Performance Monitoring
(8)
SQL Server 2014
(8)
SQL Server 2019
(8)
SSIS
(8)
Task Factory
(8)
Tech Outbound
(8)
tempdb
(8)
DataOps
(7)
Disaster Recovery
(7)
Hardware
(7)
Memory Limits
(7)
Reporting
(7)
SQL Server Agent
(7)
SQL Server on Linux
(7)
SQLintersection
(7)
SSMS
(7)
#entrylevel
(6)
Backups
(6)
ColumnStore
(6)
Microsoft
(6)
Optimizer
(6)
SQL Server 2017
(6)
SQL Server Training
(6)
SentryOne Test
(6)
Speaking
(6)
Trace
(6)
AlwaysOn
(5)
Automation
(5)
Availability Groups
(5)
Customer Success
(5)
EHO
(5)
ETL
(5)
In-Memory OLTP
(5)
Licensing
(5)
Machine Learning
(5)
Partner Spotlight
(5)
SQLCruise
(5)
SQLPASS
(5)
Securing Azure SQL Database
(5)
Service Packs
(5)
Ship Shape Challenge
(5)
Standard Edition
(5)
Table Variables
(5)
Testing
(5)
Training
(5)
Agile
(4)
Azure Data Factory
(4)
Compliance
(4)
Connect
(4)
Deadlocks
(4)
GDPR
(4)
Hyper-V
(4)
Installation
(4)
Managed Instances
(4)
News
(4)
Query Store
(4)
Query Tuning
(4)
SQL Sentry Essentials
(4)
SQL Server 2012
(4)
SSRS
(4)
SentryOne Portal
(4)
Storage
(4)
Storage Forecasting
(4)
Transaction Log
(4)
Troubleshooting
(4)
Women in Technology
(4)
Agile at Home
(3)
Amazon RDS
(3)
Azure DevOps
(3)
CTPs
(3)
Cumulative Updates
(3)
DTU Calculator
(3)
Data Governance
(3)
Data Testing and Validation
(3)
Demos
(3)
Evaluating
(3)
Event Chains
(3)
MSP
(3)
Multi-Tenancy with SQL Server
(3)
SQL Monitoring
(3)
STRING_SPLIT
(3)
Server Health
(3)
Upgrade
(3)
User Guide
(3)
VMware
(3)
Visual Studio
(3)
Webinar
(3)
.NET
(2)
11.2
(2)
4K
(2)
Azure Data Studio
(2)
Cardinality
(2)
DOC xPress
(2)
Data Dictionary
(2)
Data Trends
(2)
Delayed Durability
(2)
Developer Edition
(2)
Docker
(2)
Environment Map
(2)
HTAP
(2)
Key Lookups
(2)
Open Source
(2)
Partitioning
(2)
Pragmatic Works Software
(2)
Python
(2)
Reflection
(2)
SQLskills
(2)
Sabin IO
(2)
SentryOne Cloud Sync
(2)
SentryOne Docs
(2)
SentryOne EMEA
(2)
UDFs
(2)
Volunteering
(2)
Wildcard
(2)
Azure Table Storage
(1)
Blocking
(1)
CodeStock
(1)
DB Sentry
(1)
DBA xPress
(1)
DEVELOPMENT
(1)
Dash
(1)
Data Platform
(1)
Data Pros of Tomorrow Scholarship
(1)
Data Stewardship
(1)
Data and Schema Comparison
(1)
MAXDOP
(1)
Personal Development
(1)
Problem Solving
(1)
Process Improvement
(1)
Product Samples
(1)
Republic Bank
(1)
SQL Sentry Premium
(1)
SSDs
(1)
SentryOne Ambassadors
(1)
SentryOne Database
(1)
Tableau
(1)
Tabular
(1)
Triggers
(1)
how to implement multi tenancy
(1)
how to optimize database performance
(1)
perfmon
(1)
sql database optimization techniques
(1)
what is multi tenancy
(1)
See all
❮
1
2
3
4
5
❯
Get the best SQL query analysis and optimization tool –
free!
Index Analysis Sandbox
Statistics Analysis with Histogram
Management Studio Add-in
Plan Diagram
Deadlocks
History and Comments