Forum Replies Created

Viewing 15 posts - 4,066 through 4,080 (of 6,041 total)

  • RE: The Worst Comments

    The absolute worst type of comment is when a developer encloses a pre-existing block of code within /* */ brackets without an additional comment stating why, when, and who.

    Another type...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: NOLOCK across linked server with join

    Hey JeeTee,

    So which of these ponies runs fastest?

    I'm placing my money on the INSERT #S EXEC() AT method I described earlier.

    :satisfied:

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Design Investment

    Xavon (3/12/2015)


    One thing I would like to add to this:

    the designer is ignorant, or lazy, or maybe doesn't pay attention because it's not part of their job

    namely:

    "or is saddled with...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Can not connect to SQL Server Instance

    pbyrum (3/11/2015)


    I did every mentioned in this post, but nothing worked.

    http://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

    You can successfully ping remote server name from client?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Design Investment

    GoofyGuy (3/11/2015)


    I'm actually beginning to question the relevence of in-house database engineers. It's not that we can't make a real difference, it's just that circumstances beyond our control marginalize the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Can not connect to SQL Server Instance

    pbyrum (3/11/2015)


    I have SQL Server 2012 installed and when I run this command:

    sc query mssql$MSSQLSERVER

    I get this error:

    [SC] EnumQueryServicesStatus:OpenService FAILED 1060:

    The specified service does not exist as an installed...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Design Investment

    ddudley-847177 (3/11/2015)


    This is why in the old days the conventional wisdom was that the more experienced did more design while the less experienced did the maintenance. It is now reversed....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Express Choice

    jonesboy21 (3/11/2015)


    I could write an article about it, not sure how much information I could give out though due to confidentiality agreements. We did have large SQL Server enterprise servers...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Limitations of MongoDb

    venoym (3/11/2015)


    I think this describes some of the disconnect between the only NoSQL camp and the only SQL camp.

    **beware some language**

    https://www.youtube.com/watch?v=Nu1UQblRQdM

    Wow, that's so geeky. But it is funny and true....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Express Choice

    jonesboy21 (3/10/2015)


    Two instances in every store running on a physical server. Cloud wasn't an option at the time. No extra development costs.

    I'm guessing this retail giant does have SQL Server...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: NOLOCK across linked server with join

    I'm guessing that Symbols is essentially a reference table containing one row for each company or index fund traded on a stock exchange. If that's the case, then this was...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: NOLOCK across linked server with join

    JeeTee (3/9/2015)


    Hi All,

    I have two servers (lets call them sA and sB) connected from sA -> sB via a linked server (i.e. sA pulls data across from sB).

    I'm building a...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Size of Data Roadblocks

    xsevensinzx (3/10/2015)


    Koen Verbeeck (3/10/2015)


    Eric M Russell (3/10/2015)


    Did I understand you right that the query took 20 days?

    A medium powered server should be able to perform a full table scan of...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Size of Data Roadblocks

    xsevensinzx (3/10/2015)


    ScottPletcher (3/10/2015)


    If the table is already clustered on time (hooray!), then reading a week's worth of data shouldn't take that long.

    We need to review two things (at least).

    First, the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Limitations of MongoDb

    Charles Kincaid (3/10/2015)


    Eric M Russell (3/10/2015)


    In other words, if you update a MongoDB document, perhaps something like adding additional office visitation records to a patient's chart, then the change of...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 4,066 through 4,080 (of 6,041 total)