My instance took unusually long to come up, and the ERRORLOG showed ‘Starting up database’ many times for the same database. Here is why that happens.
SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way
Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.
SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group
A reader’s database in an AlwaysOn availability group grew a Huge Transaction Log of 230 GB with error 9002, AVAILABILITY_REPLICA. Here is what to check.
SQL SERVER – JSON Support for Transmitting Data for SQL Server 2016 – Notes from the Field #114
In Notes from the Field #114, Kathi Kellenberger explores the new SQL SERVER – JSON support in the 2016 release and how it helps you transmit data from queries.
SQL SERVER 2016: Creating Simple Temporal Table
Want to see what your data looked like on a past date? Here is how to create a simple Temporal Table in SQL Server 2016, with its history table made for you.
Interview Question of the Week #057 – What is GO Statement in SQL SERVER?
Learn what the GO statement really does in SQL Server, why a variable vanishes after it, and the simple rules every script writer should know.
SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts
A reader asked what Optimistic Multi-Version Concurrency in InMemory OLTP really means. It sounds simple but is a loaded question, so here is a plain answer.