2012-02-02 (first published: 2012-01-20)
3,823 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
21,885 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
Azure SQL Revealed: A Guide to the Cloud for SQL Server
Comments posted to this topic are about the item Azure SQL Revealed: A Guide...
Refresh Limits
Comments posted to this topic are about the item Refresh Limits
How Many Days Can You Survive?
Comments posted to this topic are about the item How Many Days Can You...
Ask SSC