I'd suggest taking a look at Minion Reindex. I wrote a review of it here[/url]. I think that'll help you.

john.ward 24608 (2/27/2015)

---

I have a live database that is participating in an AlwaysOn High Availability group using MSSQL Server 2012. This is set to backup nightly using the secondary node....

It also depends on how your filegroups are setup and how your objects are stored within the filegroup. It's entirely possible that you've got specific sets of data going to...

My concern would be how the function is applied to arrive at the checksum. But I'm with everyone else, why not just let them hit the string. Also, I'd consider...

Instead, I'd go with a more standard approach:

select name AS [Table Name],

create_date AS [Date created]

from sys.tables;

select @@spid...

The only way I can think to do this would be to capture the query metrics for all the databases and then group the data. There's nothing that splits CPU...

My preference would be to have pre-grown data files. I can control when it grows and how much it grows. This matters because auto-grow will cause blocking while the growth...

Have a full deployment testing process that builds your test scripts and test databases from a source control system. That way you can ensure that what you're deploying works and...

In most cases, no. But, that's because the optimizer will arrange and...

Nuts. Just spent 20 minutes looking through the books. Wonder if I hallucinated this book.

SQLBill (2/26/2015)

---

Sioban Krzywicki (2/26/2015)

---

Grant Fritchey (2/26/2015)

---

Brandie Tarvin (2/26/2015)

---

Jeff Moden (2/25/2015)

---

Brandie Tarvin (2/25/2015)

---

Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My...

Clearly clarity and computer science don't always go hand in hand.

I'm pretty sure using the query should get you ballpark close. It won't be perfect. I'm pretty sure the value...

Wait, so that means it wasn't a column, but part of a result set?

It's actually 1024, not 1000. That equates to 359kb. Probably what's not included is header information and meta-data about the backup itself. That would explain the extra 19kb.

spaghettidba (2/26/2015)

---

Lowell (2/26/2015)

---

arrjay (2/26/2015)

---

Perfect! Thanks.

The results don't include objects which have not been written/read to/from i.e. nulls. Is there a way of returning these stats? ...