An interview question: how do you keep one city on top while ordering data by name for the rest? The answer is a small trick in the ORDER BY clause.
How to Add Date to Database Backup Filename? – Interview Question of the Week #109
A reader using Backup to URL asked how to add the date to a Database Backup Filename. Here is a script that builds the name for you.
How to Enable Auto Update Statistics and Auto Create Statistics with T-SQL – Interview Question of the Week #108
Question: How to Enable Auto Update Statistics and Auto Create Statistics? Let us learn how we can fix that in today’s blog post.
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.
When was Database Last Backed Up in SQL Server? – Interview Question of the Week #107
When was each database last backed up? Here is the script I share in training that lists full, differential and log backup history for your server.
How to Query Multiple SQL Server with a Single Query? – Interview Question of the Week #106
A senior DBA needed to check SQL Server 2016 SP1 on every server. Here is the neat way he used to query multiple SQL Server instances with a single query.
How to Get Random Records from Table? – Interview Question of the Week #105
How do you get random records from a table? This interview question never gets old. Here is the ORDER BY method I use because its syntax is easy to remember.