Query to long time running........

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Query to long time running........

Query to long time running........

Rate Topic

Display Mode

Topic Options

Author

Message

Jorge Mendes

Posted Friday, November 02, 2012 5:36 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 18, 2012 12:34 PM
Points: 76, Visits: 88

Hello,

I've got to troubleshoot the following query but i'm lost since they've got one select "*" in the beginning of the query and in the where clause they got a like that i think its the problem.
I'm limited too in the field of the date but .... dont know how to check it!!! (i think Crazy

).

Can anyone tell me what should i do or should i do not do anything?
Sorry, thanks and regards Wink

SELECT * FROM tblname WITH(NOLOCK)
WHERE FiledDate > '2012-11-01 00:00:00.000'
AND FieldDescr LIKE 'xptonumber%'
ORDER BY FieldCodDesc DESC

Post #1380638

Luis Cazares

Posted Friday, November 02, 2012 5:45 PM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 5:52 PM
Points: 960, Visits: 1,921

You should take a look at Gail's article with suggestions to post performance issues.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
It might not affect performance, but you should beware of the dangers of using NOLOCK.

Luis C.
Please don't trust me, test the solutions I give you before using them.
Forum Etiquette: How to post data/code on a forum to get the best help

Post #1380640

Evil Kraig F

Posted Friday, November 02, 2012 5:48 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:44 PM
Points: 5,677, Visits: 6,124

If you take a look in my signature for the link regarding indexes/tuning, we can help you further.

The like is SARGable, no big deal. As is the date. The order by be hurting depending on the # of rows returned, and because you've got two non-equality conditions no index can cover both.

I don't see anything particularly wrong with the query as long as your end users are prepared for bad data from the use of NOLOCK on occassion.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1380641

Bhuvnesh

Posted Monday, November 05, 2012 3:21 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Any index on FiledDate OR FieldDescr column ? if not then create tow separate indexes.

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1380952

« Prev Topic | Next Topic »

Permissions