A very simple script that lists all the User Defined Functions in a database, with schema name and type, by reading sys.objects in SQL Server.
Salary Ranges: Match Overlapping Intervals in SQL Server
Match salary ranges using both boundaries of the job and candidate intervals. Define open bounds and test containment, endpoint contact and invalid input.
binary Conversion: Strings and Numbers Pad on Different Sides
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.