2012-02-02 (first published: 2012-01-20)
3,697 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,588 reads
Blogs
Encryption in SQL Server #1 – Column Level Encryption
For one reason or another data security and encryption has been coming up quite...
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
This Saturday: #DataWeekender, DataSaturday Southwest
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Forums
SSIS Import only new values from a CSV without using a staging table
Hello, How can I import a CSV file in SSIS (2016) at the same...
Query store index rebuilds
Recently we experienced a sudden surge in disk I/O every twenty minutes or so....
Group Managed Service Accounts for SQL Server 2017/2019
We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...
Ask SSC