Generate views to correct the column collation on a target DB's tables automatically

  • Script

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: )

372 reads

Looking at VIEWs, Close Up

  • Article

Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.


6,986 reads


Check Query Progress with Live Query Stats


This is something I touched on back in 2017 a little after the Live...

SQL Server 2019 on Docker no longer runs as root by default


In my home lab I have an Ubuntu virtual machine that runs both SQL...

SQL Server 2019 – Compatibility Level in Azure


I am not sure when this became available but for Azure SQL Database 150...

Read the latest Blogs


Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

AlwaysOn 2 Nodes Next to Zero Downtime with SQL Edition Upgrade

By SQLDude

I'll attempt to be as specific as I can with this question. I've been...

SYMMETRIC KEY Incorrect syntax near 'TRIPLE_DES'

By DamianC

Hi All   I'm using SQL2016 I'm having an issue with a piece of...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers