Azure at the Ranch
From our webinar today, I mentioned I had a dog named “Azure”. Here she is.
No, this isn’t an homage to...
2018-12-18
363 reads
Quickly Compare Data in Two Tables Using CHECKSUM and CHECKSUM_AGG
There are times when we need to compare two tables and figure out if the data matches. I often see...
2018-12-31 (first published: 2018-12-18)
4,290 reads
T-SQL Tuesday 109: Influence Somebody Recap
Small tokens of gratitude and small actions help to build this wonderful SQL Community that gives and gives and gives. Humility leads us to seek out ways to give...
2018-12-18
16 reads
T-SQL Tuesday 109: Influence Somebody Recap
How have you impacted somebody in the community?
This month I am in charge of the topic for TSQLTuesday. The invite...
2018-12-18
234 reads
Seeing WriteLog wait type on your SQL Server?
One of the more common wait types for SQL Server is called WriteLog. In its most basic form it is...
2018-12-27 (first published: 2018-12-18)
3,702 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 – nested...
2018-12-31 (first published: 2018-12-18)
3,011 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
24 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
34 reads
Meetup Pro for Non Profits
We use Meetup for SQLOrlando. We have enough members that we have to pay for the service and it works...
2018-12-18
266 reads
Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause
The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...
2018-12-18
187 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers