Love all the B5 books on your shelves. I've been bad about picking those up. I only have about 4 of them.

The real problem, if you want to call it...

Brandie Tarvin (6/25/2015)

---

So... at risk of alienating a potential fan base for my own ensemble-cast novel-in-progress.

Why did you hate his books (aside from him killing off favorite characters)?

Was it the...

antonio.collins (6/25/2015)

---

Thanks for the feedback.

The dba referenced the cited MSDN blog and correctly points out that ALTER INDEX ALL REBUILD does not update column stats. My counterpoint...

aido-1116077 (6/25/2015)

---

Thanks for your help folks.

Thanks Grant - I will take the stats out

I tested that command this afternoon on a TLog 65 GB 95% Log usage. Took 5 mins...

The log won't shrink on it's own. If you ran a log backup, then the committed transactions have been removed. But, you'll need to shrink the log manually to get...

Ed Wagner (6/25/2015)

---

You can have multiple sites accessing a single database with no problem. However, connecting with the sa login is a problem. You don't ever want to...

SQLBill (6/25/2015)

---

Grant Fritchey (6/25/2015)

---

SQLBill (6/25/2015)

---

Okay, so how many looked at the cat and then looked at the books and thought "I have that...

SQLBill (6/25/2015)

---

Okay, so how many looked at the cat and then looked at the books and thought "I have that one, don't have...

aido-1116077 (6/25/2015)

---

Thanks for your reply .

This was one option I was considering running after a daily insert into the DW tables

BACKUP LOG [databaseName]

TO DISK = 'nul:' WITH STATS =...

I would only suggest splitting up the databases if you have separate functionality that you're supporting. If the 40 web sites all have the same functionality, then breaking up your...

An index rebuild also updates statistics. So no, I wouldn't rebuild those stats right after that. Also, an index rebuild will update the statistics with a full scan, not the...

There's not enough information to do more than make a few guesses.

The first thing you need to do is capture the query metrics for the queries that are called when...

Get the Querying book. It's just outstanding.

Thank you very much for the kind words. Good luck with your indexes.

Here's an example[/url] of a PowerShell script that will script out the indexes. It's written to only pull the indexes from a single table. You can pretty easily modify it...