Tag Archives: SQL Server

Showing Blank Rows in Crystal Reports

In helping someone on the asp.net forums, I came across an interesting question relating to Crystal Reports. Most reports created print one row for each returned record. There is maybe …

Tags: , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Determine the Last Time a SQL Trigger was Used

In SQL 2008 and higher there is a new feature that can help audit triggers. By running the script below you can get some important information about triggers that are …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

LINQ to SQL with Totals

Ever since I have been using Linq2SQL, I am always impressed by the speed and the functionality of it. However; using SQL for 10+ years I always find my self …

Tags: , , , , , | Posted under Programming/Coding | Leave a comment