SentryOne Blog

Lori Edwards of SQL Sentry talks about some things she wishes she had known earlier on in her career as a SQL Server DBA.
September 2, 2014 | Lori Edwards | SQLFamily, Career 0
Following up on Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates, Aaron Bertrand provides four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.
August 29, 2014 | Aaron Bertrand | T-SQL 0
Erin Stellato of SQLskills shows how sort operations can have a dramatic impact on plans, and what you can do about it.
Aaron Bertrand & Grant Fritchey share an ice cold video for the #iceBucketChallenge, trying to help raise awareness for #ALS, and challenge some colleagues to follow our lead.
August 21, 2014 | Aaron Bertrand | SQLFamily, SQL Sentry 0
Aaron Bertrand takes a closer look at some additional requirements for typically grouped concatenation queries in SQL Server.
August 20, 2014 | SQLPerformance.com | T-SQL 0
Glenn Berry of SQLskills demonstrates that the latest Azure VMs are a huge performance improvement over previously available hardware.
Aaron Bertrand uses a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.
August 12, 2014 | Aaron Bertrand | SQLFamily, T-SQL, Transact-SQL 1
Glenn Berry (@GlennAlanBerry) of SQLskills continues his series on hardware selection, ou
Justin Randall continues his insightful blog series, showing users things they may not know about the grids.
August 7, 2014 | Justin Randall | Performance Analysis 0
Aaron Bertrand shows the safest and most efficient ways to perform grouped concatenation in SQL Server.
August 6, 2014 | SQLPerformance.com | T-SQL 0
Aaron Bertrand reveals that the Books Online content for SQL Server 2014 is finally fully available, and shows two ways to perform installation.
Paul White details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should...
July 30, 2014 | SQLPerformance.com | 0
Erin Stellato of SQLskills compares the impact of adding additional index columns, by choosing
Paul White uses several examples to describe subquery cardinality estimate bug.
Lori Edwards explains an add-in for SQL Sentry Performance Advisor, Fragmentation Manager, aimed at helping you manage and automate index maintenance.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More