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.

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.

Search Database Objects

A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.

SQL Server Monitoring Using Free Tools

You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!