Query Memory Spills
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,130 reads
Klaus Aschenbrenner
Slides & Samples for my Advanced SQL Server Troubleshooting session at SQLPASS
As I have announced in my "Advanced SQL Server Troubleshooting" session at SQLPASS
today, you can find here the
slides & samples for...
2011-10-14
772 reads
SQL Server Indexing Day, 18. Jänner 2012 in Wien
Sie wollen SQL Server
Abfragen um 100% oder gar 1000% beschleunigt haben? Gleichzeitig wollen Sie Hardware–
und Lizenzkosten Ihrer SQL Server Anwendungen...
2011-10-04
1,082 reads
Slides & Samples from my SQLbits sessions
As
I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK,
you can find here the
Slides & Samples for...
2011-10-02
912 reads
Slides & Samples for my SolidQ Summit Sessions
As I have announced in all of my sessions last week in Budapest at the SolidQ summit,
you can find here...
2011-09-29
1,472 reads
Slides & Samples for my SQLdays Sessions
As I have announced in all of my sessions this week in Rosenheim/Germany at the SQLdays
conference can find here the
Slides...
2011-09-29
1,413 reads
SQLMCM Training – Day 18
Today we covered the topics Full Text Search, Change Data Capture, Change Tracking,
and Service Broker. I have taken no notes...
2011-08-26
969 reads
SQLMCM Training – Day 17
Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know
these concepts very well, my study notes...
2011-08-25
666 reads
SQLMCM Training – Day 16
Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...
2011-08-24
635 reads
SQLMCM Training – Day 15
The whole last 3 days I've spent almost every minute with reviewing the material from
the last 2 weeks (around 38...
2011-08-23
621 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