2012-02-02 (first published: 2012-01-20)
3,669 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
14,159 reads
Blogs
Using Azure Data Factory Mapping Data Flows to populate Data Vault
By Rayis Imayev
(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure...
New Azure “SQL Server settings” blade in the Azure Portal
I just noticed today that there is a new blade in the Azure portal...
Mass Backup All Sessions
Migrating Extended Event Sessions from one server to another should be a simple task....
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Buffer Pool calculation
Hello Colleagues. Could you tell me about how MS SQL Server 2016 SE determines...
SSIS Scale out deployment in a high availability cluster
Good day all, Just wondering if it will be possible to have a scale-out...
Ask SSC