Rebuilding Stats: Twice or Not at All Posted on SSC
Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the...
2008-07-29
1,471 reads
Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the...
2008-07-29
1,471 reads
Not all of us work at companies big enough to justify the expense/time it takes to implement something like MS...
2008-07-29
1,439 reads
I saw this post from Rick Strahl about IP6 Addresses in Vista breaking some code, and it immediately made sense...
2008-07-28
1,442 reads
It's downright common these days to download programs as ISO images, but XP doesn't have a native viewer for them....
2008-07-27
1,695 reads
Earlier I wrote Blogging Thoughts - Part 1 where I discussed the various approaches I've seen in blogs (blogging when you...
2008-07-24
1,345 reads
For longer than I care to count I've used the Alt-Tab Powertoy from MS to get a nicer view of...
2008-07-23
1,292 reads
One of the things I've been looking at is different blogging styles and trying to figure out which to recommend...
2008-07-22
1,328 reads
Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index.
2008-07-22
11,124 reads
It's been a while since I had anything up on SSC, a combination of Steve being in good shape on...
2008-07-22
488 reads
I think we all struggle to keep up with various credentials needed to live our internet lives (single sign on...
2008-07-21
543 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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