my statement looks like this

delete from table where column = 'value'

I just ran DBCC SHOWCONTIG on the table and found out that the indexes might be fragmented.

So I will give DBCC Reindex a shot and see how it affects the...

Total # of rows 5306052

Rows to be deleted 175000

This procedure creates a NewID column copies everything from ID to NewID, drops the ID column and renames NewID to ID. Now While creating the NewID column you can set...

The problem is I cannot get a list of city names. I have to work with only the kind of strings that I mentioned above.

I know its gonna be difficult,...

you are selecting all the rows of table "tblUsers_Sites" when you say "SELECT * FROM tblUsers_Sites WHERE UserID = @userid" and trying to equate it to tblSites.ID

Select only...