Nice question, thanks.

I guess it's time to review my DDL triggers 🙂

Very nice in 2012 :). Takes windowed functions one step further.

USE [tempdb]

CREATE TABLE Sales (Id INT PRIMARY KEY IDENTITY(1,1), SaleAgentId INT NOT NULL, ProductId INT NOT NULL, SaleDateTime DATETIME2, Amount...

I couldn't find a solution for that, and didn't got any answer on multiple forums. I got that at some point looking better when I placed each table / matrix...

Hi,

You need to provide the type for the elements that you want to store in your list:

private List<int> values;

Cheers.

ALTER DATABASE ProdReports2008 SET TRUSTWORTHY ON

The above setting of database could be really tricky for some DBAs. As a developer, when I handed this request to our DBA, he just...