Installing SSDT for Visual Studio 2017
I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it....
2018-06-19
3,949 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. ...
2018-06-19
649 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...
2018-06-19
17 reads
Join Elimination: When SQL Server Removes Unnecessary Tables
In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...
2018-06-19
24 reads
SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]
Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific...
2018-06-19
590 reads
What Twitter Account Should SQLSaturday Use?
Last week PASS sent out an email saying that on June 15 all the tweets from @sqlsat would be changed...
2018-06-18
356 reads
Analytics Platform System (APS) AU7 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is...
2018-06-18
614 reads
Analytics Platform System (APS) AU7 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is...
2018-06-18
651 reads
Database Fundamentals #17: Learning T-SQL
While SQL Server Management Studio (SSMS) provides a robust graphical user interface (GUI), the commands you’re going to use the...
2018-06-18
977 reads
Notes on SQLSaturday South Florida 2018
Notes:
Due to travel delays I missed the speaker dinner. I missed the chance to catch up and meet new people,...
2018-06-18
320 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
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