Thanks for all the advice, guys.

We'll get the populating procedure squared away first, and then maybe try some experiments to see which set up works best. It could be...

Eugene Elutin (9/29/2010)

---

The best thing I would suggest is to try insert all 8000 rows once (or in batches) with all required data populated.

If it is absolutely impossible in your...

Eugene Elutin (9/29/2010)

---

Nevyn (9/29/2010)

---

...

On the subject of non-clustered indexes, the issue would be the number of columns to be included. Even though they are only at the leaf level,...

Grant Fritchey (9/29/2010)

---

I guess my question is, where does the slowdown occur? Is it in the insert? If so, are you getting lots of page splits or is it just...

Eugene Elutin (9/29/2010)

Give it a TRY! Create the Identity Clustered PK, create and index for columns used for filtering (WHERE clauses) and JOINs to another table. You may want to...

sandy-833685 (9/27/2010)

---

Thx,

But its not hardcoded its an value which is stored in variable which is having a datatype as datetime. and after going through certain select and execution stored procedure.And...

sandy-833685 (9/27/2010)

---

Hi i am having table with column name time data type as datetime

And when i try to execute the select statement with convert like

select * from tablename

where convert(varchar(10),time,103)<'06/06/2010'

as i...

You could do a case statement that defaults them to a specific date if there isnt date information in the field ...

A mini example I build. I think this does what you want:

CREATE TABLE #test (myDate varchar(6))

INSERT INTO #test (myDate) values ('200612')

INSERT INTO #test (myDate) values ('200705')

INSERT INTO #test (myDate) values...

Its not a date if there's no day. Try appending '01' onto the field then converting.

byrdmom2 (9/23/2010)

---

The problem is that I will not actually know what the data is. The data I gave was just sample data to give an idea what it would look...

Yeah, its TOTALLY on their to-do list.

david_wendelken (9/21/2010)

---

Eric Russell 13013 (9/21/2010)

---

I hope society never advances to the point where an understanding of relational set theory by the average person is required just to get by; most...

Does it have to be from an SQL server stored procedure?

The main way I know of doing this is using WebDAV, which you can use with .NET to...

Gary Varga (9/21/2010)

---

Is Googling for answers a big problem here?

I think so. So many find an answer that appears to work but never ensure they understand why it does what...