2023-11-24
149 reads
2023-11-24
149 reads
I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this...
2023-11-24 (first published: 2023-11-06)
255 reads
I’ve been to a lot of conferences, and one that I’ve probably attended the most is the annual PASS Data Community Summit. It’s been listed under various names, but...
2023-11-24
76 reads
2023-11-24
427 reads
2023-11-22
439 reads
Today Steve talks about data modeling and how standards can transfer knowledge between developers.
2023-11-22
447 reads
Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here. I didn’t get much of a chance to check out the posts as I was...
2023-11-21
21 reads
2023-11-20
342 reads
Recently a customer was looking to automate some of their SQL Compare checks, but they wanted to do this in a dynamic way, since they needed to do this...
2023-11-20 (first published: 2023-11-08)
395 reads
2023-11-20
234 reads
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Comments posted to this topic are about the item Pushing the Limits of AGs
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers