(Sara Rea) Data mining is the process of extracting meaningful information from large quantities of data. It involves uncovering patterns in the data and is often tied to data warehousing because it attempts to make large amounts of data usable.

(Doug Seven) This article is modeled after a presentation I gave at TechEd 2004, which has since been requested by many user groups around the country. I figured it would be easier to share this information through an article than trying to get to every user group in the world. The content of th

(Alex Homer, Dave Sussman, and Mark Fussell) ADO.NET and SQL SERVER, in previous incarnations, generally enjoyed separate design and development routes. But ADO.NET 2.0 and SQL Server 2005 (formerly code-named “Yukon”) share a great deal of functionality and complementary technologies. As these

(Kalen Delaney) The sysindexes system table contains information (such as disk space used) that isn’t available through any supplied system procedure, function, or view. Many people might never need this information, but if your needs go beyond the tools Microsoft supplies, it can be helpful to unde

If the storage mode of a partition is relational OLAP (ROLAP) and its source data is stored in Microsoft® SQL Server™ 2000, SQL Server 2000 Analysis Services attempts to create indexed views to contain aggregations of the partition. If Analysis Services cannot create indexed views, it automatica

(Thiru Thangarathinam) Microsoft SQL Server 2005 provides a completely new enterprise extraction, transformation, and loading (ETL) platform called SQL Server Integration Services (SSIS) that ships with the features, tools, and functionality to build both classic and innovative kinds of ETL-based ap

(Vinod Kumar) In mids of loads of new features introduced in SQL Server 2005, this is one feature that interests the DBA’s the most. If you work with large number of servers and large number of databases you might want to have immense control the way you monitor and maintain SQL Server instances. In

(codeajay) This small but important utility has been created for users who would surely like to understand how to import and export data between SQL and CSV files. There are many alternatives to this utility. The (BCP) bulk copy of SQL provides a facility to insert multiple records through a single

(Frank Kalis) When you follow online communities dedicated to SQL Server with open eyes, you certainly notice a whole lot of questions are closely related to the DATETIME datatype in one way or the other. Obviously, working with DATETIME not as easy as it may seem.

(Arthur Fuller) SQL Server’s ability to optimize and compile a stored procedure is great but, if you aren’t careful, it can bite you when you least expect it. See how Arthur Fuller executes a stored procedure using the WITH RECOMILE option, and then consider whether you need to revisit any stored pr