My Humble SQL Tips

I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server.

Wednesday, 13 May 2009

Stored Procedure to move user database files

›
The following stored procedure allows you to move all files, including any fulltext catalogs, of a specific database. To run: I still...
Friday, 1 May 2009

Function for Determining the First and Last Days of Calendar Months

›
This Scalar-Valued Function below returns the last day of the month for the date passed into it. For example running: SELECT [dbo.][fn_Ge...
‹
Home
View web version

About Me

Thomas Mucha
View my complete profile
Powered by Blogger.