Tag Archives: SQL Server

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

Returning TOP and BOTTOM Rows in SQL

The other day I saw a request come across a forum that was asking how to get the top 1 and the bottom 1 of customers with most and least …

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