Hmm. In a normalized design, I wouldn't expect the region to be in the unit table, only the district.

Instead, I'd expect the distinct list of districts w/i a region...

1. The scale: there will be many servers to manage, much more than I've had to work with in the past.

2. The size of the instances: While the company is...

GilaMonster (3/4/2013)

---

ScottPletcher (3/4/2013)

---

GilaMonster (2/28/2013)

---

stehoban (2/27/2013)

---

Regarding point number 3 above. How to i reduce the size from 1.5gb to 800mb or 1gb ? Would this be by using the ALTER database...

Robert Davis (3/4/2013)

---

ScottPletcher (2/28/2013)

---

Yes, that's the problem. You're scattering (small) I/Os all over the drive, causing lots of drive head movement, which is brutal on performance.

Allocating "one drive" is...

GilaMonster (2/28/2013)

---

stehoban (2/27/2013)

---

Regarding point number 3 above. How to i reduce the size from 1.5gb to 800mb or 1gb ? Would this be by using the ALTER database command with...

Jeff Moden (3/3/2013)

---

In this case, the silent truncation is actually a desirable thing. I just think it odd that Scott would favor this particular method because someone not-in-the-know would...

BuntyBoy (3/1/2013)

---

SQL Server uses datafile in parallel and log file in sequential order..

Just as a best practice, for naming convention always try to use .ndf for second, third, etc data...

Jeff Moden (3/1/2013)

---

ScottPletcher (3/1/2013)

---

C'mon, be real, that code is clear enough that a decent developer will understand what it means. Anyone who's developed for SQL for any period of...

Lynn Pettis (3/1/2013)

---

ScottPletcher (3/1/2013)

---

Jeff Moden (3/1/2013)

---

ScottPletcher (3/1/2013)

---

Code reuse is another tricky subject. It generally gets talked about far more often than it is genuinely done. A few developers...

Jeff Moden (3/1/2013)

---

ScottPletcher (3/1/2013)

---

Jeff Moden (3/1/2013)

---

Eugene Elutin (2/28/2013)

---

This cut down number of CPU cycles when performing multiplication as it takes less number of bit-moves for multiplying smaller numbers - I...

Jeff Moden (3/1/2013)

---

ScottPletcher (3/1/2013)

---

Jeff Moden (3/1/2013)

---

Eugene Elutin (2/28/2013)

---

This cut down number of CPU cycles when performing multiplication as it takes less number of bit-moves for multiplying smaller numbers - I...

Jeff Moden (3/1/2013)

---

ScottPletcher (3/1/2013)

---

Code reuse is another tricky subject. It generally gets talked about far more often than it is genuinely done. A few developers are bad enough,...

Sean Lange (3/1/2013)

---

I don't think will quite work Scott. The OP said they are using month(MyDate) which will return an int. Casting a single digit...

First, make sure you're checking index fragmentation and only rebuilding indexes that actually need it.

Also, if you have tempdb properly tuned, look into using "SORT_IN_TEMPDB = ON" option when rebuilding...

Or simply:

SELECT CONVERT(char(2), myDate, 1)