Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 3,348 total)

  • RE: Sparse Columns

    Steve Jones - Editor (7/17/2008)

    However, I see the point, and I have corrected the URL as well as awarded points back.

    Thanks, Steve! 😀

    July 17, 2008 at 12:46 pm

    #844605

  • RE: Sparse Columns

    The documentation that this QotD is based on (thanks for the link, Simon - I did indeed get a resource not found error) is incorrect and misleading. I have just...

    July 17, 2008 at 1:20 am

    #844183

  • RE: A Hex on Your Database

    yavvie (7/15/2008)

    the string 0x73656C656374206E616D652066726F6D207379732E6461746162617365733B actually has some meaning? I quite don't get why a string like this is used in the question.

    Or is it just any string that generates an...

    July 15, 2008 at 7:29 am

    #843085

  • RE: Cursor optimization

    SveG (7/11/2008)

    May be I overlooked something.:unsure:

    Hi SveG,

    I think you did.

    That particular quote refers to "the fast forward-only cursor with autofetch enabled", which is a specific kind of client-side cursor (that...

    July 13, 2008 at 1:47 pm

    #842130

  • RE: Cursor optimization

    davidthegray (7/9/2008)

    Ok, Hugo, I followed your suggestion.

    If anybody think this feature would be useful, you can vote here: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=355519

    Thanks, David. You have my vote.

    (BTW, did you remember to vote...

    July 9, 2008 at 8:14 am

    #840182

  • RE: Cursor optimization

    davidthegray (7/9/2008)

    I'm temped to file the suggestion to MS as you indicate, but I think this is such a basic suggestion, one of the first things that come to mind...

    July 9, 2008 at 2:48 am

    #839934

  • RE: Cursor optimization

    george sibbald (7/8/2008)

    One question - on a production server surely you cannot know how much cache is available to a query and anyway it is a variable, so whether static...

    July 9, 2008 at 2:33 am

    #839927

  • RE: Cursor optimization

    Craig (7/9/2008)

    .... in the end what was the 'right' anwer, given the original question?

    Hi Craig,

    The 'right' answer would have been "it depends". FAST_FORWARD for tables that are too large to...

    July 9, 2008 at 2:19 am

    #839924

  • RE: Cursor optimization

    Jeffrey Williams (7/8/2008)

    Anyways, I really can't test this myself but I am wondering whether or not using INSENSITIVE is any different than using STATIC? It appears to me that...

    July 8, 2008 at 4:16 pm

    #839811

  • RE: Cursor optimization

    GSquared (7/8/2008)

    If I ever run into a server that can't fit all the database names into RAM, I think I'll have bigger worries than a few seconds plus or minus...

    July 8, 2008 at 11:08 am

    #839662

  • RE: Cursor optimization

    Yelena Varshal (7/8/2008)

    What about the other BOL article that says: "Dynamic cursors open faster than static or keyset-driven cursors" . All other recommendations in this article are to use the...

    July 8, 2008 at 11:05 am

    #839660

  • RE: Cursor optimization

    bitbucket (7/8/2008)

    Considering the above I would still say that BOL statement concerning Fast-Forward should have been an acceptable answer or the question should have had as a choice "It Depends"

    Hi...

    July 8, 2008 at 10:46 am

    #839644

  • RE: Cursor optimization

    Christian Buettner (7/8/2008)

    Before my certification, I only knew the tip of the iceberg and still I am sure don't know every aspect of cursors.

    Hi Christian,

    I'd say that this is actually...

    July 8, 2008 at 10:42 am

    #839641

  • RE: Cursor optimization

    JohnG (7/8/2008)

    Try adding a few TEXT (VARCHAR(MAX)) and/or IMAGE (VARBINARY(MAX)) columns along with a bunch of joins and see what happens. I'd also be curious to see the results...

    July 8, 2008 at 10:37 am

    #839636

  • RE: Cursor optimization

    davidthegray (7/8/2008)

    Hugo, yes sure, I'm well aware about the risks of SQL injection. I always validate the input coming from the public web site, and I'm used to use parameters...

    July 8, 2008 at 10:34 am

    #839632

Viewing 15 posts - 3,136 through 3,150 (of 3,348 total)