2012-02-02 (first published: 2012-01-20)
3,779 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,862 reads
Blogs
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Community Tools Month 2022 - dbatools
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Storytelling with Data – Enertia User Conference 2022
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Forums
Missing weekend data to Zero
Hi All, I have a requirement that if there is no weekend data then...
How to calculate orders historically, during month
Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...
How Important is Software?
Comments posted to this topic are about the item How Important is Software?
Ask SSC