Srinivas Sampath

Recursive Queries in SQL Server 2005

Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.

4.61 (31)

2008-04-18 (first published: )

92,826 reads

An Introduction to the Service Broker

One of the more interesting new features in SQL Server 2005 is the Service Broker. It's not something to help you manage your financial future, nor is it some new program that handles all the instances and their accounts. It's a message queue and SQL Server MVP Srinivas Sampath brings us a look at this new feature with some code to get you going.

4.62 (21)

2007-12-14 (first published: )

31,485 reads

Common Table Expressions in SQL Server 2005

The next evoution of T-SQL, which will be released in SQL Server 2005, contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Coming ever so closer to the SQL-99 specification with Common Table Expressions, new author Srinivas Sampath brings us an introduction to this new way of writing complex queries.

4.74 (38)

2007-03-09 (first published: )

50,204 reads

Blogs

Sorting in Stored Procedures – Food for Thought

By

We know that sorting can be one of the most expensive things in an...

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

Read the latest Blogs

Forums

How to import Excel with XML

By itmasterw 60042

Hi, I have an Excel sheet that I have to import into SQL Server....

Recursive CTE - Batches

By koti.raavi

Hi Folks I'm trying to group rows into batch and adding batch to query...

XQuery - Use column value to display correct node

By Norty303

Hi All First time with XQuery and despite trying to read as many guides...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers