SQLDIY: Index Fragmentation Levels
Indexes, indexes, indexes my kingdom for an index! Well, something like that. Indexes are the single most important structure in...
2011-07-07
1,269 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 2
Adding In Others For Contrast
In our first part we introduced Pliant and the LS 300 drive. In part 2 we...
2011-07-06
2,953 reads
SQLDIY: Statistics Information Including Last Update
One of the most important aspects of keeping your system running well is updating and managing your statistics. Since the...
2011-07-05
1,005 reads
SQLDIY: Gathering A Data Dictionary
In this installment we are looking at assembling a basic data dictionary from the column level meta data stored in...
2011-07-01
992 reads
The Austin Fall Classic, SQLSaturday is Coming To Austin, TX
Come Get Your Learn On!
You heard right, on October 1st 2011 you need to be in Austin, TX. We have...
2011-06-30
1,458 reads
The Austin Fall Classic, SQLSaturday is Comming To Austin, TX
Come Get Your Learn On!
You heard right, on October 1st 2011 you need to be in Austin, TX. We have...
2011-06-30
1,544 reads
SQLDIY: Tracking Space Usage At the Index Level
I am a fan of information, the more the merrier. Anytime I’m tasked with tracking a production server over the...
2011-06-29
1,428 reads
Understanding Benchmarks
That Means What?
Vizzini: HE DIDN’T FALL? INCONCEIVABLE.
Inigo Montoya: You keep using that word. I do not think it means...
2011-06-29
2,101 reads
SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure...
2011-06-28
563 reads
SQLDIY: Tracking Wait Stats
One of the most important methodologies to date for troubleshooting problems with the SQL Server engine is examining the wait...
2011-06-27
1,055 reads
Blogs
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...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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