SQL Server 2014 and the New Cardinality Estimator
Cardinality, basically the number of rows being processed by an operation with the optimizer, is a calculation predicated on the...
2014-02-12
1,165 reads
Cardinality, basically the number of rows being processed by an operation with the optimizer, is a calculation predicated on the...
2014-02-12
1,165 reads
Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...
2014-02-11 (first published: 2014-02-05)
1,924 reads
I didn’t get out to many events in January, so I was somewhat limited in the pool of presenters that...
2014-02-07
706 reads
I am humbled and honored (and more than a little horrified) to be on this list of the Best of...
2014-02-06
701 reads
This is an actual quote from what we can only assume is a functional human being:
The database is very big...
2014-01-20
697 reads
Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me,...
2014-01-15
1,189 reads
For those who don’t know, I work for Red Gate Software. I’m not a developer, but I work directly for...
2014-01-15 (first published: 2014-01-08)
2,036 reads
A whole new year. Cool.
I was at SQL Saturday DC, #233, at the beginning of December. I sat through several...
2014-01-03
742 reads
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
2013-12-31 (first published: 2010-12-02)
13,549 reads
The #tribalawards voting is now online. Get over there and get it done.
I honestly don’t care who you vote for...
2013-12-23 (first published: 2013-12-20)
919 reads
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
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