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)
337 reads
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)
1,365 reads
2016-11-11
1,334 reads
2016-10-28 (first published: 2016-10-05)
2,556 reads
2016-07-14
1,423 reads
2016-06-27
1,355 reads
2016-06-09
1,443 reads
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
2015-07-27
1,618 reads
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
By Steve Jones
This post continues looking at some of the Kubernetes concepts I’ve been learning with...
Guys, How do i group the below by type and date so i have...
Hi I have one doubt in sql server how to get 0 when records...
Comments posted to this topic are about the item Azure Elastic jobs
Ask SSC