How much Space can I expect to recover from a ...
In my last article – Identify Tables With Dropped Columns – we saw how we can identify tables […]
TSQL
Identify Tables With Dropped Columns
In my last article – What happens when we drop a column on a SQL Server table? Where’s […]
What happens when we drop a column on a SQL ...
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly – The […]
The difference between BIN2 and Case-Sensitive collations in SQL
A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally […]
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
What Exactly Is a CTE in T-SQL? A Comprehensive Guide ...
Background A Common Table Expression (CTE) in T-SQL is like a versatile tool in the toolbox of a […]
Understanding the Metadata Function DATABASEPROPERTYEX()
SQL Server offers various metadata functions to return metadata information about databases and its objects. Today, I will […]