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)

You rated this post out of 5. Change rating

2008-04-18 (first published: )

94,308 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)

You rated this post out of 5. Change rating

2007-12-14 (first published: )

32,409 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)

You rated this post out of 5. Change rating

2007-09-22 (first published: )

50,870 reads

SQLServerCentral Article

An Introduction to the Service Broker Part 2

One of the less exciting, but perhaps very powerful new features in SQL Server 2005, the Service Broker is an asynchronous communications method. MVP Srinivas Sampath brings us the second part of his series looking at what you can accomplish with a practical example.

4.75 (4)

You rated this post out of 5. Change rating

2005-08-30

13,096 reads

Blogs

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

Read the latest Blogs

Forums

Is Ransomware Fading?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Ransomware Fading?

How to Resolve SQL Server Database Stuck in Recovery Pending State

By Nisarg Upadhyay

Comments posted to this topic are about the item How to Resolve SQL Server...

A Simple Choice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Simple Choice

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table?

CatIDCatName
3Monitors
What is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers