What are forwarded records in SQL Server? It is an old concept, yet few new DBAs know it. Here is a short answer about heap rows that moved to a new page.
Can You DROP Offline Database? – Interview Question of the Week #144
Can you drop offline database in SQL Server? Yes, you can. Many DBAs I interviewed thought otherwise, so here is the full answer.
How to Create Primary Key Without ANY Index? – Interview Question of the Week #143
Question: How to create primary key without ANY index? SQL Server builds a clustered or nonclustered index for every primary key, so here is the answer.
How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142
SQL Server logins follow Windows password rules by default. If a login has it turned off, here is a simple script to Enforce Password Policy again.
How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #141
How do you Kill User Sessions (SPID) in SQL Server? First ask why you want to, since killing busy sessions rarely helps. Then here is the script.
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #140
How do you create a Temp Table from a stored procedure when you do not know its result set? Here is the OPENROWSET approach I use, and its drawbacks.
How to Insert Line Break in SQL Server String? – Interview Question of the Week #139
How do you insert a Line Break in a SQL Server string? Just press Enter inside the string, and switch SSMS results to text to see it. Here is how it works.