During the last twenty-some years I have looked at a huge number of SQL Server instances. Most of them were brought to my attention because they were not performing as expected and I was tasked with …
Deprecated Features after SQL 2016
Microsoft is always upgrading SQL Server. This is necessary in order to keep up with new technologies but it often requires changes and removal of existing features that many users and legacy …
A Story About Foreign Keys
This month I am going to illustrate the importance of indexing Foreign Keys (FKs) and I am going to brag about how I saved a foundering company in one simple step. I will start with the bragging …
Using Tables as Buckets
Every once in a while I run into this SQL problem. I find that a database is designed with empty tables that are then loaded with data. That data is then processed in certain ways according to the …
Enterprise Features Coming to Standard Edition SQL Server
Today I took a look at the video of the Keynote session at Microsoft Connect 2016 conference. If you are a SQL Server developer I strongly recommend taking a look at the video. It is an hour …
Continue Reading about Enterprise Features Coming to Standard Edition SQL Server →
Big Performance Problems with the Cardinality Estimator
What is a Cardinality Estimator anyway? The Cardinality Estimator (CE) predicts how many rows your query will likely return. The cardinality prediction is used by the query optimizer to generate an …
Continue Reading about Big Performance Problems with the Cardinality Estimator →