Performance would be the least of the reasons to separate databases by application. There's no difference between a server accessing one database for a thousand users, or accessing ten...

Not that I know of. Both can mess up your data in the same ways, so it's a pretty safe bet that both will have the same effect on...

torpkev (9/12/2008)

---

i know on a new install i can change the location..

but otherwise you're saying that I should move master to somewhere else, and that will be considered the default?

so...

Order By on Except, like Union, applies to the final result, not the sub-queries.

I could be wrong, but I don't think Excel can handle fields that size.

The other possibility that comes to mind is that the row-size has a limitation for total data....

As mentioned, it depends on what data you're keeping and why.

For example, if all of your applications have to access the same list of customers, then only keep one list...

Oh, one other point that matters: If you rebuild and index, don't bother with a stats update. Rebuilding an index updates the stats for you. Not true for...

Take a look at these articles and their discussions. Lots of data and options for auditing.

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

I run CHECKDB before I do nightly full backups. I can't see the purpose to backing up a corrupted database. Kind of defeats the purpose of doing the...

The only reason I know is because it came up when I was writing my articles about database auditing.

That's exactly what you posted.

Simon_L (9/12/2008)

---

a wonderful resource thank you ..

however I dont see the...

samsql (9/12/2008)

---

GSquared----- If you really need to pull the data 15 times, what you might do is take the parts that don't change, dump those into a temp table ONE...

I'm told RedGate's log parser doesn't work on SQL 2005 (a RedGate employee told me this), and that they aren't continuing the product. That's why I don't recommend that...

When you talk about tuning the performance, do you mean insert, update, delete or select, or all of the above?

The fastest way I know to select from such a table...