Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work* when there is LOB data involved.

When we recreate indexes on a table containing LOB data, the LOB data pages are not moved to destination file group. This can be… Read more

Well, it can’t be done. You cannot move a table to a particular file in database.

What you can do is move the table to a particular file group. A FILEGROUP contains one or more data files. If the FILEGROUP contains more than one data file, SQL Server uses… Read more

Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server Team for more info.

For a complete list of issues that have been fixed in SP3, refer KB 2546951:

List of issues that are fixed by SQL Server 2008 Service… Read more

Marking a stored procedure as system object allows to run the procedure in a user database context. There are two requirements to allow running a procedure created in [master] database in user database context:

1. The stored procedure name must begin with "sp_" :

A stored procedure created with… Read more