A DBA spotted an extra pane in my Activity Monitor during a health check. Here is where Active Expensive Queries shows up and which SSMS version has it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Performance Observation of TRIM Function
Does the new TRIM function slow your queries like other functions in a WHERE clause do? Here is my performance observation of TRIM function in SQL Server 2017.
SQL SERVER – Rule Cluster Remote Access Failed During Installation on SQL Failover Clustered Instance
Installing a SQL Server failover clustered instance failed the Cluster Remote Access rule. Here is what Detail.txt showed and the workaround I used.
SQL SERVER – FIX: Number Data Type from Oracle Linked Sever Shown in Scientific Notation
A client saw numbers from an Oracle linked server shown in scientific notation in SQL Server. Here is the query that shows the issue and how to fix it.
How to Get Top N Records Per Group? – Ranking Function – Interview Question of the Week #156
I gave 40 candidates this puzzle: get the top N records per group from a student marks table. Here is the simple answer using a Ranking Function.
SQL SERVER – What Does SET NOEXEC Do?
What does SET NOEXEC do? With SET NOEXEC ON, SQL Server compiles your query but does not run it. Here is how the compile and execute phases work.
Change Column From NULL to NOT NULL in SQL Server
To change a column from NULL to NOT NULL, first fill every NULL value, then run ALTER COLUMN with the full data type and NOT NULL. This post shows the Msg 515 error you get otherwise, how to choose the replacement value, and the trap that makes a column nullable again. It ends with a default constraint that keeps new rows valid.
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.