oops ok here it is:-D

All you ask for is in this thread, just in different posts.:-)

Tried that still get the same Execution plan...

and tried this...

CREATE NONCLUSTERED INDEX [IND_DIMBlog_BlogIDPageDeleted] ON [dbo].[DIM_Blog]

(

[BlogID] ASC,

[BlogUserID] ASC,

[Page] ASC,

[Deleted] ASC

)

Data...

here we go..

This is code.. script...

attached

But I do filter on Deleted

LIKE

SELECT NAME FROM <tbl>

WHERE Deleted = 0

This get all names that are not deleted.

I use deleted in every SELECT query.

As i said I dont...

Thanks those links are great !

Q: Can I have a combinatio of index on a table and let SQL server find the best one..??

Like (ref example above)

(Name)

(Deleted)

(Deleted,Name)

I used the field [Deleted] as either 0 or -1 (Type BIT)

I dont delete rows, I tag a row as deleted by TRUE or -1

Therefore [Deleted]...

Ok check this..

Field1 Name: Smith,Brown,Green

Field2 Deleted:0,0,-1

NOTE:-1 means deleted.

So I do WHERE Name = 'Brown" AND Deleted = 0

A good INDEX would be <tablename>(Name,Deleted)

BUT what if WHERE clause is only...

A sort order for an Index..

Is that wise ???

For example I have one column filled with BIT or -1 or 0

Shouldnt need to sort that !

When is it wise to...

Ok thanks..

The base64 encryption does not hide anything too secret, I am just using a simple method to keep the www idiots at bay.

Even if the code is cracked little...

Ok thanks.. you have confused me on (2)..

I have a role..I selected the StoreProc, pushed it to the role, to select EXECUTE.

So the role as the permission to execute...

Thanks for all your interest.

FTP is dead for pulling down OHLC stock data.

I have found these new providers that are XML and SOAP

http://www.xignite.com/Default.aspx

phew..saved me $$$$

Thanks to...

UPDATES of thoughts on project..

Additional information submitted:

11/08/2009 at 14:40 EST:

Payement made on completion. I am 10 star payer. So I will honor my debts, Thanks.

11/08/2009 at 15:50...

YES

YES ..as much as it can be..

YES FTP data is behind a username and password...