2012-02-02 (first published: 2012-01-20)
3,690 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
18,084 reads
Blogs
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Daily Coping 26 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
MSDTC and Always On AG
Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...
Remove Carriage Returns / Line Breaks / Any other reason the "text" moves down
I know this has been covered ad nauseum all over the internet for years....
Better query to get count based on column value
I am using SQL server 2008 R2 express edition. Out of below 3 method...
Ask SSC