Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 7,636 total)

  • RE: Are the posted questions getting worse?

    Paul White (10/4/2009)


    RBarryYoung (10/3/2009)


    Ah yes, I'll never forget my first time. That poignant, bittersweet moment when your code first gets promoted ahead of you ... 😀

    That made me...

  • RE: Comparing Table Variables with Temporary Tables

    Elliott W (10/4/2009)


    RBarryYoung (10/4/2009)


    Elliott W (10/4/2009)


    ...

    As the table grows is less obvious which is the better performer..

    No, as the table grows, it becomes clearer and clearer that temporary tables outperform...

  • RE: CRL Assembly after reboot

    Matt Whitfield (10/4/2009)


    When you create an assembly with CREATE ASSEMBLY, it's actually stored internally, and loaded from there from that point on. The DLL on disk doesn't have any bearing...

  • RE: Comparing Table Variables with Temporary Tables

    Elliott W (10/4/2009)


    ...

    As the table grows is less obvious which is the better performer..

    No, as the table grows, it becomes clearer and clearer that temporary tables outperform table variables. ...

  • RE: Comparing Table Variables with Temporary Tables

    Elliott W (10/3/2009)


    Paul White (10/3/2009)


    Elliott W (9/23/2009)


    As far as logical reads of a table variable.. Keep in mind that if they are not too big they will probably reside...

  • RE: CRL Assembly after reboot

    Dale Burrell (10/3/2009)


    @RBarryYoung - thanks for that, does that mean I need to leave the physical assemblies in the same place I originally loaded them from? ( just slapped them...

  • RE: Are the posted questions getting worse?

    Paul White (10/3/2009)


    Roy Ernest (10/2/2009)


    The water cooler has been too quiet for my liking. I am getting withdrawal symptoms. What is happening? Where is everyone? 🙁

    Working stupid hours on a...

  • RE: CRL Assembly after reboot

    Yes, the configuration information to load the assembly is saved in the system "tables".

    (Edit: NOTE, actually the entire assembly is also saved in the database itself., see below).

  • RE: The Dynamic Tally or Numbers Table

    Lynn Pettis (10/2/2009)


    Cool. It was released in 1962 and ran initially on the PDP-1. Was used by the FE's when setting up the PDP-1 as a final test...

  • RE: The Dynamic Tally or Numbers Table

    Lynn Pettis (10/2/2009)


    RBarryYoung (10/2/2009)


    Luke L (10/2/2009)


    Jerky video? Silly young'ins... we had similar games, 'cept when you did that type of stuff you might just maybe have seen some ascii...

  • RE: The Dynamic Tally or Numbers Table

    Luke L (10/2/2009)


    Matt Whitfield (10/2/2009)


    When I was at school there used to be a game called 'Betrayal at Krondor' - where you would meet people as you travelled around. They...

  • RE: The Dynamic Tally or Numbers Table

    Lynn Pettis (10/2/2009)


    On my dev system master.sys.all_parameters returns 6776 rows. In the context of the particular database I tested it, sys.all_parameters, returned 6841.

    That's why I try to stick the...

  • RE: Run EXE from Stored Procedure

    parth83.rawal (10/2/2009)


    My EXE is in C Drive only, and it is running fine, if i run from the command prompt. and my server and exe both are on server only....

  • RE: An Introduction To Linked Servers

    forerolui (10/2/2009)


    I have created and test an UDl file to connect to AS/400. After creating an testing the connection the result of the connection string is:

    Provider=IBMDA400.DataSource.1;Persist Security Info=False;User ID=SQLODBC1;Data Source=10.254.xxx.yyy

    I...

  • RE: The Dynamic Tally or Numbers Table

    RBarryYoung (10/2/2009)


    peter-757102 (10/2/2009)


    Jeff Moden (10/2/2009)


    That's why I shifted to All_Columns for future code. Rumor has it that syscolumns is going away and Master.sys.All_Columns always has at least 4k rows...

Viewing 15 posts - 1,471 through 1,485 (of 7,636 total)