Views

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

337 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.

2016-06-07

6,986 reads

Blogs

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Kubernetes Pipelines

By

This post continues looking at some of the Kubernetes concepts I’ve been learning with...

Read the latest Blogs

Forums

Group and total by column Name

By craig.jenkins

Guys, How do i group the below by type and date so i have...

how to get 0 if records have empty or null values when column datatype is numeri

By asrinu13

Hi I have one doubt in sql server how to get 0 when records...

Azure Elastic jobs

By Evgeny Garaev

Comments posted to this topic are about the item Azure Elastic jobs

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers