masoninyourface (7/18/2012)

---

I think that's why I've enjoyed learning HTML/CSS, and I think that's why i think i might like working with SQL as a career. Does that sound like...

smorgan-607537 (7/18/2012)

---

Thanks, Jeff. There are a few reasons for what I am doing. Time - that is my time on this vs. other project deadlines. Knowledge -...

vlad64 (7/17/2012)

---

Hello All,

First off, I am mostly new to SQLCentral, yet I found a lot of useful information in helping my development as a SQL programmer, so big thumbs up...

Charmer, bear with me. I'm afraid I'm having a little trouble deciphering what you mean here so I'm going to answer each part with how I understood it. ...

For a 'final answer', you'd have to pick through the query plans. However, the reason in general that the dynamic/recompile options are preferred is because of how often you...

Did you use a job to run it or did you manually hook to the production databases to try to run it?

If it's you, you probably don't have the rights...

pdanes (7/19/2012)

---

Yes, I've done that...

Stefan Krzywicki (7/19/2012)

---

Lynn Pettis (7/19/2012)

---

Koen Verbeeck (7/19/2012)

---

100 books? I'm glad I can read 2 on a whole year (technical books not included).

Don't get me wrong, I love to read (read...

To add to the discussion, the consulting side of the street in the States definately behaves a bit differently. For example, they always want a chrono 10 year resume,...

Lynn Pettis (7/17/2012)

---

As long as he has been working with SQL Server, some of these questions are just hard to believe.

What if I had asked the same question, what would...

GilaMonster (7/17/2012)

---

I don't know. There have been some seriously strange questions from...

Ahhh, A-Team. The epitome of Imperial Stormstrooper Shooting Training. At least for the bad guys. The 'elite team' they were could be said to have always missed...

masoninyourface (7/16/2012)

---

I know this is a tough question to answer, but I guess i'm trying to get an idea of whether or not a career with SQL would work well...

smorgan-607537 (7/17/2012)

---

I did notice my DataFlow’s Component Properties in the Advanced Editor showed “OpenRowset Using FastLoad”. If I change that to be “OpenRowset” the task does FAIL on an...

Is the database being shrank after the reindexing completes?