SQL Performance
AUGUST 1, 2022
Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.
SQL Performance
FEBRUARY 17, 2022
Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. ( But is it the most efficient? FavoriteBands.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Server According to Bob
JANUARY 11, 2020
Microsoft, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.
SQL Performance
JANUARY 23, 2020
Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.
SQL Performance
MARCH 22, 2022
Both target performance and efficiency for workloads frequently submitting simple statements. It's almost always better to explicitly parameterize statements, rather than relying on the server to do it. In any event, it would be an unusual workload that does not contain at least some parameterized statements server-side.
Dean Hume
APRIL 24, 2018
As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).
Dean Hume
APRIL 24, 2018
As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).
Expert insights. Personalized for you.
142 
Let's personalize your content