2012-02-02 (first published: 2012-01-20)
3,856 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
22,538 reads
Blogs
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Forums
The World of Data Science
Comments posted to this topic are about the item The World of Data Science
PowerQuery in SSIS... is it only in 2023?
First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...
Slicing status based on conditions
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...
Ask SSC