What's the data type of the column in the table?

CTEs are defined before the SQL statement that uses them, not in it. something like this

;with MyCTE (col1, col2, col3) AS (

SELECT ... FROM aTable

)

SELECT [some fields] FROM MyCTE...

They're english abbreviations. Means postscript. Thoughts added after something else, usually only partially related.

Depends on the query. In the example you give, you can't replace the inequality operator. The alternative you give is identical to the original in terms of how its executed...

Re your second example (SELECT theValue FROM #Sample WHERE theValue <> 2), one thing I learnt recently is that partial index scans (seek to a value, then scan from there...

That...

If you think about it, there's no way that <> can be searchable. Searches are to find specific values, finding all except a specific value requires a scan

Imagine a telephone...

Take a look at the indexing on the Batch_Documents table, since it appears in all the deadlocks. Make sure that the updates and select are running as fast as possibel...

You're creating table Countries3, but inserting into countries2. Is that a typo?

Are there any triggers on the table?

I normally recomend that people stay away from query hints of any form unless they really, really know what they are doing and are sure that the hints help.

Even then,...

You can try the optimise for query hint, if there's a specific value that you usually use. Problem with that is if you pass in other values with vastly different...

Classic parameter sniffing problem.

When you use the value in the query (or a parameter), the optimiser, when it compiles the query, knows the value used in the condition, and can...

The optimiser can't properly see the results of the case statement at compile time and probably chooses worst possible case (column = column) where no index usage is possible.

The way...

Back on the topic of unused indexes.

The index usage DMV t4racks only since SQL last started. If an indx has not been used at all (no seeks, no scans, no...

Pam Brisjar (11/1/2007)

---

If you don't have a compelling reason to not avoid installing reporting services, I'd highly recommend it. Once it's installed you can get the performance dashboard for...