You can kill a running shrink with KILL and the database stays safe. This post starts a shrink on a test database, stops it from a second window, checks the data and the file afterwards, and shows that the shrink itself, not the kill, is what fragments the table.
SQL SERVER – Rows Sampled – sys.dm_db_stats_properties
Here is the question asked in my yesterday’s Comprehensive Database Performance Health Check about rows sampled from sys.dm_db_stats_properties.
Ask the Experts: Database Performance Roundtable by Quest
Today I am going to talk about my motivation behind Ask the Experts: Database Performance Roundtable. Questions are Conversation Extenders.
SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information
If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.
SQL SERVER – Validating Positive Integer Strings with Explicit Boundaries
To Validate Natural integer strings, I define a nonempty positive ASCII-digit contract. A customer wanted a simpler validator.
SQL to MongoDB: Mapping SELECT, WHERE, GROUP BY and JOIN
Moving from SQL to MongoDB is mostly a change of vocabulary plus a new way to join. This post maps SELECT, WHERE, ORDER BY, GROUP BY and JOIN to find, sort, $group and $lookup, and tests each one on a small vegetarian shop.
MongoDB deleteMany: The Empty Filter That Deletes Everything
MongoDB deleteMany removes every document that matches a filter, and an empty filter matches all of them. This post tests deleteOne, deleteMany, findOneAndDelete and the two quiet traps: a misspelled field and a filter built from an unset variable.