Implement paging with deterministic OFFSET FETCH, correct ROW_NUMBER boundaries, and keyset navigation for deeper SQL Server pages.
SQL SERVER – Using PowerShell and Native Client to run queries in SQL Server
A friend wanted PowerShell and Native Client, not SQL PowerShell, to run queries against SQL Server. Here is the small sample script I wrote for it.
SQL SERVER – Database Snapshots and Replica Causing Write Delays
Do database snapshots slow down writes? With copy on write, each snapshot adds work to every page change. Here is how they can cause write delays.
SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085
Clients sometimes send files made with Results To File in SSMS. Kevin shows how to convert standard SSMS file results to delimited data you can load.
Autogrowth Settings: Why 1 MB and 10 Percent Still Hurt
Inspect autogrowth settings across database files, review retained growth events and VLFs, and choose tested fixed-size increments.
SQL SERVER – SPARSE Property Doesn’t Carry Forward Using SELECT INTO
SELECT INTO copies most column attributes to a new table, but not all. Here is proof that the SPARSE property does not carry forward using SELECT INTO.
SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1
The SQL Server service would not start for a DBA fresh out of college. The cause was Error 5118, and here is how to read it and fix it.