2012-02-02 (first published: 2012-01-20)
3,762 reads
Jean Bulinckx
- Interests: T-SQL, Performance, Correctness & Reliability
Indexed Views With Outer Joins
SQL Server 2000 has indexed views, which can greatly improve database performance. However there are a number of restrictions on building the view, including the restriction against outer joins. So how can this work? New author Jean Charles Bulinckx brings us a technique that can help you get around this restriction.
2005-05-19
20,339 reads
Blogs
Techorama 2022 Slides
By Steve Jones
I had a great time at Techorama. I’ll do a writeup on the event,...
Daily Coping 27 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Load balancing IPv6 UDP
It seems that none of the cloud providers have internal load balancers that can...
Beginner Question about Azure SQL Database and Source Control (Azure Dev Ops)
Hi guys, I hope someone of you has the time to help me. I...
The 2022 Preview
Comments posted to this topic are about the item The 2022 Preview
Ask SSC