Understanding Views in SQL
Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.
2020-06-30
Views
2020-04-20
816 reads
Insert and Delete SQL Server Data with Views
In this tip we look at how to insert and delete data via SQL Server views.
2020-01-13
Generate views to correct the column collation on a target DB's tables automatically
You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]
2019-07-05 (first published: 2019-06-26)
1,009 reads
SQL Server Trigger on View Example
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
2019-05-01
2017-10-05 (first published: 2017-10-02)
8,012 reads
2016-11-11
1,338 reads
2016-10-28 (first published: 2016-10-05)
13,075 reads
2016-07-14
1,428 reads
2016-06-27
1,358 reads
Blogs
Server vs Instance. A rant.
It’s a SQL Server Instance not a SQL Server. The product is SQL Server....
SQL Server and AKS
By Arun Sirpal
Following on from my last post after creating AKS, I now want to work...
Thoughts on Unique Resource Names in Azure
Each resource type in Azure has a naming scope within which the resource name...
Forums
Batchmode on rowstore: deadlock
Are there known issues with Batchmode on rowstore in CU11? One specific complex query...
Error shrinking database
While trying to shrink a database using the command "dbcc shrinkdatabase ([db_name])", I get...
Ask SSC