That's the principal database, not the mirror....

No way to answer that question in general. Depends on what exactly you're doing.

If you are talking about a subquery in the from clause (derived table) and a join, then...

mahesh.shinde (5/26/2013)

---

2. If output column log_reuse_wait_desc is saying LOG_BACKUP then simply take multiple time log backup of mirror database. Mostly 3 continuous T-log backup would enable db to...

Without seeing the details and specifics of what the maint plan does, it's going to be near-impossible to answer this.

If the table's empty, then yes you can probably change the data type. You will have to drop all indexes first and recreate them afterwards.

Improve performance, probably not.

Save space, if...

Without seeing what the maintenance job does and why it's trying to delete statistics in the first place, no way to say.

shohelr2003 (5/25/2013)

---

Actually I check log space regularly and take a log backup when necessary because there are some processes in my application that cause log file to grow larger. Otherwise...

Decimal(18,0) doesn't allow values like 5.5 or 6.1, only whole numbers because the...

Is the table so big that a 5-byte size reduction...

And?

Maybe, if the rebuild was recent enough.

Install logs do show the correct date, as in the date the install was done. Make sure you're looking at the right logs.

The file date stamps on some of the installation logs maybe. Look around near the location of the SQL binaries, sure to be an install log file somewhere around there.

No.

To do an index...

SELECT OBJECT_NAME(object_id) AS TableName, i.index_id, i.name, ds.name

FROM sys.indexes i INNER JOIN sys.data_spaces ds ON i.data_space_id = ds.data_space_id

The indexes and the filegroups they are on.

If an index is on a...

Sergiy (5/24/2013)

---

Look, just 1 row above you say:

If...