SQL Server grows easier to use and manage with every new release and, consequently, has become the database management system of choice for businesses of all sizes and industries. As your business grows larger so does the size of your databases and the number of users those databases support. Rest

When you run a complex query that contains a hash outer join operator in Microsoft SQL Server 2000, the results that the query returns are different every time that you run the query.

(Greg Robidoux) Ready or not here it comes! The long-anticipated release of Microsoft’s latest installment to SQL Server is finally here. Previously known as Yukon, SQL Server 2005 is slated for release on Monday, Nov. 7, 2005. Several versions of this product were made available through beta progra

(William Pearson) In this article, we will begin an extended examination of the MDX surrounding drilling up and down within our Analysis Services cubes. Comprising an analytical technique by which an information consumer can maneuver between summarized (“drilling up”) and detailed (“drilling down”)

(Vinod Kumar) SQL Server 2005 is loaded with features and in this article we will look at yet another function introduced in SQL Server 2005 . This function is called as NEWSEQUENTIALID().

(Duncan Edward Jones) This class library is a quick implementation to use custom attributes to marshal a .NET class to/from an SQL Server database table. It is fairly simple in that it assumes a one-to-one mapping between the class and the table.

(Daljit S. Saini) Security audit in SQL Server captures only successful and failed logins. It does not capture the application that uses the login. The login used by an application may have full read and write access on all of the tables and procedures but the application itself restricts the users

(Don Schlichting) This is the forth article in the transaction and lock series. Up to now, the locks and hints discussed have applied to both SQL 2000 and SQL 20005. However, this article will introduce Snapshots, new in Microsoft SQL 2005.

(Sushila D. Patel) Inserting a null value to the DateTime Field in SQL Server is one of the most common issues giving various errors. Even if one enters null values the value in the database is some default value as 1/1/1900 12:00:00 AM.

In this tutorial you will learn about T-SQL Enhancements in SQL Server 2005 – Data Definition Language Statements, .NET framework integration, Full Text Search, Index transact SQL Statements, Security Transact SQL Enhancements, Service Broker T-SQL statements, Synonym Transact SQL Statements, Table