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
17,824 reads
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
By Ed Elliott
I have been playing around with the new Azure Synapse Analytics, and I realised...
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
I have table in SQL Server 2014. Please find the structure below: CREATE TABLE...
Hello All, I have the following SQL Query, what I need is to have...
Yes the databases (source and destination) are the same version. I have checked 3...
Ask SSC