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.
SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG
A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – How Many Line of Code Do You Have in Database?
After the first SQLSaturday in Sri Lanka, here is a question worth a script: how many lines of code do you have in your database? Here is a way to count them.