GilaMonster (2/28/2013)

---

ScottPletcher (2/28/2013)

---

GilaMonster (2/28/2013)

---

ScottPletcher (2/28/2013)

---

GilaMonster (2/28/2013)

---

ScottPletcher (2/28/2013)

---

If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a...

Robert Davis (2/28/2013)

---

ScottPletcher (2/28/2013)

---

So if tempdb now does need to grow for whatever reason, and it causes a SQL issue because it can't, you've guaranteed that there's no easy way...

GilaMonster (2/28/2013)

---

ScottPletcher (2/28/2013)

---

GilaMonster (2/28/2013)

---

ScottPletcher (2/28/2013)

---

If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of...

Robert Davis (2/28/2013)

---

If you've...

Robert Davis (2/28/2013)

---

If you've...

Robert Davis (2/28/2013)

---

ScottPletcher (2/28/2013)

---

If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of resources...

GilaMonster (2/28/2013)

---

ScottPletcher (2/28/2013)

---

If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of resources vs...

GilaMonster (2/28/2013)

---

You don't need to correct the situation where one of more of the files has expanded because on restart of SQL the files will be back to their defined...

So you don't use a startup proc to verify tempdb data files are all the same size and sync them if they are not?

How, then, do you become aware of...

Jeff Moden (2/26/2013)

---

Just to emphasize the performance differences between using a string conversion or not for date conversions, let's do a little test... a race, really.

Here's the test data. ...

Robert Davis (2/27/2013)

---

ScottPletcher (2/27/2013)

---

If a tempdb data file is 1.5G when SQL goes down, won't it be 1.5G when SQL comes back up? Isn't it automatically reset to its...

Maybe it's just an issue I had.

The last time I altered the SIZE of tempdb data files in SQL, when SQL restarted tempdb files were still larger than that.

If the...

Robert Davis (2/27/2013)

---

NEVER manually shrink tempdb files. It can corrupt the tempdb files. Avoid shrinking files of any...

Robert Davis (2/27/2013)

---

NEVER manually shrink tempdb files. It can corrupt the tempdb files. Avoid shrinking files of any...

GilaMonster (2/27/2013)

---

ScottPletcher (2/27/2013)

---

Then, set up a start up proc to shrink both tempdb files ... I'd say to 1G each, so you have some cushion. You really don't ever...