Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2011

SQL Server – Moving table with LOB data to different file group

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

4 comments, 1,456 reads

Posted in SQL and Me on 19 October 2011

How to move table to particular file in database

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

1 comments, 1,070 reads

Posted in SQL and Me on 13 October 2011

SQL Server – SQL Server 2008 Service Pack 3 RTM Released

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

0 comments, 458 reads

Posted in SQL and Me on 7 October 2011

SQL Server – Marking a stored procedure as system object

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

0 comments, 1,059 reads

Posted in SQL and Me on 3 October 2011