Need a variable’s datatype, precision, scale, length or collation in code? SQL_VARIANT_PROPERTY shows the properties of variable values, with examples.
Clustered Key Choice for Date Range Queries: Date or Identity
Should you cluster on OrderDate? Measure one month of orders on three designs and see what each one costs in reads before you rebuild a table.
MySQL – How to Create Stored Procedure
Confused by semicolons when you create stored procedure code in MySQL? Change the DELIMITER first, then reset it. Here is a simple example.
SQL SERVER – Optimal Memory Settings for SQL Server – Notes from the Field #006
No amount of memory is ever enough. Tim Radney explains the optimal memory settings for SQL Server, the setting people most often miss on a new server.
Exporting CSV Files Without Losing Leading Zeros or Dates
A postal code like 00501 turns into 501 in a spreadsheet. See where the zero is lost, how to build a correct CSV line, and why quotes alone do not help.
SQL SERVER – Working with Business Days in SQL Server – A Different Approach
I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.
SQL SERVER – How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets
Allow only alphabets in a SQL Server column with an explicit ASCII-letter rule. These tested examples reject empty strings, NULL, spaces, digits, and punctuation while explaining collation and existing-data checks.