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: )

93,146 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,603 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,239 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs

Forums

SQLServer Agent not sending dbmail on job completion

By maxo85

Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...

Ignore the entire record if a matching record is found

By SQL_Hunt

Hello, Kindly guide me with the following code in T-SQL. I need to only...

New Stuff Can Be Scary

By Grant Fritchey

Comments posted to this topic are about the item New Stuff Can Be Scary

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers