If you have two indexes that are similar and only the first key column is different, the indexes will cover different queries. In that case, why would you want...

FUBAR 😀

Tango

Even thought it'll be a while before I get to play with 2014, it's still nice to learn about it. Thanks for the question.

Nugent

I generally sort in tempdb because I don't want my database to grow. Growing takes time and consumes space long-term. Also, the tempdb is usually on a different...

The Google form is closed now, but I am interested in reading your thesis when you get it finished.

All other things being equal (fill factor, etc.) then yes it could. If you have inserts over time, then you likely have unused space in the index. Doing...

Then you're going to need to format your dates in your vb.net code before you call the stored procedure. If the SQL works, all you have left to do...

Toy

Jeff Moden (5/23/2014)

---

BWFC (5/23/2014)

---

Ed Wagner (5/23/2014)

---

Koen Verbeeck (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a...

Grant Fritchey (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that...

Dalkeith (5/23/2014)

---

Brilliant guys and thanks for the suggestion of Streaminsight.

This has told me one I'm generally going along the right lines and express is not the thing to do it...

DOH! I completely missed the "express" in the OP; thanks for catching it. I agree that you don't really want to run the data to SQL Express. ...

Dictate