Srinivas Sampath

  • Interests: Enterprise Application Architecture, Patterns, SQL Server 2005 and .NET

SQLServerCentral Article

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,738 reads

SQLServerCentral Article

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

32,054 reads

SQLServerCentral Article

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-09-22 (first published: )

50,617 reads

Blogs

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Daily Coping 27 Sep 2022

By

Today’s coping tip is take your time. Make space to just breathe and be...

Running SQL Server in Windows Subsystem for Linux (WSL)

By

I previously wrote a post on how to convert a SQL Server Docker image...

Read the latest Blogs

Forums

The Migration Tool to Use III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Migration Tool to Use...

SSIS File System Deployments

By RonMexico

I created a package that utilizes environment variables in the configuration manager to toggle...

Create a DACPAC to only update not replace a SQL Server Database

By Weegee71

Hi there We have been creating a DACPAC from a SQL server database project...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers