Which database is consuming my memory? This query on sys.dm_os_buffer_descriptors counts buffer pool pages per database and page type.
SQL SERVER – Unable to Start SQL – Error: SQL Server Could Not Spawn Lazy Writer Thread
Playing with affinity settings, I broke SQL Server startup with error 17120: could not spawn lazy writer thread. Here is what the ERRORLOG showed and how I recovered.
SQL SERVER – Increase Characters Displayed in Text Results
A reader’s JSON output looked cut off compared to my blog post. Here is how to increase characters displayed in text results using Query Options in SSMS.
SQL SERVER – How to Remove All Characters From a String Using T-SQL?
A reader wanted only the digits from a string like ab123ce234fe. Here is a simple T-SQL loop to remove all characters from a string and keep the numbers.
SQL SERVER – DevOps for the DBA – Notes from the Field #091
DevOps is a buzz word with real substance behind it. In Notes from the Field #091, Stuart Ainsworth explains what DevOps means for a DBA’s daily job.
SQL SERVER – Error: Msg 245 – Conversion failed when converting the varchar value ‘Inactive’ to data type int
Mixing text and numbers in a CASE statement can throw Msg 245: conversion failed when converting the varchar value to data type int. Here is why and the fix.
Recovering Unsaved Query Windows After SSMS Closes Unexpectedly
A restart ate your script, but maybe not all of it. Two places to look: SSMS recovery files and the text SQL Server remembers.