Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 5,590 total)

  • RE: Loop thru a filed with ; separated values

    Whoops, Lutz beat me to it, and furthermore I didn't read everything correctly. So, I've removed what I did.

    November 12, 2010 at 10:37 am

    #1250152

  • RE: Are the posted questions getting worse?

    GSquared (11/12/2010)

    Dave Ballantyne (11/12/2010)

    WayneS (11/12/2010)

    I assume you mean with the OPTION (RECOMPILE) hint? Sure did.

    Doesnt this just completely negate any advantage of table vars though ? .

    The main...

    November 12, 2010 at 10:07 am

    #1250139

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (11/12/2010)

    Paul, thanks for the reply. I understand now.

    Okay, that's 21 now! :w00t:

    November 12, 2010 at 8:37 am

    #1250066

  • RE: Are the posted questions getting worse?

    GilaMonster (11/12/2010)

    WayneS (11/11/2010)

    Everyone thought that table variables were 1. memory-only, 2. did no logging, and 3. had no indexes. Now, about 20 more people know better.

    And I thought the 'no...

    November 12, 2010 at 8:36 am

    #1250063

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/11/2010)

    WayneS (11/11/2010)

    WayneS (11/11/2010)

    Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all...

    November 12, 2010 at 8:31 am

    #1250059

  • RE: Are the posted questions getting worse?

    Paul White NZ (11/11/2010)

    WayneS (11/11/2010)

    I started the presentation asking questions. Everyone thought that table variables were 1. memory-only, 2. did no logging, and 3. had no indexes. Now, about 20...

    November 12, 2010 at 8:28 am

    #1250057

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (11/11/2010)

    Congratulations, Wayne. Applause! Thunderous applause

    Let me ask what logging takes place with table variables, since they are not affected by rollbacks.

    They are not affected...

    November 12, 2010 at 8:27 am

    #1250055

  • RE: Setting SQL Server Default Locations

    Okay, I've done some digging around.

    My system: SQL 2008 named instance (no default instance). Changed DefaultData set to "C:\SQLData". Verified that it was set by viewing in the "Running...

    November 12, 2010 at 8:22 am

    #1250049

  • RE: Are the posted questions getting worse?

    WayneS (11/11/2010)

    Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all the other...

    November 11, 2010 at 9:39 pm

    #1249816

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/11/2010)

    I have a few articles that I am finishing up currently. Is there anybody that would like to give them a look-over before I submit them?

    Sure, fire any...

    November 11, 2010 at 9:33 pm

    #1249812

  • RE: Week Part

    Well done Jeff. I turn the podium back over to the master.:-D

    November 11, 2010 at 9:28 pm

    #1249809

  • RE: Substring with Charindex or Patindex and case statement

    Well, as I mentioned, "YACHT AUSTRALIA [III]" is finding a match on "US". This is because you are using this bit of code: ...

    November 11, 2010 at 9:23 pm

    #1249805

  • RE: Finding records clustered by date

    Aaron,

    It does look a bit complicated, but it looks efficient also. Thanks for the feedback!

    November 11, 2010 at 9:18 pm

    #1249804

  • RE: CTE and Union All

    Thanks.

    Out of curiosity, what does dbo.dbFunc_Determine_CurRptMth_LoadID do? Where you are using it, it is obviously a scalar function instead of a table-valued function. Those would be a lot faster.

    November 11, 2010 at 9:14 pm

    #1249801

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (11/11/2010)

    GilaMonster (11/11/2010)

    Nor here any longer. Guess the results are no longer 'latest'

    Just a list of several people retweeting and/or agreeing with Grant's initial tweet

    From @SQLintheWild : Yea...

    November 11, 2010 at 9:09 pm

    #1249800

Viewing 15 posts - 2,446 through 2,460 (of 5,590 total)