binary Conversion pads and truncates on different sides depending on the source type. I compare one integer with one string at two target widths. The resulting byte sequences show why width alone is not the complete rule.
SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution
What to do when the query processor could not start the thread resources for parallel query execution, and why this error often clears itself.
Documenting a Database With Extended Properties
Keep extended properties beside your SQL Server schema, maintain table and column descriptions, and query a useful data dictionary.
SSIS or T-SQL for a Simple Load
SSIS or T-SQL for a simple load depends on sources, transformations, logging, and operations; learn when a stored procedure is enough.
REPLICATE: Zero Copies and Negative Counts Differ
REPLICATE treats zero copies differently from a negative count. I keep the source and requested count beside the result. Byte lengths and NULL flags reveal several blank-looking outcomes.
Standard Settings for a New SQL Server Install
Review standard settings for a new SQL Server install, including memory, MAXDOP, tempdb, backups, and alerts before users depend on it.
SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
A simple Table Partitioning tutorial for SQL Server 2005 that shows, step by step, how to horizontally partition a database table across two filegroups.