2012-02-02 (first published: 2012-01-20)
3,680 reads
Jean Bulinckx
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
15,426 reads
Blogs
How I passed the 70-761 certification exam
By DesertDBA
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Forums
What Write Ahead Logging Is and Why It Matters
Comments posted to this topic are about the item What Write Ahead Logging Is...
SSAS Error: Duplicate attribute key found when processing
Comments posted to this topic are about the item SSAS Error: Duplicate attribute key...
Using Calendars and Dates in Power BI
Comments posted to this topic are about the item Using Calendars and Dates in...
Ask SSC