Then you're asking for SQL injection.

If I may suggest...

Look into moving code into stored procs and calling with parameters. It's a far more secure way of doing things.

How are...

It's an option, though the encryption is trivial to undo. There are a number of utils available on the web to decrypt 2000 or 2005 stored proc encryption.

There's no real...

Are you sure that every possible place that input is entered (including query strings) is checked for injection?

Are you building up SQL statements and executing them or are you using...

I would recommend a clustered index on that table. Without knowing what other queries run and how the data's distributed, I can't recommend what column to put it on.

The optimiser's very good usually. This is just an edge case where its estimate is wrong. Possibly because the table's a heap, not a cluster.

If you don't have a clustered...

I can't remember offhand. I did read it somewhere.

I think it's around 100 pages, but don't quote me on that. I'll see if I can find the source article tomorrow.

Depends how much usage your tempDB gets. How big is the file set for now?

For the proportional fill to work, all the files should be the same size, so autogrow...

Good point. What kind of data is in this database?

What error do you get when you try to drop it?

Because fragmentation has very little meaning on such small tables. Logical fragmentation is defined as the number of out of order pages. With only 1 page in the table it's...

Ok.

My guess. As far as the optimiser's concerned, the query returns too many rows for a seek/bookmark lookup to be optimal, and the index is not covering. Hence it uses...

Q (5/5/2008)

• Create many files to maximize disk bandwidth and to reduce contention in allocation structures. As a general guideline, create one data file per CPU. Each file...

The consider yourself lucky you still have a database.

If you want recommendations for your boss -

Change the web user to have the minimum required privileges

Go through...

Google 'SQL injection' then fix the web front end so that it checks input and uses parameters properly.

Forget delete statement. What if it had been a drop table or drop...

Can you post table schema, index definition, query and aprox rowcount affected by the query please?

It's probably because the index is not covering, and query affects enough rows that the...