If you think that partitioning = magic performance improvement, you'll be sorely disappointed. While it can give performance improvements, the queries may have to be rewritten to take advantage of...

Not sure I follow what you're trying to do. What do you mean by 'materialized view log'?

First question...

Why are you partitioning? What's the reason, what's the goal?

sdpages (11/30/2012)

---

Can these trans log backup files be used in case of Failure and Restore of the server ? Will these trans log backup be used with my Weekly Full...

ScottPletcher (11/30/2012)

---

Grant Fritchey (11/30/2012)

---

And the indexes have to be selective enough to be useful for a seek or you'll get scans. Same things apply to non-clustered indexes too.

For lots more...

Seek when there's a SARGable predicate (<column> <comparison operator> <expression>) on the index key columns. Scan if there isn't. Very, very simplified, but that's the basics.

SQL Server 2008 Internals by Kalen Delaney

Paul Randal's blog.

The question then becomes, what's the reason for taking a copy-only log backup.

sanket kokane (11/30/2012)

---

ScottPletcher (11/29/2012)

---

Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each row...

http://www.sqlskills.com/blogs/kimberly/post/A-new-and-improved-sp_helpindex-(jokingly-sp_helpindex8).aspx

There is no guest login. If you don't have either a username and password or a windows login granted access to the DB, you cannot log in to SQL.

There are...

Highly unlikely to work. SQL can only recreate the log file if the DB was cleanly shut down prior to the log being damaged/lost.

Ah-ha!

Well there's your motivation for better hardware...

Please note: year old thread.

Something's taking full backups of the DB other than your SQL agent backup jobs. I've seen that with BackupExec, can probably happen with other VDI backups. Whatever they're using to...