(Arshad Ali) SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APPLY operator becomes evident when

(Mike Chapple) SQL Server’s Declarative Management Framework allows you to create policies with which databases on your SQL Server 2008 system must comply. In previous articles, we examined how to create DMF conditions, create DMF policies, verify policy compliance and manually enforce policies. In

(Pinalkumar Dave) This article was written as a response to T-SQL Tuesday #005 – Reporting.

For those fighting with all the Extended Event terminology, let’s step back and have a small overall Introduction to Extended Events.

(Glenn Berry and Kevin Cox) In SQL Server 2005, 2008 and 2008 R2 Database Mirroring works at the individual database level. One challenge to using database mirroring is to keep your important SQL Agent jobs enabled or disabled depending on a database’s current mirroring role. If a database is actin

(Tibor Karaszi) Imagine a database mirroring setup where you have two LANs with a WAN link in between. Let’s call them site A and site B. Say that principal is currently in site A, and both mirror and witness are in site B. I.e., we are running database mirroring with a witness, and assuming we are

(Dinesh Asanka) Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index.

(Siddharth Mehta) The SQL Server Integration Services (SSIS) Merge Join transformation requires input data streams to be sorted for its operation. If during the design time you try to join two non-sorted inputs, it won’t allow you to do so. One of the options is to sort the data in the database rath

(Buck Woody) Microsoft SQL Server includes several technologies that not only provide protection for your databases, but also allow you to move data from one location to another for other purposes. Database Mirroring is one of those technologies.

(Mike Chapple) SQL’s UNION command allows you to combine the results of two or more database queries that are not necessarily linked through a database relationship. For example, imagine that you have a school database and wish to use it to create a master contact list for all students, faculty and