Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...
2018-07-25 (first published: 2018-07-16)
2,062 reads
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
815 reads
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...
2018-07-16 (first published: 2018-07-09)
3,796 reads
Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...
2018-07-12 (first published: 2018-07-05)
4,762 reads
Grant talks about the lessons of history when the goals of different groups don't align.
2018-07-09
76 reads
I have quite a few speaking engagements coming up. Rather than an intermittent blog post, I’ve decided to have a...
2018-07-04 (first published: 2018-06-25)
1,646 reads
I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag...
2018-06-19 (first published: 2018-06-11)
1,778 reads
While SQL Server Management Studio (SSMS) provides a robust graphical user interface (GUI), the commands you’re going to use the...
2018-06-18
953 reads
Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced:...
2018-06-11 (first published: 2018-05-29)
2,157 reads
Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to...
2018-06-07
270 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...
i have sqlexpress on rds, is there any way i can get notifacation that...
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...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers