Can an INNER JOIN returning more records than exist in a table be right? Jeff thought it was a bug. Our chat shows why it is possible and natural.
SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video
The first SQL in Sixty Seconds video shows how to convert subquery to CTE in about a minute. Short, easy tips from my co-authors and me.
SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed
Database diagram support objects cannot be installed because this database does not have a valid owner. Here is the quick fix I used on a friend’s database.
SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors
A friend needed to count Virtual Processors available to SQL Server 2000. Scripts for 2000 with xp_msver, and for 2005 to 2012 with sys.dm_os_sys_info.
Application Roles: Permissions That Follow the App, Not the User
Application roles sound like a lock only your app can open. This demo shows what the switch really does and why the password is the whole key.
Capturing Autogrowth Events With database_file_size_change
A data file grew over the weekend and nobody owns up. This small demo shows how one extended event tells autogrowth from a manual resize.
SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column
An interview riddle: create two columns but give a datatype only once, and copy data without UPDATE. A computed column solves it simply.