Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag WHERE Rss

Search for any content tagged where

   Items 1 to 4 of 4   

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.  Read more...
By Additional Articles 2016/07/07 | Source: | Category: seek
Rating: (not yet rated)  Rate this |   Briefcase | 3,017 reads

SQL Prompt 7.2 – Now With Execution Warnings!

Redgate’s code completion tool SQL Prompt now provides you with a handy warning if you try to execute an UPDATE or DELETE statement without a WHERE clause. Bob Pusateri explains why he loves this added layer of protection, and why you should too.  Read more...
By 2016/06/02 | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,669 reads

Conditional WHERE Clauses and Boolean Algebra

Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.  Read more...
By Tony Alicea 2010/08/31 | Source: | Category: conditional
Rating: |  Discuss |   Briefcase | 17,529 reads

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...   Read more...
By Additional Articles 2009/09/25 | Source: SQL-Server-Pro | Category: t-sql
Rating:  Rate this |   Briefcase | 9,375 reads
   Items 1 to 4 of 4