A SQL Server Hardware Nugget A Day – Day 23
For Day 23 of this series, I want to talk a little about some things to consider as you make...
2011-04-24
887 reads
Glenn Berry
A SQL Server Hardware Nugget A Day – Day 22
For Day 22 of this series, I want to talk a little about 32-bit vs. 64-bit hardware, and the related...
2011-04-23
744 reads
A SQL Server Hardware Nugget A Day – Day 21
For Day 21 of this series, I will talk about processor cache size and its relationship to SQL Server performance.
Cache...
2011-04-21
910 reads
A SQL Server Hardware Nugget A Day – Day 20
For Day 20 of this series, we are going to talk about some factors to consider if you are thinking...
2011-04-20
775 reads
A SQL Server Hardware Nugget A Day – Day 19
For Day 19 of this series, I am going to briefly discuss hardware RAID controllers, also known as disk array...
2011-04-19
545 reads
SQL Server 2008 R2 RTM Cumulative Update 7
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 7, which is Build 10.50.1777. 0. I count 33 fixes...
2011-04-18
806 reads
A SQL Server Hardware Nugget A Day – Day 18
For Day 18 of the series, we will talk about AMD Turbo CORE technology. AMD Turbo CORE is a technology...
2011-04-18
530 reads
A SQL Server Hardware Nugget A Day – Day 17
For Day 17 of this series, I am going to talk about Geekbench. Geekbench is a cross-platform, synthetic benchmark tool...
2011-04-18
599 reads
A SQL Server Hardware Nugget A Day – Day 16
For Day 16 of this series, I want to talk a little bit about the new hardware license limits that...
2011-04-17
756 reads
A SQL Server Hardware Nugget A Day – Day 15
For Day 15 of this series, I am going to talk about Power Management and its effect on processor performance....
2011-04-15
468 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers