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
10 reads
Bert Wagner
Visualizing Nested Loops Joins And Understanding Their Implications
This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).
Watch...
2018-12-11
20 reads
Visualizing Nested Loops Joins And Understanding Their Implications
This post is the first in a series about physical join operators (be sure to check out part 2 – merge...
2018-12-11
940 reads
Visualizing Nested Loops Joins And Understanding Their Implications
This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).
Watch...
2018-12-11
13 reads
4 SQL Injection Techniques For Stealing Data
Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data.
However,...
2018-12-05 (first published: 2018-11-20)
3,376 reads
Two Words For Faster Scalar Functions
Watch this week’s episode on YouTube.WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why...
2018-12-04
232 reads
Two Words For Faster Scalar Functions
Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why bother talking about them in 2018?
Because no one is...
2018-12-04
18 reads
Two Words For Faster Scalar Functions
Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why bother talking about them in 2018?
Because no one is...
2018-12-04
8 reads
Brute Forcing SQL Logins and Passwords
Watch this week's video on YouTube
Following up on last week's post about the different types of SQL injection, this week I want to show how injection can be used...
2018-11-27
5 reads
Brute Forcing SQL Logins and Passwords
Watch this week’s episode on YouTube.Following up on last week’s post about the different types of SQL injection, this week...
2018-11-27
1,039 reads
Blogs
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers