Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm, it'll be 5am...

CirquedeSQLeil (1/28/2010)

---

I was thinking of suggesting this as a possibility for our chapter too. What do you use Jack (for remote presentations)? I imagine a webcam and good...

Alvin Ramard (1/28/2010)

---

Have any of you tried replacing webcasts at your meetings? I know there's a ton (hmm, how much does a webcast weigh?) of them out there that...

Alvin Ramard (1/28/2010)

---

He may have meant that he has "read the books" and that is basically all he knows whereas others have "so much time on", meaning more time working...

kingscriber (1/28/2010)

---

I am afraid that I am going to have to become that performance tuning professional. I am not foreign to SQL, just foreign to SQL from a DBA perspective....

If you have never, ever done a backup of that database (and if so why the hell not), then there is little or no chance that you will be able...

Good idea. I don't get the impression you have much respect for us or our time.

I think it's justified, especially with his last comment...

Have a look at this blog post as well, since it addresses the selectivity question.

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

Excuse me?

Are you implying that you'd rather we spend the time looking up the answers for you rather...

and I was just about to make some snarky comments.... 😉

kingscriber (1/28/2010)

---

If the purpose for a non-clustered index is mainly for higher selectability (more unique or distinct) then why would the execution plan suggest that I have one on a...

kingscriber (1/26/2010)

---

Because the data is physically sorted based on the clustered key, using this column as a join will be faster so that the clustered index can point directly to...

I'm going to assume that you didn't read the article I referenced. Please take a minute or two and do so.

I don't think there is a specific question. From reading the first couple and last couple of lines, it looks like sprabhakaran is just getting started in SQL and wants...