Daily Coping 16 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
On table variable row estimations from Blog Posts – SQLServerCentral
At first glance, the question of how many rows are estimated from a table variable is easy.
But, is it really that simple? Well, not...
Daily Coping 15 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
SQL Puzzle – Eight Queens on a Chess board from Blog Posts – SQLServerCentral
Here's a SQL Puzzle for the festive period. 2020 has been a year of many things but amongst it all, it has been the...
Setting Defaults for New SQL Compare Projects from Blog Posts – SQLServerCentral
Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went...
Getting Started Reading Execution Plans: Highest Cost Operator from Blog Posts – SQLServerCentral
Reading execution plans in SQL Server is just hard. There’s a lot to learn and understand. I previously outlined the basics I use to...
Daily Coping 14 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
ETL Antipattern: Performing Full Loads Instead of Incremental Loads from Blog Posts – SQLServerCentral
In my last post in the ETL Antipatterns series, I wrote about the common antipattern of ingesting or loading more data than necessary. This...
Introduction to SQL Server Query Store from Blog Posts – SQLServerCentral
A quick exploration of Query Store, the most anticipated feature of SQL 2016.
The post Introduction to SQL Server Query Store appeared first on SQLServerCentral.
Must Read in Cloud & Networking
Top life hacks for prepping for your IT certification exam
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed up for a class that lasted one week, per...
Must Read in Data
Learn Transformers for Natural Language Processing with Denis Rothman
Key takeaways
The transformer architecture has proved to be revolutionary in outperforming the classical RNN and CNN models in use today.
Artificial intelligence is...
