Brandie Tarvin (12/16/2014)

---

WHOO! #HappySnoopyDance

I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.

Current execution...

don't forget, it's not just monitoring. There are backup products, deployment, source control, compare, all sorts of tools. Be sure you explore the full offering and, again, understand what it...

There is some crossover between products across those companies, but also you should note that each company also offers some unique tools not offered by the others. Be sure what...

Excellent point. Not something I tend to think of since I try so hard to avoid hints.

jvila (12/16/2014)

---

Hi, we have a table, with 10 indexes. This is the columns included

[font="Courier New"]

Name |Writes | Reads | Columns | IncludedColumns

-------------------------------------------------------------------------------

INDEX A| 15.112|2.117| BB,AA with included columns CC,EE

INDEX B|...

New Born DBA (12/16/2014)

---

Grant Fritchey (12/10/2014)

---

It depends on how your virtual environment is set up and managed. Many of them use physical storage, not virtual storage. In fact, a pretty...

Jeff Moden (12/16/2014)

---

Gosh. I can't believe that the Hierarchies On Steroids #1 article made it to the "Bacon" list on the Tribal Awards. I wouldn't mind winning that...

Yeah, a big part of why it's so important to pick the correct location for the clustered index is because it's so difficult later to rebuild them, especially if they're...

Tac11 (12/16/2014)

---

Mr. Grant Fritchey

you said in previous reply 'They don't do the same thing' (VERIFYONLY AND CHECKSUM).

In your article you said 'Verifyonly: Another way you can ensure that your...

In a perfect world, you would not store NULL values. However, in the world we live in, it's pretty normal to store NULL.

The real issue comes down to design and...

Just to know what they are.

The primary key uniquely identifies a row.

A foreign key is used to relate one table to another. It uses the primary key (or...

Yep. A long operation. Because clustered is not simply a property of the PK, it describes the type of index being created. A clustered index defines how the data is...

Both. And more.

CHECKSUM validates that what was read from the disk is what got written to your backup file. VERIFY_ONLY will then validate that what was written to your backup...

Another vote for source control. That's the single best approach.

You could look to third party tools. For example, Red Gate Software (my employer) has a tool called SQL Compare [/url]that...

Koen Verbeeck (12/16/2014)

---

Voting time again!

The tribal award finalists are out and a lot of threadizens are nominated in very different categories!

Somehow my blog ended up in the category "Best Blog",...