SQL Server and .NET development

Problem Solve SQL Server and .NET development Issues

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

• Managing large databases with SQL Server partitioning

  When you're dealing with really large data sets (think in terabytes of data) it's especially important to save time wherever you can. Partitioning, and the resulting partition elimination, can save hours of query time in these huge databases. Continue Reading

• The CTE, the hierarchical query and SQL Server 2005

  Dan Sullivan shows how to use Common Table Expressions to query hierarchical data in SQL Server 2005. Hierarchical queries combine recursive SELECT commands to provide the functionality to query self-referencing data. Continue Reading

• SQL Server 2005 recursive functions and the CTE

  Dan Sullivan shows how to use SQL Server 2005's new Common Table Expressions to write recursive functions. Starting with a C# implementation he then goes on to demonstrate how to build the same recursion in a T-SQL function. Continue Reading