Case Sensitivity in Selects - Part 3
See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.
2004-06-15
7,365 reads
See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.
2004-06-15
7,365 reads
2004-06-11
2,140 reads
2004-06-10
2,144 reads
Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others.
2004-06-07
6,126 reads
Your SQL Server has a case insensitive collation, but you need a case sensitive join? Do you know what happens? There are a couple options but do you know the performance implications of using each? Or a way to mitigate the performance degradation that can result?
2004-06-03
10,074 reads
2004-05-31
1,718 reads
Some days the simplest things go wrong. On this particular day Andy tried to remove a column that was part of an article in a transactional publication, wound up in an inconsistent state that required a snapshot to fix. Deeper investigation reveals the cause and a work around.
2004-05-25
7,510 reads
2004-05-21
1,926 reads
2004-05-20
1,526 reads
What happens when you have a day job, a web site, a new job at work, and a baby? Chaos! See what Andy's been up to the past few months. It's off topic from SQL of course, but it contains an interested bit or two.
2004-05-14
5,523 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers