The backup process runs under the system process on the server where the backup is occurring. This means even when you call it remotely, it's running locally. So, the local...

rodjkidd (12/13/2015)

---

Hey Grant,

I have a ticket for Marillion in Boston Friday Nov 4th. 🙂

It's a early show - doors at 6.

I then have one for New York the week after....

I probably should have followed up. I wrote up the article from this data. It's here at Simple-Talk.[/url]

After removing lots of data, yeah, I'd probably do index rebuilds. That will also rebuild the statistics, so you don't need to worry about them. Just remember that fragmented indexes...

You could avoid DB configurations if you use one of the disk level replication features available from some of the larger disk vendors like EMC. But it's not going to...

There are a couple of links in my signature below this that I think are useful for performance tuning.

Oh, I didn't understand that it has to be writeable...

This really doesn't make a lot of sense... at all...

What the heck are they writing to this database that they're willing...

Ow.

The place to start with...

There's nothing uniquely special about an ODS. It's a SQL Server database that will primarily be used for reporting. I can't think of any special configurations that I've had to...

Yikes.

Why not simply keep the database unrecovered and continue to apply log files to it every day? Basically build your own log shipping process. It's still subject to utterly breaking...

I agree with everything Gail says (shocker).

However, if you don't already have a clustered index, then maybe using the same key structure she suggests will make for a good cluster....

rustman (12/11/2015)

---

Getting back to the original basis of the question of Tableau and SQL Server. I use Tableau with SQL on a daily basis, there are times that the sql...

rodjkidd (12/11/2015)

---

ThomasRushton (12/11/2015)

---

rodjkidd (12/11/2015)

---

ThomasRushton (12/10/2015)

---

Once again, SQL Bits has been announced and I have other commitments that week that I really can't get out of.

Pity they can't seem to stabilise...

Eirikur Eiriksson (12/11/2015)

---

ThomasRushton (12/11/2015)

---

Grant Fritchey (12/10/2015)

---

Grant Fritchey (12/10/2015)

---

That is beautiful. The sad thing...

Yep. I get it. Log files. Created when you create a database. The process of creating that database is to copy what's in the "model" system database. I suspect if...