SQL Server

24 Items Sort by date|Sort by title

SQL Windowing

  • Apr 15, 2012
  • This chapter from Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions provides the background of window functions, a glimpse of solutions using them, coverage of the elements involved in window specifications, an account of the query elements supporting window functions, and a description of the standard’s solution for reusing window definitions.

Table Expressions in Microsoft SQL Server 2008 T-SQL

  • Oct 22, 2008
  • The focus of this chapter from Microsoft SQL Server 2008 T-SQL Fundamentals is SELECT queries against table expressions. This chapter also introduces the APPLY table operator used in conjunction with a table expression.

Understanding SSAS in SSMS and SQL Server Profiler

  • Feb 4, 2009
  • In this chapter from Smart Business Intelligence Solutions with Microsoft SQL Server 2008, learn the ins and outs of some tools you’ll use when working with Microsoft SQL Server Analysis Services (SSAS) objects. After reading this chapter, you’ll be an expert in not only SQL Server Profiler but also SQL Server Management Studio (SSMS) and other tools that will make your work in SSAS very productive.

Working with Time in Microsoft SQL Server 2008 MDX

  • Feb 25, 2009
  • Analysis Services provides a number of time-based MDX functions. Using these functions, powerful metrics can be assembled. In this chapter from Microsoft SQL Server 2008 MDX Step by Step, you learn how to employ the time-based MDX functions to calculate some of the more frequently requested of these metrics.