Sidd's SQL Solution

Greeting everyone. I'm happy and excited to share that I've launched my YouTube channel with name SiddTechnolog on October, 8th. I've started off from the very beginning of SQL Server i.e. installation. In this video I've showcased how to install SQL Server 2017 developer edition on Windows 10 based desktop machine. Not only I have shown options related to a desktop based installation but I've also tried to cover options you should be careful about when you do installation on a Windows Server based machine. Moreover I've also provided explanation on what and why we're choosing a given options. So what are you waiting for, go over the video and exalt your SQL Server installation skills. Please do not forget to hit the like button if you like the video and click on subscribe to stay updated on latest uploaded videos. Please feel free to suggest topics you would like to cover me in videos or as blog. See you soon.

Anybody who has worked with SQL Server databases whether be it administrator or developer, knows the significance of having “ statistics ” on a table and how it greatly impacts SQL query performance. Below are some excerpts about “ statistics ” from SQL Server documentation . “ Statistics for query optimization are binary large objects (BLOBs) that contain statistical information about the distribution of values in one or more columns of a table or indexed view. The Query Optimizer uses these statistics to estimate the  cardinality , or number of rows, in the query result. These  cardinality estimates  enable the Query Optimizer to create a high-quality query plan. ” “ Statistics ” is a complex amalgamation of histograms and densities that helps SQL Server Query optimizer correctly estimate number of rows it may fetch and process for each operator in order to generate an optimal or near optimal execution plan . Estimation plays huge role in how much time each operator wil