Views

Technical Article

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

3,000 reads

Blogs

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Need an alert for a sudden increase in data

By vsamantha35

Hi All, Today, all of a sudden the size of the data file (.mdf)...

how to identify table(s) changing quite often

By vsamantha35

Hi All, Is there any query using which we can tell what is the...

SSIS C# Script Question

By water490

Hi everyone I am working on a SSIS package where I am automating data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers