What happens when we drop a column on a SQL Server table? Where's my space?

You have dropped a column and wondering why you haven't recovered any space? Let's take a look.

How much Space can I expect to recover from a rebuild after dropping a column?

Check how much space you may expect to recover from a rebuild after dropping a column!

Identify Tables With Dropped Columns

How easily can we find tables with dropped columns that need cleanup?

The difference between BIN2 and Case-Sensitive collations in SQL

Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.

SQL Window Functions Series: LAG() and LEAD()

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

Learn how to use CTEs through the use of a number of examples.

Different ways to Convert a SQL INT Value into a String Value

I need to convert an integer to a string value, what options are available in Microsoft SQL Server with T-SQL scripts and stored procedures?

How to Move a Table into a Schema in T-SQL

To move a table into a schema in T-SQL, you can use the ALTER SCHEMA statement along with the TRANSFER option. Here are the steps to do this: Assuming you have an existing schema named "NewSchema" and a table named "YourTable" that you want to move into this schema: Open SQL Server Management Studio or […]

One use case for NOT using schema prefixes

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.

In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of your T-SQL code, because the schema prefix is important and useful most of the time. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial.

Understanding the Metadata Function DATABASEPROPERTYEX()

Learn how to use the DatabasePropertyEX() function to query your database for settings.