IgorMi (3/6/2013)

---

That said, I'm curious as to why you want a heap plus a nonclustered index for the base table rather than just a clustered index with no need for...

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

There's no requirement that the base table for an indexed view has any indexes at all.

That said, I'm curious as to why you want a heap plus a nonclustered index...

Copy the backup to a machine that has SQL server (or to a machine that a SQL server instance can see across the network) and run a restore headeronly. Even...

No need to read the backup file manually.

RESTORE HEADERONLY FROM DISK = <path to backup file>

Among the columns are SoftwareVersionMajor, SoftwareVersionMinor and SoftwareVersionBuild that tell you the version and service...

Why is SQL being restarted every morning?

SQLCharger (3/6/2013)

---

My tests have shown a performance degradation when the same queries run on compressed tables compared to uncompressed.

I know, there are fewer pages to trawl across, but it is...

Why?

What do you mean by 'looks after'?

btw, first page of search results for 'lazy writer plan cache data cache'

http://msdn.microsoft.com/en-us/library/ms181055%28v=sql.90%29.aspx

You use the log file any time you take a log backup, roll a transaction back, restart SQL and let the database recover, implement mirroring, transactional replication or CDC.

So...

TempDB problem...

Does restarting SQL help? Anyone been shrinking TempDB by any chance?

Uninstall, reinstall. Edition upgrade is for upgrades not downgrades.

I would also not rename the account.

Renaming it makes the account harder for hackers to locate and try to crack, but if the account's disabled there's no way to log...

Why do you want to do that? Are you aware of the impact that will have on query performance? Do you have jobs in place to manually create and update...

Steve Malley (3/5/2013)

---

Can someone explain how data compression works at the index level? If I compress a primary key, am I compressing the whole table [since the data pages are...