(Ewout Stortenbeker) Admit it. We have all done it. And we all thought it was the best -and only- way of doing it. When we were building on-the-fly SQL statements to fire against our databases, we were all building up huge strings containing all the applicable WHERE clauses. Endlessly attaching more

(Arthur Fuller and Stephen Giles) Most IT pros are working in SQL Server 2000 and still supporting SQL Server 7 databases (a few folks are even supporting SQL Server 6.5 databases). With the arrival of SQL Server 2005, we’re often asked: Should I upgrade? In this article, we offer the 10 most compel

(William Pearson) In past articles of this series, I presented ways of “extending” the data source tables underlying our Analysis Services 2000 cubes through the use of SQL expressions within the Member Key and Member Name columns (in the case of dimension structures), and in the Source column (in t

(Bryan Sylverson) Figure 3-13 shows how to use the BETWEEN operator in a WHERE clause. When you use this operator, the value of a test expression is compared to the range of values specified in the BETWEEN phrase. If the value falls within this range, the row is included in the query results.

(Jeremy Kadlec) A single transaction in SQL Server is the lowest common denominator for performance tuning. When it comes to capturing and analyzing data at this level, the best native tool is SQL Server Profiler. Analyzing the results from SQL Server Profiler enables you to discern a great deal of

(Marcin Policht) In the previous article of our series covering SQL Server 2005 Integration Services, we discussed Control Flow tasks designed to simplify the transfer of SQL Server objects (such as databases, user-defined error messages, and SQL Server Agent jobs). We will complete this overview by

(Anthony Molinaro) This chapter excerpt from the SQL Cookbook explains how pagination and other advanced search techniques can be used to increase the quality of your SQL queries. (pdf)

(Jayaram Krishnaswamy) This article explains how to move data out of SQL 2000 Server and into SQL Server 2005. This hands-on tutorial shows a step-by-step procedure for moving to SQL 2005, the new database from Microsoft released in November of 2005.

(Serdar Yegulalp) Storage area networks, (SANs), make it easy to connect massive amounts of expandable storage to a server. SANs are particularly useful for SQL Server installations: Enterprise databases don’t just require a great deal of storage; they also have continually-expanding storage needs.

(Brian Mains) Extended properties are a new database feature with the SQL Server 2005 product. Extended properties store additional information for a wide array of database objects, such as tables or columns. For example, you could store table and column descriptions of purpose and business informat