Forum Replies Created

Viewing 15 posts - 751 through 765 (of 1,473 total)

  • RE: Totally confused by query behavior and plan

    This may not be what was happening here, but I had a somewhat similar issue on Friday using nested derived tables. It made me ask a question that I've...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    February 7, 2009 at 10:11 am

    #940007

  • RE: Audit Trail - Handle image fields

    I don't know if changing the structure of this trigger is a consideration... but you really don't want to use loops and dynamic sql in triggers. It will likely...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    February 7, 2009 at 9:26 am

    #939998

  • RE: Exponential Moving Average Challenge

    First, let me say, good post. Sample data, table definitions,expected results and a clear description of the problem.

    This should work for you. Please note that the clustered index...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 30, 2009 at 10:04 pm

    #935949

  • RE: Row Count Spool/Lazy spool

    r.hensbergen (1/29/2009)

    souLTower (1/29/2009)

    Aren't left joins and NOT EXIST statements more efficient than NOT IN statements? I don't know if I made that up or read it somewhere. I...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 29, 2009 at 10:25 pm

    #935286

  • RE: Determining whether a Stored Procedure returns a resultset

    Oops, sorry for the double post, my internet freaked out last night. To be honest, I'm not sure how you'd use FMTONLY to do it, but I do...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 29, 2009 at 10:06 pm

    #935280

  • RE: Problem related to deletion of data from table using like key word

    Thanks for the feedback sar_kan25. Glad we could help.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 29, 2009 at 9:36 pm

    #935273

  • RE: issues with datetime to integer value

    I actually read a thread the other day where Jeff was comparing the -.5 as int method with the other 3 main methods, and he seemed to be in favor...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 29, 2009 at 9:42 am

    #934818

  • RE: Poor Performing Query When running a Report

    Yeah, I'd say those functions are the vast majority of your problem.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 29, 2009 at 8:39 am

    #934744

  • RE: Poor Performing Query When running a Report

    From a quick first glance, yes.

    Function calls in your where clause are usually a performance killer (do they do data access? Post them if possible.)

    Convert'ing datetimes to varchars will...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 29, 2009 at 8:07 am

    #934706

  • RE: Trouble Creating View based on Max Values and Group By

    The following is probably wrong, because I don't know what your data or table structure actually looks like, and I really don't think you gave us enough information to accurately...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 28, 2009 at 10:10 pm

    #934389

  • RE: lock

    Not sure if I'm splitting hairs here, but you don't have a space after the DROP TABLE.

    If object_id(@lv_tablename) IS NOT NULL

    Begin

    Execute ('Drop table' + @lv_tablename)

    END

    That satement will render as...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 28, 2009 at 9:33 pm

    #934380

  • RE: Problem related to deletion of data from table using like key word

    Get rid of your extra quotes.

    delete FROM tableName where path like '%'+@path +'%'

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 28, 2009 at 9:13 pm

    #934377

  • RE: Determining whether a Stored Procedure returns a resultset

    SET FMTONLY ON

    http://technet.microsoft.com/en-us/library/ms173839.aspx

    Ran across this one as one of our client side apps was running it on its own and it drove me NUTS until I managed to catch it...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 28, 2009 at 9:09 pm

    #934375

  • RE: Trying to rewrite RBAR Function

    I actually heard about persisted computed the other day and haven't had a chance to look into exactly how one sets them up yet. I'd be interested to see...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 27, 2009 at 9:52 pm

    #933619

  • RE: Get 2nd Occurence

    Here's another way to do it. (Not saying it's any better) If you're doing this on a whole column, you're likely going to want to look...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    January 27, 2009 at 6:44 pm

    #933581

Viewing 15 posts - 751 through 765 (of 1,473 total)