The Difference Between Primary Key And Unique Key

“What is the difference between a primary key constraint and a unique key constraint?” This is probably the most frequently-asked job interview question for database developers. In this article, Ben Richardson will try to answer it.

Changing the default FTS language

Accelerated Database Recovery: How Big Is My Version Store?

When Query Store rolled out, there were a lot of questions about controlling the size, and placement of it. To date, there’s still not a way to change where Query Store data ends up, but you can manage the size pretty well.

Adding a New Transaction Log File when the Existing Log is Full

SQL Server Transaction Log files store details about every modification made to a SQL Server Data File. This includes when you need to add a 2nd log file. The act of adding a 2nd log file changes data in the primary filegroup for the database.

The SQL Server Data Row Size Question: Why is It Bigger?

This morning, I received the following question from a user: Hello Madam, Could you please clarify SQLServer “Data Row” size:If I run the script below on SQL Server 2012, then Slot(row) Size is 710 bytesif I run the same script against SQL Server 2016...

What Are You Going to Do About SQL Server 2008?

With support ending soon, Brent Ozar wonders what all the companies still running SQL Server 2008 are planning to do with those instances.

Scripting Out a SQL Server instance (Agent jobs, XEvents, Triggers and the like)

In order for a database system to work, you often need to provide programmable server objects. I’ve written very few databases that didn’t include agent jobs and triggers, or that didn’t require XEvents for diagnostics. 

Oracle RAC vs. SQL Server AG

As I have seen the benefit for having a post on Oracle database vs. SQL Server architecture, let’s move onto the next frontier- High Availability…or what people think is high availability architecture in the two platforms.

Cleaning up tempdb

The Extra Table