This post is a response to this month's T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-05-14
21 reads
Watch this week’s episode on YouTube. SQL Server Spool operators are a mixed bag. On one hand, they can negatively impact performance when writing data to disk in tempdb....
2019-05-07
264 reads
Watch this week's video on YouTube
SQL Server Spool operators are a mixed bag. On one hand, they can negatively impact performance when writing data to disk in tempdb. On...
2019-05-07
21 reads
Watch this week's video on YouTube
SQL Server Spool operators are a mixed bag. On one hand, they can negatively impact performance when writing data to disk in tempdb. On...
2019-05-07
15 reads
Watch this week’s episode on YouTube. When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs: or...
2019-05-13 (first published: 2019-04-30)
1,348 reads
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
14 reads
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
48 reads
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for every value they join on....
2019-05-07 (first published: 2019-04-23)
1,759 reads
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
22 reads
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
28 reads
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
This post shows you how to install containerd as the container runtime for Kubernetes...
Comments posted to this topic are about the item SQL Server Vector Support II
Comments posted to this topic are about the item Great Things
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers