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,382 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,526 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,821 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,649 reads
Blogs
More Azure Blob Storage enhancements
By James-Serra
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...
Daily Coping 25 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
A Byte of Redgate–Bonus Queso Recipe
By Steve Jones
As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...
Forums
HTML Mail with more than one line in Resultset
Hello all, i would like to send a html Mail with sql server. But...
AS Tabular and Sample Data in VS
Hello all, I really need your help – I want to use the sample...
SSIS Export Flat File as Fixed Width
Hi Forum, I have a table that uses the script below to create fields...
Ask SSC