Articles

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(31)

You rated this post out of 5. Change rating

2008-04-18 (first published: )

94,503 reads

SQLServerCentral Article

High Availability (DR) Using SQL Server 2005 Transactional Replication

One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(9)

You rated this post out of 5. Change rating

2008-04-17

7,831 reads

Blogs

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

Read the latest Blogs

Forums

Alamat Telp BCA KCP Batu +62 838-4945-0961

By layanan 24jam BCA

Wa:083849450961 Jl. Panglima Sudirman No.1, Ngaglik, Kec. Batu, Kota Batu, Jawa Timur 65311

Alamat Telp BCA KCU METRO +62 838-4945-0961

By m4l4mt194

Wa:083849450961 Jl. Jendral Sudirman No.106, Imopuro, Metro, Kota Metro, Lampung 34111

Communication, For Incidents and Life

By Pat Wright

Comments posted to this topic are about the item Communication, For Incidents and Life

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers