To update statistics with FULLSCAN in parallel, add MAXDOP to the statement. This post builds a table of 3 million rows, times the update with MAXDOP 1, the instance default and 8, and shows which statistics speed up and which do not.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Tracking Backup Throughput and Duration From msdb History
Track backup throughput and duration from msdb history, compare recent trends, and keep striped devices from duplicating backup totals.
Error 18210: New Parallel Operation Cannot Be Started During Backups
Error 18210 showed up in a client’s ERRORLOG beside a message that a new parallel operation could not be started. The client’s third-party tool backed up more than 1,000 databases at the same time. Staggering the backups stopped the error.
Scheduling Recurring Events: Every Second Tuesday in T-SQL
Generate recurring events with stable weekday arithmetic, monthly ranking, and anchored fourteen-day rules instead of endless date rows.
SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
An upgrade could not start SQL Server: Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission. Here is another way to fix it.
What is Consolidation of Index? – Interview Question of the Week #212
What is consolidation of index? When a table has overlapping indexes, like one on Col1 and one on Col1, Col2, here is how I think about combining them.
SQL SERVER – Enabling Older Legacy Cardinality Estimation
Legacy Cardinality Estimation temporarily stabilized one customer memory-grant problem. A query waited on RESOURCE_SEMAPHORE while the instance became unresponsive.
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.