Forum Replies Created

Viewing 15 posts - 961 through 975 (of 1,229 total)

  • RE: Looking for a MSSQL DBA/Developer job in San Francisco/Bay Area

    carlos 5652 (4/15/2011)

    Are you still in the job market?

    With those credentials my friend he will have been snapped up in 21 minutes, not months 😀

    April 15, 2011 at 12:39 pm

    #1312303

  • RE: Question about "coalesce"

    I'd join table 2 twice, once on ID1 on both sides, and again on ID2 on both sides, then test for match in the output. Often, but not always, this...

    April 15, 2011 at 12:36 pm

    #1312302

  • RE: Are the posted questions getting worse?

    Craig Farrell (4/14/2011)

    Alright, there's any number of things to take my article apart for, half of it's an opinion... but there's vs. there are?

    I'm going to assume I'm just too...

    April 14, 2011 at 6:14 am

    #1311535

  • RE: The Job Posting - Do I really have to be the SQL God?

    Thanks Craig. This really opened my eyes to the BS in some of the posts I've been thinking about the last few days. Well written, great content. Job done.

    Should you...

    April 14, 2011 at 6:06 am

    #1311527

  • RE: Who's afraid of Gila Monsters?

    mtillman-921105 (4/13/2011)

    ChrisM@home (4/13/2011)

    mtillman-921105 (4/13/2011)

    mtillman-921105 (4/13/2011)

    Gila Monsters - the critters, not Gail, have a strange defense. Rather than a venom per se, their mouths are so full of bacteria and...

    April 14, 2011 at 12:03 am

    #1311429

  • RE: Question about "coalesce"

    ichiyo85 (4/13/2011)

    ChrisM@home: Good question! Would you have any suggestions? That's actually one that I don't know what to do...

    SQL Server - and the community who use it - are familiar...

    April 13, 2011 at 11:55 pm

    #1311428

  • RE: Who's afraid of Gila Monsters?

    mtillman-921105 (4/13/2011)

    mtillman-921105 (4/13/2011)

    Gila Monsters - the critters, not Gail, have a strange defense. Rather than a venom per se, their mouths are so full of bacteria and basically nasty...

    April 13, 2011 at 2:56 pm

    #1311345

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    Grant Fritchey (4/13/2011)

    ...

    You're still seeing two operations, right? If it's showing two operations, at least based on what I've learned, it's performing two operations...

    I'll live with that. Thanks Grant.

    April 13, 2011 at 2:02 pm

    #1311304

  • RE: Question about "coalesce"

    ichiyo85 (4/12/2011)

    "Unassigned" is just a name (nvarchar) that I gave to those cells that don't have values because I didn't want to leave them as NULL. Would it create any...

    April 13, 2011 at 2:00 pm

    #1311299

  • RE: Who's afraid of Gila Monsters?

    Grant Fritchey (4/13/2011)

    ChrisM@home (4/13/2011)

    CirquedeSQLeil (4/13/2011)

    Grant Fritchey (4/13/2011)

    Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.

    *cough*

    That should help.

    Don't you have to...

    April 13, 2011 at 1:53 pm

    #1311294

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    Grant Fritchey (4/13/2011)

    ChrisM@home (4/13/2011)

    varun.dubey29 (4/13/2011)

    That is what the expected behavior I am expecting but in the execution plan it show that Distinct block returns fewer records than the one...

    April 13, 2011 at 11:59 am

    #1311224

  • RE: Who's afraid of Gila Monsters?

    CirquedeSQLeil (4/13/2011)

    Grant Fritchey (4/13/2011)

    Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.

    *cough*

    That should help.

    April 13, 2011 at 11:22 am

    #1311201

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    varun.dubey29 (4/13/2011)

    That is what the expected behavior I am expecting but in the execution plan it show that Distinct block returns fewer records than the one in the table(it...

    April 13, 2011 at 4:17 am

    #1310907

  • RE: Who's afraid of Gila Monsters?

    If they are provoked into an attack, then they bite swiftly and hard, chewing the venom into the punctured, ravaged flesh of their tormentor, releasing only when the shocked victim...

    April 13, 2011 at 3:54 am

    #1310893

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    varun.dubey29 (4/13/2011)

    Hi All,

    I am using DISTINCT and TOP in same query as :

    SELECT DISTINCT TOP 100 ValidationDate FROM ValidatorDetails.

    ValidatorDetails table contains 2000 records.

    While looking at the execution plan, I found...

    April 13, 2011 at 3:42 am

    #1310889

Viewing 15 posts - 961 through 975 (of 1,229 total)