Development · Uncategorized

SQL Server – DROP IF EXISTS in SQL Server 2016

Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets introduced which can be used with the existing DROP statement. Previously, within IF clause we were checking whether the object is exist or not. Here is the syntax that we were using in previous versions… Continue reading SQL Server – DROP IF EXISTS in SQL Server 2016

Performance Tuning · Uncategorized

How Client Statistics helps in improving performance in SQL Server

Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received from server to the client side. In other words, client statistics helps in analyzing the traffics load like packets/bytes sent and received at client – server side. When we run a script or query in… Continue reading How Client Statistics helps in improving performance in SQL Server