Tired of IF OBJECT_ID checks before every DROP? SQL Server 2016 adds a T-SQL enhancement I wanted for years, the DROP IF EXISTS clause. Here is how it works.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Practical Tips to Reduce SQL Server Database Table Size – Experts Opinion
Practical tips to reduce SQL Server database table size, from my friend and SQL Server expert Sergey, for faster queries and smaller storage.
Interview Question of the Week #047 – Logic To Find Weekdays Between Two Dates
How do you find weekdays between two dates in SQL Server? Here is a simple user defined function that loops through the dates and skips Saturday and Sunday.
SQL SERVER 2016 – Comparing Execution Plans
A query runs fine in test but slow in production? SQL Server 2016 tools add a way of comparing execution plans so you can find what changed.
SQL SERVER – Installing and Getting Started With Semantic Search
To use semantic search you need Full-Text and Semantic Extractions for Search installed. Here is how to check the install and get started with semantic search.
SQL SERVER – Availability Group and the Six Critical Steps for DBAs to Follow – Notes from the Field #104
Mike Lawell shares six critical steps every DBA should follow when asked to implement an AlwaysOn Availability Group. Notes from the Field #104.
SQL SERVER – What Resource Wait Are We Seeing?
A reader saw many PAGELATCH waits on 2:1:3 and 2:1:1 in Activity Monitor. I explain how to tell which resource wait you are seeing and what these pages are.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.