Posts tagged Rebuild

Rebuild or Reorganize Indexes?

0
3 years ago
in
The query below can be used to identify those indexes that should be rebuilt (using ALTER INDEX REBUILD WITH (ONLINE = ON), or those that should be reorganized (USING ALTER INDEX REORGANIZE): SELECT object_name(a.object_id) as TableName,     a.index_id,     a.Index_Type_Desc,     b.name AS [...]

Reinstalled SQL Server 2005, with the wrong collation??

0
3 years ago
in
If yes, then following the instructions below, from MSDN (http://msdn.microsoft.com/en-us/library/ms179254.aspx): Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them. See my note below Export all your data using a tool such as bulk [...]
Go to Top