My Humble SQL Tips

As all SQL professionals will know sqlservercentral.com is an amazing resource. In an entry titled Linking to the Previous Row the author,...

Here is a simple user-defined function to parse a comma separated (or any other character separated) list and return a table of the values i...

The select statement below is an easy way of creating a comma separated list within a larger select query without the need for a cursor, use...

A helpful query found on Patrick LeBlanc's blog : The result set returns a list of SQL Server Reporting Services Reports matched ...

I had a situation where I had miscalculated the disk I/O load of the TempDB data and log files and therefore needed to alter the RAID config...

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