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
Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into your Azure account and move to portal. Move to left side pane of portal and click on SQL databases. 2. Currently no database is available so we click on create a SQL database link. A… Continue reading Steps to create SQL database at Azure
Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried to install SQL 2016 CTP 3 on Microsoft Azure this time. In this blog I will guide you to install SQL Server 2016 CTP 3 on Microsoft Azure. Primary thing for this is you should… Continue reading Steps to install SQL Server CTP 3 on Windows Azure
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
