SQL Clone
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 5 of 5   

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.  Read more...
By Additional Articles 2017/10/09 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,571 reads

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: SQLPerformance.com | Category: seek
Rating: (not yet rated)  Rate this |   Briefcase | 3,090 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,841 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: SQLServerCentral.com | Category: conditional
Rating: |  Discuss |   Briefcase | 17,533 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,479 reads
   Items 1 to 5 of 5