My Humble SQL Tips

I found the following set of scripts at techrepublic.com Running the scripts after customising the variables to match your/your company...

Here's a simple query to get a list of database tables and the files and filegroups they are assigned to: I found this helpful tip on...

I ran into a problem where time sensitive data was being sent to Sales staff. Our servers are permanently set to Greenwich Mean Time (GMT) ...

I constantly had the problem that I needed to use DATEPART to create filenames and other customized strings from dates. The problem is that ...

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

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...