Tag Archives: sql

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

Setting Up Data and Log Files For SQL Server

NOTE: As with all SQL Server ALTER DATABASE commands, I strongly suggest you back up your data before running these scripts. Among the many questions and options when setting up …

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

Finding Week Number in SQL Based on Fiscal Period

If your fiscal year matches the calendar year then SQL has an easy process of find the week number. You simply use something like this:

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