MERGE Statement – SQL Server 2008

In earlier versions of SQL Server in order to perform INSERT, UPDATE or DELETE we have to have separate T-SQL statements. With the introduction of SQL Server 2008 we have MERGE statement which helps in simplifying this. It allows us to perform DML operations based on certain JOIN conditions in single statement.

Continue reading MERGE Statement – SQL Server 2008

Auditing in SQL Server 2008

Auditing is a new feature introduced in SQL Server 2008. Auditing is a general word and its related to sql server to capture events that occurs in sql server, it’s similar to tracking the processes happening in sql server. This feature helps database administrators to implement a strategy to know who is performing what or to track events for a particular database. Auditing is spitted into two categories a.) Server Auditing specification and b.) Database Auditing specification. Lets look into those categories

Continue reading Auditing in SQL Server 2008

Intellisence

What is Intellisense?

IntelliSense is Microsoft’s implementation of auto completion, best known for its use in the Microsoft Visual Studio integrated development environment. This feature is now included in SQL Server 2008 and this is available from SSMS 2008. When this feature is enabled it will auto complete functions, syntax, database names etc.

Continue reading Intellisence