Jean Bulinckx

  • Interests: T-SQL, Performance, Correctness & Reliability

SQLServerCentral Article

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.

3.5 (6)

You rated this post out of 5. Change rating

2005-05-19

24,109 reads

Blogs

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

By

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...

Read the latest Blogs

Forums

Execution Plan Operators

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Execution Plan Operators

Merge spans with Dates Logic

By dhanekulakalyan

--for a given member if the startdate and endate is continous we need to...

Merge data from two different source until the data is available from both sourc

By komal145

I have two sources , one coming from datalake and another is file. we...

Visit the forum

Question of the Day

Execution Plan Operators

When looking at an execution plan in SSMS, what types of operators are shown?

See possible answers