Forum Replies Created

Viewing 15 posts - 18,811 through 18,825 (of 26,484 total)

  • RE: While Loop

    You didn't provide the error message you are getting, but I can see the problem. You can't use variables in the SELECT INTO the way you are attempting. ...

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/18/2009)


    Hey Lynn, Why not write about resource governor? There is a lot to write and it is a pretty interesting topic too.

    Good idea, just one problem. I...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/18/2009)


    Lynn Pettis (9/18/2009)


    Grant Fritchey (9/18/2009)


    Lynn Pettis (9/18/2009)


    Grant Fritchey (9/18/2009)


    Lynn Pettis (9/17/2009)


    Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here...

  • RE: Expected salary for DBA with 3 years exp.

    admin-783635 (9/18/2009)


    5.5 Lakh = 550000 INR = 11,423.49999 USD (Lakh = 100,000)

    Next question, annual or monthly salary?

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/18/2009)


    Anyone else want to add anything here?

    It always amazes me how quickly others will join a topic when asked. This site is just awesome! 🙂

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/18/2009)


    Lynn Pettis (9/18/2009)


    Grant Fritchey (9/18/2009)


    Lynn Pettis (9/17/2009)


    Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well....

  • RE: Qry Performance

    Jeff Moden (9/18/2009)


    If nothing else, the NOT LIKE will likely force a scan.

    Building on this, empid isn't even in the index, so sounds like a good possibility for a table...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/18/2009)


    Lynn Pettis (9/17/2009)


    Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep an eye...

  • RE: Are the posted questions getting worse?

    Anyone else want to add anything here?

  • RE: Qry Performance

    That may be what you are looking for, but don't restrict yourself to just that. There may be other things that maybe better than an indexed view. Leave...

  • RE: Are the posted questions getting worse?

    Jack Corbett (9/18/2009)


    Lynn,

    I did read your latest article and it was good. I usually only comment on the ones that have what I believe to be a bad practice...

  • RE: Are the posted questions getting worse?

    Paul White (9/18/2009)


    ¿???p??? o? p??? si?? pui? lli? ????dsi??? u?????ou ??? ?o?? ?ldo?d ?i ??puo? i

    Actually, once I saw it here on my pc, no problem reading it at all....

  • RE: Qry Performance

    Tara, please read the second article I have linked in my signature problem regarding performance problems. Follow the instructions in that article regarding what you should post to get...

  • RE: Are the posted questions getting worse?

    Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep an eye out as I am...

  • RE: Are the posted questions getting worse?

    Well, he did apologize, but I'm not sure if there was enough grovelling. 😛

Viewing 15 posts - 18,811 through 18,825 (of 26,484 total)