Analysis Services limits the length of SQL expressions to 32 KB. Some applications require complex SQL Case expressions to define member names and keys, which would exceed the 32 KB limit. This article explains how you can work around the 32 KB limit.

(Andy Warren) I wrote an article recently (Is all code really code? One question from an interview) that discusses why I think developers look at TSQL as being "different" than "real" code. The article definitely provoked a good discussion, you may find it interesting just for that part alone. So wh

In Microsoft SQL Server 2000 Service Pack 3 (SP3), shared page locks can be held until the end of the transaction. This behavior may lead to blocking or performance problems.

(Pat Helland) This article explores Service Oriented Architecture, and the differences between data inside and data outside the service boundary. Additionally, it examines the strengths and weaknesses of objects, SQL, and XML as different representations of data, and compares and contrasts these mod

(Michael Otey) SQL Server’s datetime data type generates a lot of questions and confusion in the SQL Server community. Unlike some other major database platforms, SQL Server doesn’t provide discrete date and time data types. Instead, SQL Server’s datetime data type does the work of both. Here are an

(Brian Knight) In the last tutorial in this series of Reporting Services tutorials we added conditional formatting to the report. Now that we’ve created our first report and have added a bit of flare to it, let’s go ahead and make it even cleaner. In this very quick demonstration, we’ll go ahead and

In the article titled Understanding Reporting Services Web Service Access, we saw how the entire SQL Reporting Services can be controllled by using the web-service interface. We also built a sample application using the same. The very fact that you can control various aspects of Reporting Servic

(Teodor Lachev) This article presents an excerpt from the book Microsoft Reporting Services in Action. Learn how to implement advanced report functionality using custom code.

(Muthusamy Anantha Kumar) Scalar sub-queries return exactly one column value from one row. Scalar sub-queries can be used in CASE expressions, WHERE clauses, ORDER BY clauses and SELECT clauses. This article reviews a few examples of how to use scalar sub-queries in most situations.

(Michael Gonzales) When considering online analytic processing (OLAP), architects often focus on issues such as which dimensions to include, what facts are relevant, how often to refresh the data contents, and so on. Among these issues, the OLAP language is often overlooked. And of all the OLAP-cent