When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio.
2020-09-22
On September 24th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!
2019-01-15
4,118 reads
In this tip Aaron Bertrand looks at how to generate scripts for triggers using simple T-SQL statements. This tip shows how to easily build scripts for disabling, enabling, dropping and creating.
2018-06-07
3,640 reads
Matteo Lorini shows how to setup a project in SSMS to organize files.
2017-09-27
4,539 reads
By Ed Elliott
This is a bit of a longer one, a look at how to do...
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
By James-Serra
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk...
We have sharepoint as the data source and we have 2 dates created...
Comments posted to this topic are about the item Live versus Stored Data
Comments posted to this topic are about the item Setting the Date
Ask SSC