Articles

SQLServerCentral Article

Recursive Queries in SQL:1999 and SQL Server 2005

How many of you have written resursive queries in SQL? Or any language since school for that matter? Not many people write recusrive queries because of the complexity, the difficulty to understand how they work, and the chance for heap overflows. However, SQL Server 2005 implements Common Table Expressions and recursion in a way that is much easier to code and incorporates some safeguards. New author SQL Server MVP Frederic Brouard has written a fantastic article looking at resursive queries.

(64)

You rated this post out of 5. Change rating

2008-05-16 (first published: )

68,302 reads

Blogs

Rambling about Data on Wheels – origins, branding, expansion

By

I have been asked many times about how the name “Data on Wheels” came...

Think Twice Before Enabling Fabric’s Inbound Network Protection

By

Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By

Most apps that call an LLM send every request to the same model. That...

Read the latest Blogs

Forums

AI Observability Challenges in FinOps as a DBA

By dbakevlar

Comments posted to this topic are about the item AI Observability Challenges in FinOps...

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers