System functions perform operations and return information about database objects in SQL Server. In this article, you will see some of the SQL Server System functions which provide
This SQL Server 2012 tutorial shows how to add linked server to SQL Server 2012 instance. Here is a step by step SQL Server linked server creation process:
I was busy setting up a new VM with SQL Server 2012 with the latest cumulative update (Build: 11.0.2325.0) and all the features enabled for installation. On the
T-SQL received a lot of improvements in SQL Server 2012 including support for the ANSI FIRST_VALUE and LAST_VALUE functions, declarative data paging using FETCH and OFFSET, and .NET’s
There are two approaches to move SQL 2008 to SQL 2012: In-Place: The SQL Server is upgraded where it is currently installed Migration: A a new environment is
The robust Transact-SQL (T-SQL) syntax in SQL Server provides developers with an efficient way to handle errors within stored procedures. This article discusses the @@ERROR, SP_ADDMESSAGE, and RAISERROR
Why simple select query is taking around 3000ms (3 Seconds) to execute while, same query is quite fast when executed from application? Answer is simple: SQL Server Management
Introduction In this article I give a short description of Stored Procedures. In this article I describe how to create a Stored Procedure, use of Stored Procedures, the
The following are the top 5 features of SQL Server 2012 which we consider the most interesting and useful: AlwaysOn Quite simply, SQL Server 2012 is going to
