2005 Efficiency Performance Servers 
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.
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).
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
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).
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.
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
"Waitstats helps us identify performance-related counters. But waits information by itself isn't enough to accurately diagnose performance problems. The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.".
Expert insights. Personalized for you.
142 
Let's personalize your content