Read dm_exec_function_stats to rank scalar UDF activity, inspect callers, verify collection settings, and recognize inlined work.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Ask the Experts: Database Performance Roundtable by Quest
Today I am going to talk about my motivation behind Ask the Experts: Database Performance Roundtable. Questions are Conversation Extenders.
Memory Used by Each Table in the SQL Server Buffer Pool
Memory used by each table is the number of its pages in the buffer pool times 8 KB. This post adds them up with sys.dm_os_buffer_descriptors, shows why a plain division by 128 hides small tables, and compares the cached pages with the pages each table owns on disk.
Buffer Pool Pages for One Table in SQL Server
Buffer pool pages for one table show how much of one table sits in memory right now. This post lists them by index, page type and page level with sys.dm_os_buffer_descriptors, then shows which pages a seek, a scan and a large text read pull in. It uses the join that the documentation gives for each allocation unit type.
Schema Changes History Has No Data: Check Default Trace Enabled
The Schema Changes History report can say it has no data to show. A client saw this message in SSMS. Check that default trace enabled is 1, make a schema change, and run the report again.
SQL SERVER – Validating Positive Integer Strings with Explicit Boundaries
To Validate Natural integer strings, I define a nonempty positive ASCII-digit contract. A customer wanted a simpler validator.
How to Alter Index to Add New Columns in SQL Server? – Interview Question of the Week #278
Question: How to Alter Index to Add New Columns in SQL Server?
Answer: It is not possible to Alter Index definition to add or remove columns.
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.