Dealing with High Concurrency with Table Hints
Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.
2017-06-20
3,274 reads
Joao Osorio
- Website: https://www.ozzie.eu/
Data Lifecycle Management using SQL Server
With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.
2016-11-10
1,909 reads
SQL Server 2016: built-in JSON Use case scenarios
There's built-in JSON support starting with SQL Server 2016. Does that mean we should all ditch XML and start using JSON? It depends mostly on the target of your data output processing.
2016-08-16
4,519 reads
Continuous Integration with Microsoft SQL Server
What about database development? In most projects, developers aren’t focused on database development and for proper CI, the database version should keep neck to neck with the application builds.
2016-06-08
4,025 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Do entry-level cloud positions exist?
Hello friends. I’m new here, so if this is the wrong place for my...
Configuring Fargate task duration
Hi everyone! I've been working with a Fargate app recently and I've managed to...
Coding Magic Values
Comments posted to this topic are about the item Coding Magic Values
Ask SSC