Where conditions

Can you prevent deletes and inserts without a WHERE clause from running?

Erik writes a script to do what it says on the tin.

Indexing for Windowing Functions: WHERE vs. OVER

Erik Darling shows that if you take SQL Server's word when it asks for an index, things can go horribly awry.

What's "Actually" going on with that Seek?

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.

Conditional WHERE Clauses and Boolean Algebra

Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...

RE: Key range lock on every row in the table when selecting a single row

Good call, implicit conversion of the order_id to char supresses the index, and thus the key range locks on all rows.  Changing the stored procs fixed the issue.From: and order_id = 33096101  to:and order_id = '33096101'   

RE: Understanding 2nd Normal Form

hi, As I mentioned earlier I think of the surrogate key as a proxy for the real key, hence my loss of the true name "surrogate". More to your question "So, is it fair to say that Normalization rules do not apply to surrogate keys?" this is one of the old debates in database modeling. […]

RE: Data Modeling software, What is best?

Case Studio 2 turned out to be very good.  It will also do data flow diagrams.  I believe the price is around $400.  It will do more databases than ERWin and is also extensible through templates that you can design if you are willing to do the work.The one drawback that I saw with it […]

RE: Cross-server issues with sub-selects

I tried olavho's queries within our system (modified for one of our tables) and the MAX version worked just fine as one would expect. We are runnnig SQL 2000 SP3 something ("SP3a" I think). I've seen that kind of error message before when trying to perform subselects in an UPDATE but I see no reason for the […]