sql server
for db admins, data engineers
Why this scored 7
every term, weightedIts fastest-moving item, measured against the pace of its own source
Whether that velocity is itself speeding up, as a per-hour rate
How many independent communities its own items come from
Decays to zero over 14 days, counted from when we first saw it
Subtracted once something is big and old — sized by its biggest item, aged from when we first saw it
Weights are hand-tuned, not learned — we're calibrating them against realized trends as history accumulates. On an entity's first sighting there's no previous reading to compare against, so acceleration starts from a neutral prior rather than a measurement, and velocity falls back to engagement over its whole lifetime until a second reading exists. Full methodology
Outlook
high confidence · estimate, not a guarantee7-day
~0
range 0–12
14-day
~0
range 0–14
30-day
~0
range 0–19
Signal history
7-day window (free)projected trajectory (estimate, not a guarantee)
The evidence
The live items this entity's score aggregates — every community independently talking about it right now. This is the corroboration, shown, not claimed.
- 150
How to efficiently handle deep pagination and sorting for 12.5 million records?
Handle large records efficiently · for backend devs, db admins
stackoverflowCoolingdevtools97d ago - 231
The Scariest Lines of Code I've Ever Written. Boooo!!!
Shows risky SQL Server code patterns developers should avoid. · for sql developers
devtoSteady 2 · sqlserverdata7d ago - 331
EF Core 10 Named Default Constraints: Preview the Migration SQL Before Deploying
Allows .NET teams to preview migration SQL, preventing deployment errors. · for .NET developers
devtoSteady 2 · sqlserverdata51d ago - 419
How to move the responsibility of executing some logic to the SQL Server instead of executing that logic inside the application?
Shift business logic to SQL Server stored procedures to reduce application complexity and load. · for backend developers, data engineers
stackoverflowSteadydata22d ago - 518
Why does node-mssql connect to the primary replica when using ApplicationIntent=ReadOnly?
Explains node-mssql routing to primary replica despite read-only intent, affecting DB scaling. · for backend engineers, node.js developers
stackoverflowSteadydata22d ago - 618
Optimize query to get row-based data with lots of attributes?
Guides optimizing heavy attribute queries in T-SQL environments. · for db admins, data engineers
stackoverflowSteadydata12h ago - 717
Working with noise words in CONTAINSTABLE
Guides handling stopwords in SQL Server CONTAINSTABLE full-text queries. · for database administrators, sql developers
stackoverflowSteadydata3d ago - 817
How to use one sequence per table in Entity Framework Core to generate new primary keys on INSERT in SQL Server
Shows how to use per-table sequences in EF Core for automatic primary-key generation on INSERT. · for .NET developers, database engineers
stackoverflowSteadydata3d ago - 917
Back up database task in Maintenance Plan cannot write to external drive, even with proxy account/credentials
SQL Server maintenance plans can't write backups to external drives even with proxy credentials, indicating permission issues. · for db admins, devops engineers
stackoverflowSteadydata11d ago - 1015
Getting a timeout error when trying to make a node web server run a stored proc on SQL Server 2022 Express
Node server timeout when invoking a stored procedure on SQL Server 2022 Express. · for backend engineers
stackoverflowSteadydevtools10d ago - 1115
EF Core migration fails with SqlException: there is already an object named 'Courses' in the database after resetting migrations
EF Core migration fails due to duplicate table; adjust migrations or rename objects. · for backend engineers
stackoverflowSteadydevtools61d ago - 1215
Dynamic Data Masking doesn't work with UNION
SQL Server dynamic data masking fails with UNION queries, exposing data. · for database admins, security engineers
stackoverflowSteadydata65d ago - 1315
How to combine pivot table columns?
Shows how to merge pivot table columns in SQL Server queries. · for data analysts, database engineers
stackoverflowSteadydata19d ago - 1415
Return multiple text and associated number from string
Shows SQL techniques to extract multiple text strings with their numbers. · for database developers
stackoverflowSteadydata26d ago - 1515
Verify the integrity of a junction table data
Verifying junction table integrity prevents relational data errors. · for database engineers
stackoverflowSteadydata10d ago - 1614
How do I prevent violation of UNIQUE KEY constraint caused by lots of inserts coming from 2 sessions
Provides strategies to avoid UNIQUE KEY violations during high-concurrency inserts in SQL Server. · for database admins, backend engineers
stackoverflowSteadydata70d ago - 1714
Is splitting rarely-queried wide columns into a separate table a sound way to speed up scans on unindexed columns?
Splitting wide columns can speed scans on unindexed tables. · for database engineers
stackoverflowSteadydata53d ago - 1814
How does one implement nested LEFT JOIN in "old style joins" on SQL Server 4.2
Shows how to write nested LEFT JOINs for SQL Server 4.2. · for db developers, data engineers
stackoverflowSteadydata21d ago - 196
Create a foreign key using a subset of values from a primary key column
Create foreign key subset · for database admins
stackoverflowSteadydata85d ago - 206
Does lock blocking make a ModifiedDate watermark sync safe?
Database sync safety questioned · for database admins
stackoverflowSteadydata91d ago