Custom Statistics Distributions in SQL Server 2022
Statistics are important for the query processing engine in SQL Server to run efficiently. The type of execution plan that is created often depends on the optimizer knowing the distribution of data in a column. This is why so many of us have maintenanc …
Choosing Between SSIS vs ADF: What You Need to Know
The post Choosing Between SSIS vs ADF: What You Need to Know appeared first on SQLServerCentral.
SQL Logic
In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code. Because of how relational databases implement NULLs, it definitely can make some processes more …
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some files to lower the bill. To check my progress I needed to check the size before/after the task in an easy way for multiple Azure SQL DBs. Check Azure SQL DB storage …
[Video] Office Hours: 25 Answers in 10 Minutes
It’s time for a speed round, a rapid-fire tour of your top-voted questions from https://pollgab.com/room/brento: Here’s what we discussed: 00:00 Start 00:17 SteveTV: Hi Brent! Are there solutions for managing SQL Agent jobs that obviate the …