Prove a tuning change with before and after numbers from Query Store for CPU, reads, duration, and comparable execution volume.
How to Do Case Insensitive Search? – Interview Question of the Week #267
Question: How to Do Case Insensitive Search?
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.
SQL SERVER Management Studio – Rebuild All Indexes on Table
SSMS can open a Rebuild All dialog for table indexes. An e-commerce customer discovered this shortcut during my health check.
SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights
In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.
How to Join Two Tables Without Using Join Keywords? – Interview Question of the Week #266
Question: How to Join Two Tables Without Using Join Keywords?
Answer: In my life, I have attended many interviews as an interviewer.
SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It
In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.
Listing Objects Changed Since the Last Release With modify_date
modify_date shows what changed after a release, but never what was dropped. Here is a small baseline trick that fills the gap.