Question: Which is Better for Performance – SELECT or SET?
SQL SERVER – How to Download SQL Server Native Client?
Many times, there are some strange requests which I heard from my clients. I try to help my client with the answers and write a blog so that others can find the answers easily. Let us learn about SQL Server Native Client today.
How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165
There are many applications which are developed using an older version of SQL Server. As there are new releases happening, there are features, command, and syntax which are marked as deprecated features and might get removed in future version of SQL Server. It is always challenging for the developer to remember what is changed in the new release of SQL Server and what changes they needed to make sure that their application works with the latest version of SQL Server.
What is Alternative to CASE Statement in SQL Server? – IIF Function – Interview Question of the Week #164
Question: What is Alternative to CASE Statement in SQL Server?
How to Shrink TempDB Without SQL Server Restart? – Interview Question of the Week #163
Question: How to Shrink TempDB Without SQL Server Restart?
How to Reduce High Virtual Log File (VLF) Count? – Interview Question of the Week #162
Question: How to Reduce High Virtual Log File (VLF) Count?
How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161
Question: How to Get VLF Count and Size Information in SQL Server?