Priority boost sounds like a speed setting, but it can make a server slower. This post explains what the option does, checks it with a query that works when Management Studio doesn’t show it, prints the statements that turn it off with their undo, and explains why a restart is needed.
Check Index Fragmentation With Row Count in SQL Server
To check index fragmentation with row count, read sys.dm_db_index_physical_stats in SAMPLED mode and keep the page count and row count next to each percentage. This post builds a demo with three tables, lists every index, filters out the tiny ones, loops over every online database, and rebuilds the one index that matters.
SQL Puzzle – Schema and Table Creation – Answer Without Running Code
This Table Creation puzzle asks for an explanation before you run its code. I suggest examining the batch separators carefully.
MySQL OUT Parameter: IN, OUT and INOUT in Stored Procedures
A MySQL OUT parameter lets a stored procedure hand a value back to the caller through a variable. This post tests IN, OUT and INOUT on a small table, shows the error you get when you pass a literal, and compares the syntax with SQL Server.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
Box Selection in SSMS: Four Edits With the ALT Key
Box selection in SSMS selects vertical text: hold the ALT key and drag the mouse across the text. This post shows four edits that the box makes quick: typing on many lines at once, deleting a column, pasting a column into a column, and moving lines with the arrow keys. Each result is a query that runs.
Select Vertical Text in SSMS: Alt Shift and Arrow Keys
To select vertical text in SSMS, hold Alt and drag with the mouse, or hold Alt and Shift and press the arrow keys. This post explains what a vertical selection does, how to edit many lines at once and how to turn a pasted column into an IN list. It also shows a T-SQL alternative for long lists.