CirquedeSQLeil (11/23/2010)

---

Stefan Krzywicki (11/23/2010)

---

CirquedeSQLeil (11/23/2010)[/b]

---

If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is it?...

CirquedeSQLeil (11/23/2010)[/b]

---

If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is it? Is there...

GilaMonster (11/23/2010)

---

Don't discount indexes with a bit as a leading column. Especially if lots of queries include that bit column in the where clause. I wouldn't suggest you index it...

GilaMonster (11/23/2010)

---

Stefan Krzywicki (11/23/2010)

---

Response to Long Answer: That's what I thought from reading the Books Online entry, that the columns would only be there once either way, but it is...

GilaMonster (11/23/2010)

---

An index on a bit field, probably not. But this is not an index on a bit field. It's a composite index on a bit and a date with...

GilaMonster (11/23/2010)

---

Short answer: Because the missing index functionality is rather limited (read stupid) and lists EXACTLY the index that it thinks it wants.

Longer answer: The columns will be there whether...

CirquedeSQLeil (11/23/2010)

---

Grant Fritchey (11/23/2010)

---

Paul White NZ (11/23/2010)

---

GilaMonster (11/23/2010)

---

Anyone up for a challenge?

http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx

I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL...

Greg Edwards-268690 (11/23/2010)

---

Paul White NZ (11/23/2010)

---

GilaMonster (11/23/2010)

---

Anyone up for a challenge?

http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx

I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and...

Jack Corbett (11/22/2010)

---

Thanks for all the well wishes folks. Still haven't seen the cardiologist, but have seen his nurse practioner, an internal medicine doc amd his nurse practitioner...

GilaMonster (11/22/2010)

---

Chris Morris-439714 (11/22/2010)

---

Our DBA caught some news on Twitter:

"Jack Corbet is in hospital, they suspect he has had a heart attack, he seems ok as he was on twitter...

Brandie Tarvin (11/22/2010)

---

Chris Morris-439714 (11/22/2010)

---

Our DBA...

GSquared (11/22/2010)

---

Stefan Krzywicki (11/20/2010)

---

GilaMonster (11/20/2010)

---

Totally lost. No idea what you're talking about.

Aside: This is why, when I took...

WayneS (11/21/2010)

---

Stefan Krzywicki (11/21/2010)

---

GilaMonster (11/21/2010)

---

bitbucket-25253 (11/20/2010)

---

All this gibbering and jabbering about age -- Your are all youngsters.

I've got a GREAT GRAND DAUGHTER born on April 2nd, 2010. As Jeff...

GilaMonster (11/21/2010)

---

bitbucket-25253 (11/20/2010)

---

All this gibbering and jabbering about age -- Your are all youngsters.

I've got a GREAT GRAND DAUGHTER born on April 2nd, 2010. As Jeff Moden once said...

bitbucket-25253 (11/20/2010)

---

Stefan Krzywicki

Now did you know the year WWII ended (1945) or did you have to Google that?

But...