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.

3.5 (6)

2005-05-19

18,588 reads

Blogs

Encryption in SQL Server #1 – Column Level Encryption

By

For one reason or another data security and encryption has been coming up quite...

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Read the latest Blogs

Forums

SSIS Import only new values from a CSV without using a staging table

By datsun

Hello, How can I import a CSV file in SSIS (2016) at the same...

Query store index rebuilds

By Rasmus Remmer Bielidt

Recently we experienced a sudden surge in disk I/O every twenty minutes or so....

Group Managed Service Accounts for SQL Server 2017/2019

By @@caffeine_level

We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers