Forum Replies Created

Viewing 15 posts - 16 through 30 (of 31 total)

  • RE: Alternate to context based search

    GilaMonster (4/10/2012)That's a very good way to really slow a database down...

    Does the app absolutely call for autocomplete and can the possible values not be cached in the application?

    That's...

  • RE: Alternate to context based search

    The data is being cached in client end, but for first time login and if the cache is cleared, it will be problem.

    I think for auto-complete to work effectively, the...

  • RE: Alternate to context based search

    This proc will be called for auto-complete feature and while typing each character it will be called. The context will be set based on a dropdown value. Initially I thought...

  • RE: T-SQL Performance 1

    Good question, though I answered wrong!:(

  • RE: MERGE

    Hugo Kornelis (2/15/2012)

    I got it right, for all the wrong reasons.

    The script will not run, regardless of triggers, for two reasons:

    1. The MERGE statements must be terminated with a semicolon....

  • RE: MERGE

    Learnt something new, though I answered wrongly...

  • RE: Read Uncommitted, locks, and transactions

    Nice one

  • RE: HASHBYTES

    Seems the database would have two columns. One for Salt and one for HashedPassword. Then, you have your application do the hashing with the RANDOM salt. You...

  • RE: HASHBYTES

    Raghavendra Mudugal (2/10/2012)


    cengland0 (2/10/2012)


    Raghavendra Mudugal (2/10/2012)


    cengland0 (2/10/2012)


    Steve Jones - SSC Editor (2/9/2012)


    SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname)

    FROM Employees

    In this case, without access to the code, it becomes...

  • RE: Indexed Views

    sknox (2/10/2012)


    BTW, now that I am posting anyway - there is one word in the explanation is wrong: "The query optimizer in lower editions will only consider the indexed view...

  • RE: Indexed Views

    sknox (2/10/2012)


    Hugo Kornelis (2/10/2012)


    I hate questions where I have to second-guess the author. Did the author mean that the optimizer would choose to use the indexed view automatically? Or did...

  • RE: Indexed Views

    Thanks for the question and like the answer options very much 🙂

  • RE: HASHBYTES


    Add the sale string

    Good Question, but "Add the sale string" seems to be tricky... 🙂

  • RE: Complex joins

    It took around 2 hours for me to solve it and finally got it right 🙂

    Ofcourse, learnt something new

  • RE: Using SP_

    Great question... Is that mean when any object with SP_ prefix used in combination with if (as in this case) would be searched in the current DB first and then...

Viewing 15 posts - 16 through 30 (of 31 total)