Tag Archives: sql

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 | 2 Comments

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