You generally don't want to rebuild small indexes because it's a waste of time, fragmentation doesn't cause problems with small indexes. The rough threshold I usually hear is somewhere around...

Always. I really don't like SQL and the OS fighting over memory (which they will do...

Err.. where?

Brandie Tarvin (10/10/2013)

---

I use StoryBox for...

dwain.c (10/9/2013)

---

Am I the only one left speechless and flabbergasted by this post?

http://www.sqlservercentral.com/Forums/FindPost1503017.aspx

I used to teach 2 methods to swap A and B in entry level university FORTRAN course (too)...

SQL is supposed to consume memory, that's how it's designed. If you don't want SQL to take all the memory on the server, set max server memory and that will...

Brandie, do you have any writing tools that you'd recommend, for tracking characters, places, plot segments, stuff like that? Preferably for iPad and PC.

The latest errorlog, not the latest job failure.

60ms isn't bad. Not perfect, but way better than I've seen in many cases.

If you're seeing IO bottleneck on TempDB, splitting the user DB into multiple files isn't going to...

Can you post the latest error log?

Custom functions in master would show master as the source.

Post the deadlock graph? I'd guess there's some built-in function or procedure involved (those are stored in the resource DB)

Got a job somewhere changing recovery models? Perhaps after the full backup?

Ask them how they know that.

First question, why are you splitting it, recoverability or performance? If performance, have you checked whether the current bottleneck is IO?

If it was CTP it would say CTP in @@version.