Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.
How to Kill Processes Idle for X Hours? – Interview Question of the Week #152
Question:Â How to Kill Processes Idle for X Hours?
How to Identify Session Used by SQL Server Management Studio? – Interview Question of the Week #151
Question: How to Identify Session Used by SQL Server Management Studio?
When to Use IDENT_CURRENT? – Interview Question of the Week #150
Question: When to Use IDENT_CURRENT and SCOPE_IDENTITY()?
How Many Temporary Tables are Created So Far in SQL Server? – Interview Question of the Week #149
Question: How Many Temporary Tables are Created So Far in SQL Server?
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
Question:Â How to Assign Multiple Variables in a Single T-SQL Query?Â
How to Validate Email Address in SQL Server? – Interview Question of the Week #147
How to Validate Email Address in SQL Server?