GitHub

Create a cheatsheet of common SQL query use cases

type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.‘Nice-to-have’ improvement, new feature or different behavior or design. It would be nice to have a set of ...
Searchenginejournal.com

Query Fan-Out Technique in AI Mode: New Details From Google

Google’s Robby Stein shares new details about the query fan-out technique in AI Mode, explaining how Google generates and executes its own queries. Google’s query fan-out technique issues multiple ...
Lifehacker

Use This App Instead of Excel to Directly Edit CSV Files

CSV, or Comma Separated Values, are files used for all kinds of things, from managing large datasets to exporting data to move it between web services. You might think CSV files are just spreadsheets, ...
GitHub

Option to Configure EF Core Query Generation for Compact Queries

Currently, EF Core generates SQL queries using AppendLine in StringBuilder by default, which introduces unnecessary memory usage due to the additional line breaks. This proposal introduces an option ...
www.cs.cmu.edu

The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining

SQL is the de facto query language used to interact with databases. Since SQL is declarative, users express the intended result of their query rather than the concrete procedural steps to produce the ...
Ars Technica

SQL help needed, size of files (and old files) on disk

Boss wants to know how much <STRIKE>junk</STRIKE> stuff is in each users' data drive, . I've got SMS collecting an inventory of all files on the drive (least I think ...