Reducing CXPACKET wait stats on a high transactional database: what CXPACKET means, and when lowering the degree of parallelism really helps.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Get All the Information of Database using sys.databases
A handy script from Matteo that uses sys.databases to show plenty of database information, like status, data and log file counts and their sizes in MB.
CURRENT_DATE, || and Other Small T-SQL Changes in SQL Server 2025
Use CURRENT_DATE, string concatenation, optional SUBSTRING length and bigint DATEADD in SQL Server 2025 with clear examples and checks.
SQL SERVER – Get Database Backup History for a Single Database
A reader script by aasim abdullah to get database backup history for a single database: backup file, size, time taken, LSNs and the type of each backup.
SQL SERVER – Recycle Error Log – Create New Log file without Server Restart
A client’s DBA restarted the server just to start a fresh Error Log. There is no need: you can recycle the log and create a new file without a restart.
A Bill of Materials With a Recursive CTE
Expand a bill of materials with a recursive CTE, multiply quantities across levels, trace component paths, and guard against cycles.
SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore
My session on SharePoint and SQL Server Performance at the South East Asia SharePoint Conference in Singapore was a blast. Here is my report of the event.
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.