Yesterday I blogged about my new updated book Interview Questions and Answers: Updated 2021. Let us read the forward of the book today.
SQL Server Interview Questions and Answers: Updated 2021
I have just released an updated version of my most famous SQL Server Interview Questions and Answers: Updated 2021 after 10 years.
SQL SERVER – Find Untrusted Foreign Key
Today we are going to see the script in which we can find all the untrusted foreign keys in your database. My client asked this question.
SQL SERVER – RESOURCE SEMAPHORE and THREADPOOL
RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.
SQL SERVER – Speed Up Index Rebuild with SORT IN TEMPDB
In today’s blog posts that I have written about SORT IN TEMPDB which can be started on this topic. My client asked me how to speed up index rebuilding.
Forwarded Records, Multiple Backup and SSMS – SQL in Sixty Seconds – Feb 2021
I really really enjoy building SQL in Sixty Seconds video. This month’s topic was Forwarded Records, Backup, and SSMS. Released videos for Feb 2021.Â
SQL SERVER – Get Column Names
A very common question, I keep on getting is how to get column names for a particular column. Well, it is pretty straightforward and easy to do.