A Correlated Subquery references the outer query. I use a stock-item comparison after the earlier single-table aggregate lesson.
SQL SERVER – Two Different Requirements for a Single Table Subquery
A subquery can compare rows with an aggregate from the same table. A junior DBA asked about this over lunch.
SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files
Cannot shrink log file because the total number of logical log files cannot be fewer than 2. Here is what the message means.
SQL SERVER – Information Message: Cannot shrink file in database to xxxx pages as it only contains yyyy pages.
A reader hardcoded 1 GB in my log shrink script and got: Cannot shrink file in database to xxxx pages as it only contains yyyy pages. I explain why it appears.
SQL SERVER – Error 21028 : Replication Components are not Installed on This Server
After I set up AlwaysOn for a client, configuring replication failed: Replication components are not installed on this server. Here is how to fix error 21028.
SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server
Dropping a linked server with sp_dropserver failed with Msg 15190: There are still remote logins or linked logins for the server. Here is how to clear them.
SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database databasename. CREATE DATABASE is aborted
My 2007 post on Msg 1813, Could not open new database, is still popular. SQL Server expert Jeremy Roe sent an updated script for newer versions of SQL Server.