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
2,275 reads
Joao Osorio
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,494 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
2,668 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
3,611 reads
Blogs
ASF 030: Benni De Jagere interview
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best...
Forums
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Now Is a Good Time for Choices
Comments posted to this topic are about the item Now Is a Good Time...
Design ideas for hostoric data & trending
Hi everyone, I have a use case (below) for which I am considering multiple...
Ask SSC