Which MDF or NDF file is the busiest? This query uses fn_virtualfilestats to show reads, writes, IO stalls and size for every database file.
Striped Backups: Writing One Backup to Several Files
Use striped backups across several files, inspect media families, restore every stripe, and test resource settings on your own server.
SQL SERVER – Copy Statistics from One Server to Another Server
Without the client’s data, every query ran in zero milliseconds. Here is how I copy statistics from one server to another to tune with only the schema.
SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file
Too many virtual log files are bad for your LDF. Here is a simple script to reduce the virtual log files right away with a log backup and a shrink.
Fiscal Years That Do Not Start in January
Compute fiscal years and quarters from an April start, build indexed date boundaries, and store a fiscal calendar for repeatable reports.
SQL SERVER – Detect Virtual Log Files (VLF) in LDF
A large LDF file is made of many small Virtual Log Files (VLFs). Here is how to detect them with DBCC LOGINFO and see which ones are active.
.jpg)
SQLAuthority News – My Evaluation of Singapore SharePoint Conference
My feedback from the Singapore SharePoint Conference, where I was the only SQL speaker: very high ratings, and my demo was called one of the best of the event.