Question: How to Install SQL Server 2019?
Answer: This is one of the unique blog posts in the history of SQLAuthority, it is merged blog post.
SQL SERVER 2019 – Disabling Scalar UDF Inlining
Working on the Comprehensive Database Performance Health Check, we will learn how I helped a client by Disabling Scalar UDF Inlining in SQL Server 2019.Â
Install MongoDB on Windows – SQL in Sixty Seconds #091
Today I am going to demonstrate in this SQL in Sixty Seconds Video how to install MongoDB on Windows. Let us see how we can do that in video.
SQL in Sixty Seconds – Need Your Feedback
I decided to spend more time in building the videos and have created three videos in the last three weeks. It is time when I need your feedback.Â
Creating Covering Index to Eliminate Join – SQL in Sixty Seconds #090
How to improve performance so today we are going to see a video about creating converting index to eliminate join and improve query performance.
SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup
I have received lots of questions based on this question about how to remove bookmark lookup. I have taken the 7 most asked questions and decided to answer.
SQL SERVER – Finding Day Name from Date
In today’s blog post we will a very simple script where we will find day name from any valid date. There are multiple ways you can do it.