存储架构 2018-06-20

Is TSqlUnit worth using?

If I were to write some unit tests for my stored procedures, is there any benefit to doing this with TSqlUnit vis-a-vis C# / Entity Framework4 / TransactionS……
综合编程 2018-06-20

Is TSqlUnit worth using?

If I were to write some unit tests for my stored procedures, is there any benefit to doing this with TSqlUnit vis-a-vis C# / Entity Framework4 / TransactionS……
存储架构 2018-06-19

Designing a T-SQL trigger

On occasions when building a project involving an Access front-end and a SQL Server backend, we’ve run into this question. Should we use a trigger for someth……
存储架构 2018-06-13

五分钟聊T-SQL:数据压缩

在Microsoft SQL Server 2008 开始就提供了数据压缩,数据压缩分为两类: 一是数据库备份压缩,二是数据对象压缩(表/索引)。 传说中数据压缩能压缩到原始数据的1/10,……
存储架构 2018-06-12

It’s Azure T-SQL Tuesday #103

I’m slightly surprised that there haven’t been more invitations about Azure, with the main development branch of SQL Server being in the Azure cloud, but I……
存储架构 2018-06-06

Stupid T-SQL Tricks

Presented without comment: CREATE TABLE dbo.[FROM] ([SELECT] INT, [WHERE] INT, [LIKE] INT); GO SELECT [SELECT] FROM [FROM] WHERE [WHERE] LIKE [LIKE]; GONex……