GilaMonster (3/4/2013)

---

That's when you're trying to reduce the initial...

GilaMonster (3/4/2013)

---

Bear in mind that a clustered index implicitly includes all the columns...

Ok.

At any rate, typically you'll want to cluster the table on the most common queries that can't be easily satisified by a nonclustered index you need anyway.

For example, if (nearly)...

You're going to exactly the same version as originally, right?

I think it's easiest to just restore all the dbs (other than model) after the switch.

There are so many things in...

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...