2012-02-02 (first published: 2012-01-20)
3,678 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,105 reads
Blogs
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup...
Using volumes in SQL Server 2019 non-root containers
I’ve seen a few people online asking how to use docker named volumes with...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Issue with processing dimensions
Hi all I've got a weird one here. We have a multi-dimensional cube...
Maintenance Window for SQL Server Critical Alerts
Hello, We had some sql server have issues on some production servers. We actually...
Ask SSC