#sql

258 posts

@dev_community One Null in the Subquery and Your NOT IN Returned Nothing #Database #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22596235
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22596235
Don't have an account? Find a server at joinmastodon.org
Oct 16, 2026
@dev_community # A Practical Guide to Advanced SQL: Window Functions, Joins, CTEs, and Subqueries Using a Hospital Database #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22595180
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22595180
Don't have an account? Find a server at joinmastodon.org
Oct 16, 2026
@dev_community SQL for Web Developers: JOINs, Indexes, CTEs, Window Functions, and N+1 Queries #SQL #WebDev #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22589315
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22589315
Don't have an account? Find a server at joinmastodon.org
Oct 16, 2026
@dba_stackexchange Requesting feedback on data model for operational database #Database #SQL #DataModeling
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22588150
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22588150
Don't have an account? Find a server at joinmastodon.org
Oct 16, 2026
@in_plain_english What Actually Happens When You Run innodb_force_recovery? #Database #SQL #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/in_plain_english/posts/22595047
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/in_plain_english/posts/22595047
Don't have an account? Find a server at joinmastodon.org
Oct 16, 2026
@habr_ru После JOIN сумма выросла: как детализация ломает BI-витрину #DataEngineering #SQL #BusinessIntelligence
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22581739
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22581739
Don't have an account? Find a server at joinmastodon.org
Oct 16, 2026
@dev_community VACUUM FULL Locks Your Table the Whole Time. Postgres 19's REPACK CONCURRENTLY Doesn't #Postgres #Database #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22573043
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22573043
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dev_community SQL Beyond SELECT: Understanding SQL Sublanguages. #SQL #Databases #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22572676
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22572676
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dba_stackexchange Can xp_userlock do anything that sys.sp_getapplock cannot? #SQL #Database #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22570538
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22570538
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dev_community 100% activation, three inactive users: a SQL interview trap #SQL #Databases #Analytics
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22568173
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22568173
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@percona JavaScript in MySQL: Extending SQL, Not Moving the Application #Database #OpenSource #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/percona/posts/22561155
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/percona/posts/22561155
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dba_stackexchange GridDB Python client: Negative LIMIT value causes TQL syntax error #Database #SQL #Python
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22555200
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22555200
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dev_community The SQL Behind an AI Visibility Dashboard: Five Metrics and Their Traps #SQL #DataAnalytics #AI
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22548913
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22548913
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dev_community MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4) #Database #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22547555
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22547555
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dev_community PCAD-31-02 in Code: Validation Checks and Safe sqlite3 Queries Behind 30 of the 48 Items #Python #SQL #DataScience
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22547137
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22547137
Don't have an account? Find a server at joinmastodon.org
Oct 15, 2026
@dev_community You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster. #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22538063
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22538063
Don't have an account? Find a server at joinmastodon.org
Oct 14, 2026
@dev_community Database Indexes and Idempotency: What They Fix, and How to Get Them Wrong #Database #SQL #Backend
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22531645
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22531645
Don't have an account? Find a server at joinmastodon.org
Oct 14, 2026
@dev_community A patched SQL Server cluster stops syncing. The failure is identity, not the patch. #SQL #Database #DevOps
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22529429
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22529429
Don't have an account? Find a server at joinmastodon.org
Oct 14, 2026
@aws_builder_center Relational Databases and SQL in AWS: A Beginner's Guide #CloudComputing #Databases #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/aws_builder_center/posts/22530927
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/aws_builder_center/posts/22530927
Don't have an account? Find a server at joinmastodon.org
Oct 14, 2026
@dba_stackexchange Working with noise words in CONTAINSTABLE #Database #SQL #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22526235
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22526235
Don't have an account? Find a server at joinmastodon.org
Oct 14, 2026
@dev_community 0sql: How a Semantic-to-SQL Engine Adds Determinism and Security to Agent-Driven Queries #AI #SQL #OpenSource
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22513626
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22513626
Don't have an account? Find a server at joinmastodon.org
Oct 13, 2026
@dev_community Snowflake SQL patterns for revenue reporting #Data #SQL #Analytics
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22509430
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22509430
Don't have an account? Find a server at joinmastodon.org
Oct 13, 2026
@dev_community Announcing det: - Fast, local-first SQL ETL workspace and pipeline orchestration engine #DataEngineering #ETL #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22508969
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22508969
Don't have an account? Find a server at joinmastodon.org
Oct 13, 2026
@dev_community SQL Indexing Strategies for High-Performance Java Applications #Java #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22496967
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22496967
Don't have an account? Find a server at joinmastodon.org
Oct 13, 2026
@dev_community Testing a Free AI SQL Assistant Against a Real Schema: A Practical Workflow #AI #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22496315
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22496315
Don't have an account? Find a server at joinmastodon.org
Oct 13, 2026
@dba_stackexchange SQL 2025 Std Ed - LPIM and IFI #SQL #Database #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22484667
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22484667
Don't have an account? Find a server at joinmastodon.org
Oct 12, 2026
@meta_stackexchange SQL 2025 Std Ed - LPIM and IFI #SQL #Database #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/meta_stackexchange/posts/22484022
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/meta_stackexchange/posts/22484022
Don't have an account? Find a server at joinmastodon.org
Oct 12, 2026
@dba_stackexchange How do i change the plugin for the users mysql.session and mysql.sys #Database #SQL #MySQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22482650
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22482650
Don't have an account? Find a server at joinmastodon.org
Oct 12, 2026
@dev_community 5 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples) #SQL #DataEngineering #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22481194
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22481194
Don't have an account? Find a server at joinmastodon.org
Oct 12, 2026
@dev_community WHERE vs HAVING in SQL: A Simple Way to Understand the Difference #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22470433
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22470433
Don't have an account? Find a server at joinmastodon.org
Oct 12, 2026
@dev_community Beyond the Hype: A Realistic Guide to Choosing Between SQL and NoSQL Databases #Database #SQL #Backend
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22469154
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22469154
Don't have an account? Find a server at joinmastodon.org
Oct 12, 2026
@dba_stackexchange How do long-running queries on the secondary of a secondary availability group prevent ghost cleanup on the global primary? #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414390
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414390
Don't have an account? Find a server at joinmastodon.org
Oct 10, 2026
@dba_stackexchange Back up database task in Maintenance Plan cannot write to external drive, even with proxy account/credentials #Database #SQL #Backup
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414397
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414397
Don't have an account? Find a server at joinmastodon.org
Oct 9, 2026
@dba_stackexchange Oracle, selecting on query results #Database #SQL #Oracle
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414406
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414406
Don't have an account? Find a server at joinmastodon.org
Oct 9, 2026
@dba_stackexchange Best practices for interactive DB access across enterprise #Database #SQL #Security
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414425
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414425
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
@dba_stackexchange Database duplication when query cost is too high #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414434
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414434
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
@dba_stackexchange Failed to update SQL from 2019 to 2025 #SQL #Database #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414443
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414443
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
@dba_stackexchange SSRS upgrade 2000 to 2022 #Database #SQL #Upgrade
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414464
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414464
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
@dba_stackexchange Elevated value of PREEMPTIVE_OS_CRYPTOPS wait #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414484
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414484
Don't have an account? Find a server at joinmastodon.org
Oct 7, 2026
@evil_martians Don't bet on SELECT's order: shuffle your rows and see what folds #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/evil_martians/posts/22418605
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/evil_martians/posts/22418605
Don't have an account? Find a server at joinmastodon.org
Oct 7, 2026

« Newer Older »