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

17,824 reads

Blogs

Synapse Analytics Spark Example 2 - ROW_NUMBER()

By

The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...

Synapse Analytics Spark Example 1 - Group By

By

I have been playing around with the new Azure Synapse Analytics, and I realised...

Renaming Files by Padding Numbers with PowerShell

By

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...

Read the latest Blogs

Forums

Transaction was deadlocked on lock resources with another process

By L_Goyal

I have table in SQL Server 2014. Please find the structure below: CREATE TABLE...

Conditional Column calculation

By aliasghar.09

Hello All, I have the following SQL Query, what I need is to have...

The media family on device incorrectly formed for read only file group restore

By thostenor

Yes the databases (source and destination) are the same version.  I have checked 3...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers