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.
2008-04-18 (first published: 2005-03-03)
94,404 reads
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.
2007-12-14 (first published: 2005-06-30)
32,470 reads
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.
2007-09-22 (first published: 2005-03-02)
50,903 reads
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.
2005-08-30
13,124 reads
Lots of people have created Power BI reports, using interactive data visualizations to explore...
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Comments posted to this topic are about the item Is Data Modeling Common?
Comments posted to this topic are about the item Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers