Question: How to Schedule a Job on SQL Server?
Answer: A very old and widespread question, keep on coming back to in interviews. Let us see how to schedule a job on SQL Server.
How Does TOP WITH TIES Work in SQL Server? – Interview Question of the Week #159
Question: How Does TOP WITH TIES Work in SQL Server?
Answer: This is an ancient question I just encountered in the recent Comprehensive Database Performance Health Check.
How to Drop All the User Created Statistics by SQL Server? – Interview Question of the Week #158
Question: How to Drop All the User Created Statistics by SQL Server?
How to Find DISTINCT COUNT of Column Rows Without Using Distinct Count Keywords? – Interview Question of the Week #157
Question: How to Find DISTINCT COUNT of Column Without Using Distinct Count Keywords?
How to Get Top N Records Per Group? – Ranking Function – Interview Question of the Week #156
Question: How to Get Top N Records Per Group? (using Ranking Function)
Answer: During a recent interview, I had given this simple puzzle to over 40 candidates. This simple puzzle depends on Ranking Window Functions.
How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155
Question: How to List All the clustered and nonclustered Indexes of Your Table in SQL Server?
How to List Queries With Memory Grant and Execution Plan? – Interview Question of the Week #154
Question: How to List Queries With Memory Grant and Execution Plan?