This is an estimated execution plan, not the actual execution plan, so there may be other issues that I can't see with this. The thing that jumps out at me...

Solid Quality instructors travel. A lot. You can also pay a little extra and bring them to your location directly. My...

Silverfox (9/14/2009)

---

I Know I can always reply on you Grant to give me something to talk about lol. let me have a think and i will edit this post. I...

dma (9/14/2009)

---

Grant, you missed a third category...the cynic..the guy who will just do the bare minimal to keep his job and keep envying others who do more, learn more and...

Rudy Panigas (9/14/2009)

---

Build or Buy, good question. I believe that building is a great way to really learn a lot about SQL server and is great for small companies that...

Thinking about this some more, I have a question back to you SilverFox.

Are you simply trying to know just enough to maintain your current position or get hired at the...

You're talking about 4GB database? As in gigabyte?

That's teeny-tiny. Having a million people connecting to it is pretty scary, but you should be able to put the entire database, including...

There is no need to order the inserts of your data. This is because your data is not stored in a perfect order. Even a clustered index, which is logically...

ma.daissaoui (9/14/2009)

---

I have the following tables Categorie and ProductCateg ,CategorieChild

table CategorieChild ====> IdCategorieChild | Idcategorie

...

Unless the two databases were identical in every possible way, you couldn't transfer the statistics (not that you can). But if they are identical in every possible way, the generated...

Micrososoft has an Upgrade Advisor that will check your 2000 database to see if it has any deprecated code, so you can fix it before there are errors in 2005...

Jack Corbett (9/14/2009)

---

We had short debate about this in planning for SQLSaturday #21 - Orlando. One of the sponsors wanted to have some time to do a demo of...

David.Poole (9/14/2009)

---

If I am a fan of a tool then I have no qualms about pushing that tool regardless of who produces it.

There will always be people who complain about...

giaks0wn (9/14/2009)

---

Reminds me of a corporate finance class with the instructor determined to make sure you could recite the formulas. Sure, everyone knew which calculator button to push and...

RBarryYoung (9/11/2009)

---

Grant Fritchey (9/9/2009)

---

Jeff Moden (9/9/2009)

---

:blush: Heh... that's odd. ...