Archives: October 2011
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:
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