This is with respect to security and if it's that's easy who will trust the SQL Server? It's database security after all 🙂

One more good question with good topic VLF 🙂

Simple logic, if this statement is True we never encounter LOG FULL in simple recovery. But we do not as it depnd...

When you are transfering large data to new table; I suggest you create just basic structure of the table i.e. without indexes, rules etc.

Once transfer is done you can...

Check the following link for the detail:

http://msdn.microsoft.com/en-us/library/ms189612(v=sql.90).aspx

HTH

I guess index statistics are stored on the database level e.g.

object: sys.indexes

and

Dynamic view: sys.dm_db_index_physical_stats

Index is nothing but bunch of data pages(cluster index) and index pages(non-cluster index).

You are talking about...

Running profiler means you are capturing the information related to specific database / activity. For that SERVER has to collect the details and any activity on the server affect CPU/Memory/IO...

It depends on size of the data too!

One more challenging question, thank you Dave.

If your environment is 24x7 and having difficulty for downtime; you can check for ONLINE option while reindexing with ALTER INDEX command. Online index operations are available ONLY in SQL...

The answer is "True" as far as I know refer the following link for reference:

http://blog.sqlauthority.com/2009/01/04/sql-server-2008-change-color-of-status-bar-of-ssms-query-editor/

Splendid work!!

You can run a validation and findout which tables are out of sync. Compare the data between those tables which are out of sync. Lastly you can drop the problem...

There are two types of SQL Server upgrade

1. In place upgrade

2. Side by side upgrade

refer following link for more details:

http://technet.microsoft.com/hi-in/library/cc966519(en-us).aspx

HTH

You can write scripts on OS level to monitor the services and if stoped send message through netsend to monitoring desktop.

You need to have third party tool like MOM, redgate...

As a best practice you can restore the backup in test environment and execute the reindex on the specified table and check if the space available in the productin is...