If you are working with really long script files in SSMS, you might need to work on more than one part of the script at the same time. Perhaps you need to work on a function, and also on the code that calls the function.
On the Window menu, there is a Split option.
When you first do this, you’ll see a split window with the same query at top and bottom:
2026-01-03
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Administration Level: Intro
Question:
You are using Object Explorer in SQL Server Management Studio (SSMS) to browse the contents of a SQL Server. In the System Databases folder, there is a database named model. What is its purpose?
2025-12-31
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Development Level: Medium
Question:
Does a stored procedure automatically provide a transaction i.e., if a statement within a stored procedure fails, are all previous data modification statements rolled back?
Answer:
No, a stored procedure does not automatically provide an implicit transaction.
2025-12-30
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Administration Level: Advanced
Question:
When checkpoint writes occur, is only committed data written, or is uncommitted data written?
If only committed data, explain why.
If both, explain why.
Answer:
Checkpoint is a background process that:
This means that SQL Server doesn’t flush only committed transactions — it flushes all dirty pages, whether the transactions that modified them are committed or not.
2025-12-28
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Administration Level: Advanced
Question:
You know that the master database in SQL Server is now separate to the resource database (mssqlsystemresource).
Can you list three types of instance-level metadata that still live in the master database?
Answer:
2025-12-27
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Administration Level: Medium
Question:
If you have successfully created a SQL Server database backup, what could cause you to not be able to restore it, on the same server or another server ?
Answer:
A successful SQL Server backup does not guarantee that it can later be restored successfully. A few important points explain why:
2025-12-26
Execution plans are one of the most valuable tools in SQL Server for understanding how a query is executed. But even experienced developers and DBAs regularly misinterpret certain operators. Some of these operators look deceptively simple, others have subtle side effects, and a few behave differently depending on cardinality estimates or memory availability.
This post walks through the execution plan operators that are most frequently misunderstood, what they actually mean, and how to interpret them correctly.
2025-12-24
Upcoming processors are likely to have even more cores than now. Have you ever tried to write multiprocessor-style code? A friend of mine recently said that he learned some of this style of coding but later when he came back to it, he realised how much he thought he knew but didn’t.
For languages like T-SQL, we don’t have inherent support for multi-threading. In fact, the only trace I can see of this in T-SQL today is the ability to have multiple readers on a service broker queue.
2025-12-22
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Development Level: Medium
Question:
You are writing a query that involves inner joins across five tables. Does the order of the tables within the query affect the query plan?
Answer:
No. SQL Server determines the best order for you to join the tables in.
2025-12-21
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Administration Level: Advanced
Question:
Most information about each database is stored within the database.
Can you list three types of database information that live in the master database?
Answer:
Pick three of the following:
2025-12-20
