Category: SQL Server

Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.
December 27, 2018 | SQLPerformance.com | T-SQL, SQL Server, UDFs 0
In his inaugural SentryOne Community Omnibus post, Kevin Kline shares the latest SentryOne webinars, resources, blogs, and press releases.
Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.
Kevin Kline shares highlights from the PASS Summit 2018 keynote with Raghu Ramakrishnan.
November 12, 2018 | Kevin Kline | SQL Server, PASS Summit 0
Kevin Kline shares highlights from Rohan Kumar's PASS Summit 2018 keynote, "SQL Server and Azure Data Services: Harness the future with the ultimate hybrid platform for data and AI."
November 8, 2018 | Kevin Kline | Cloud, SQL Server, Azure, PASS Summit 0
Learn about this HUGE opportunity to influence the Microsoft Data Platform products and services you use daily while attending the PASS Summit!
November 5, 2018 | Kevin Kline | Community, SQL Server, PASS Summit, PASS 2
Tim Radney talks about some of the things you can do to prepare for the end of extended support for SQL Server 2008 and SQL Server 2008 R2.
October 12, 2018 | SQLPerformance.com | SQL Server 0
Today Microsoft announced the first public preview of SQL Server 2019. I've got some exclusive details over at MSSQLTips.com.
September 24, 2018 | Aaron Bertrand | SQL Server, SQL Server 2019 0
Join Kevin Kline, author of SQL in a Nutshell, at one of seven PASS SQL Server user group meetings in California in September. See you there!
September 5, 2018 | Kevin Kline | SQLFamily, Community, SQL Server 0
Glenn Berry lays out a convincing argument to upgrade to a modern version of SQL Server -- considering not only the platform improvements but also changes to Windows, storage, and hardware.
Andy Mallon dispels the myth that SQL Server maintains some kind of query result cache to make future executions of the same query faster.
Kevin Kline is hitting the road again with his family for SQL Vacation 2018! Kevin will be visiting 5 SQL Server user groups in 4 states -- find out if he will be in your neck of the woods.
The Tech Outbound SQL Cruise for Alaska 2018 offers some of the most renowned mentors in the SQL Server world. I hope you will join us!
Glenn Berry discusses a number of compelling reasons why, if you are choosing between SQL Server 2016 or SQL Server 2017, you should choose the newer version.
SQL Server 2012 is now at its final build: Service Pack 4. See what you should know before deploying and find out what's been in each release over its lifetime.

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