A client asked how to download SQL Server Native Client. My tip: search for the SQL Server Feature Pack, which includes the Native Client drivers.
How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165
Is your application using deprecated features that a future SQL Server may remove? Here is how SQL Server helps you find them, starting with a Profiler event.
What is Alternative to CASE Statement in SQL Server? – IIF Function – Interview Question of the Week #164
What is the alternative to CASE statement in SQL Server? The IIF function. Here are two examples of CASE and IIF, and why IIF deserves more use.
How to Shrink TempDB Without SQL Server Restart? – Interview Question of the Week #163
A client ran the shrink command again and again, but TempDB would not get any smaller. Here is how to Shrink TempDB without a SQL Server restart.
How to Reduce High Virtual Log File (VLF) Count? – Interview Question of the Week #162
Found a high Virtual Log File (VLF) count in your database? Here are the steps I follow to bring the count down, starting with the log file details.
How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161
How do you get VLF Count and size in SQL Server? Newer versions add a Dynamic Management Function for it. Here is the query, plus links to my older methods.
How to Schedule a Job in SQL Server? – Interview Question of the Week #160
How do you Schedule a Job in SQL Server? First make sure SQL Server Agent is running, then follow these simple screens to add the job, its steps and a schedule.