Posts tagged Microsoft
Transfer Logins and Passwords to a new server
01 year ago
If you need to transfer the logins and passwords from one server or instance to another server or instance, please refer to this very useful article from Microsoft:
How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008
Rebuild or Reorganize Indexes?
03 years ago
in General
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 [...]
