2012-02-02 (first published: 2012-01-20)
3,708 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,959 reads
Blogs
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
By kleegeek
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...
The PowerBI Volleyball Report – Organizing Data To Start
By Steve Jones
One of my goals this year was to build a report that I can...
Daily Coping 2 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Import CSV Data Into Existing Tables
Hi Guys, I am having issues trying to import data from CSV files into...
Function not returning all data.
I inherited this code. Written by a 3rd party. I have 3 servers, 1...
Need to change RS Execution Acct PWD, automatically w/ T-SQL
We use a 3rd party vendor to administer our SQL Server service account PWDS....
Ask SSC