SentryOne Blog

Paul White demonstrates performance tuning a SQL Server execution plan as a whole, instead of honing in too narrowly on individual...
October 2, 2014 | | Execution Plans, T-SQL 0
Aaron Bertrand treats a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.
Aaron Bertrand (@AaronBertrand) discusses the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.
September 24, 2014 | Aaron Bertrand | Bad Habits, T-SQL 26
Aaron Bertrand discusses examples where people expect SQL Server to perform tasks that really should be performed outside the...
Jason Hall shows us how table variables have changed in SQL Server 2014 and reminds us how helpful it can be to follow up on hard questions.
September 18, 2014 | Jason Hall | T-SQL, SQL Server, Indexes, Table Variables 4
Glenn Berry of SQLskills walks us through using Geekbench 3.2 from Primate Labs to test and compare CPU and memory performance on Windows database servers.
September 17, 2014 | | CPU Performance, Hardware 0
Aaron Bertrand continues his Bad Habits series; in this installment, he discusses ten common cases of misplaced optimization.
September 16, 2014 | Aaron Bertrand | Bad Habits, T-SQL 1
Paul White talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of...
Contributing to T-SQL Tuesday #58, Aaron Bertrand discusses a few of the reasons people give out the sa password, and what you should do in those cases instead.
September 9, 2014 | Aaron Bertrand | Security, SQL Server, T-SQL Tuesday 0
Glenn Berry of SQLskills continues on database server hardware trends; today he previews some new processors that may save you some money on SQL Server 2014.
September 9, 2014 | | Performance, Hardware 0
Aaron Bertrand continues his Bad Habits series, explaining why you should avoid helper functions and use joins against the catalog views instead.
September 4, 2014 | Aaron Bertrand | Bad Habits, T-SQL 0
Paul White looks at a couple of cases where - even though T-SQL is supposed to be a declarative language and any query that uses the...
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.

Top Categories

See all

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
Free Download Learn More