Msg 5834 says the affinity mask conflicts with the IO affinity mask when you change fill factor with sp_configure. The fix is RECONFIGURE WITH OVERRIDE.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor
A quick script to rebuild every index of all tables in a database with a fillfactor of 80, plus a short note on what fillfactor does to leaf-level pages.
Estimating Table Growth for Next Year From Backup History
Estimate table growth with monthly full backup history, a twelve month forecast, and table space checks that separate evidence from guesses.
SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader
A reader asked how to get a single random number for a set of rows, like one per PostalCode. I compare NEWID() for each row with RAND() for a whole set.
Tracking Which Updates Every Server Has
Tracking Which Updates each SQL Server runs takes a dated inventory table, SERVERPROPERTY snapshots, and a report of instances behind the target.
Connecting to SQL Server From Java, Python and .NET
Choose a SQL Server driver for Java, Python, or .NET, then verify encryption, authentication, pooling, and the application's connection.
Operator Cost Percentages Are Estimates: Read Actual Time Instead
Read operator cost percentages as estimates, then use actual rows, elapsed time, IO, and repeated work to find the real bottleneck.
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.