Set up go-sqlcmd on Windows, verify the executable, run scripts and variables, control output, and review optional container commands.
SCHEMABINDING View: What You Can Change in the Table
A SCHEMABINDING view locks the columns it uses and leaves the other columns of the table free. This post tests which changes SQL Server blocks, shows the messages and lists the bound columns with a query. It also shows how to change a bound column inside one transaction.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.
SQL SERVER – Identifying and Fixing PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type
I walked into a client engagement where I really got stuck with a very interesting scenario with a client with PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type.
Memory-Optimized Files: List Logical and Physical Names
To list memory-optimized files, join sys.dm_db_xtp_checkpoint_files to sys.database_files. This post builds a small memory-optimized database, shows the container’s logical and physical name and counts its checkpoint files by type and state. It also explains why a container holds far more disk space than its data uses.
AVG of an Integer Column Returns an Integer: Getting Decimals Back
The dashboard says the average is 1 when everyone can see it is 1.5. Here is why AVG does that and the one-line fix.
Drop Multiple Columns in One ALTER TABLE Statement
To drop multiple columns, list them after one DROP COLUMN in one ALTER TABLE statement. This post tests the syntax on a table with a default, a check constraint and an index, shows the error that a dependent object causes and drops the constraints and columns together. It also explains why the disk space doesn’t return until a rebuild.