(William Pearson) In this article, we will explore distinct counts, discussing why they are useful (and often required) within the design of any robust analysis effort. Throughout this session, we will describe some of the challenges that are inherent in distinct counts, and then we will underta

(Andrew Zanevsky, Chad Littlewood, Michael Hayes, Raied Idan, and Bill Nicholson) The value of data captured by traces increases significantly if you run traces on a regular basis and preserve all results for historical trend analysis. But storage space quickly becomes a constraint. Our main pro

Take advantage of the huge .NET installed base. Sign up now for the SQL Server 2005 Business Intelligence Deep Dive: Turning Data into Decisions one day roadshow and find out how .NET, Visual Studio 2005, and the power of SQL Server 2005 can help you add rich Business Intelligence features to your .

(Helen Trimes) We all know that the dot.com boom is history and so are the lavish IT budgets. In the doldrums of the economic recovery, organizations tend to spend their money on streamlining internal processes to gain a competitive advantage. According to Microsoft, today’s information workers spen

(Itzik Ben-Gan) This white paper introduces several of the new enhancements to Transact-SQL in Microsoft SQL Server 2005 Beta 2. These new features can increase your expressive power, the performance of your queries, and your error management capabilities. This paper focuses mainly on relational enh

(Brian Knight) Last week we discussed character datatypes and their performance effects on your database. This week,we will dive into numeric datatypes. We will discuss how SQL Server numeric datatypes are stored and the pros and cons of each. (R)

(William Vaughn and Peter Blackburn) This chapter gives you a brief tour of Reporting Services and enough detail to get you started toward a better understanding of the technology, giving you more control over Microsoft SQL Server 2000.

(Dan Sullivan) We looked at the basics of a Common Table Expression, i.e. a CTE, in the previous article in this series. In this article, we will look at using a CTE to implement a hierarchical query. This article assumes that you are familiar with the basic syntax and operation of a CTE. You can lo

(Don Schlichting) In last month’s article, Full Text Searching was introduced as a way to query strings with more refinement than the usual TSQL “like” or equal operator statements. With Full Text Searching, a new file system structure is created, storing key words from selected fields into Catalogs

Sign up now for Visual Studio 2005 and SQL Server 2005: Extreme Development on the .NET Database and see how SQL Server 2005-based line-of-business applications built with Visual Studio 2005—from the data tier to diverse client devices and form factors—can add features faster, open new markets, and