Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 6,041 total)

  • RE: Online T-SQL Scripts and Copyright

    Steve Jones - SSC Editor (11/30/2016)


    Eric M Russell (11/30/2016)


    I totally don't understand why someone would publish sample programming code on the public web and then expect other folks not to...

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

  • RE: is there a way to call a sproc concurrently using t-sql?

    Years ago, Adam Machanic developed a load testing tool for running either batches of T-SQL statements or stored procedure calls.

    http://sqlblog.com/blogs/adam_machanic/archive/2016/01/04/sqlquerystress-the-source-code.aspx

    https://www.brentozar.com/archive/2015/05/how-to-fake-load-tests-with-sqlquerystress/

    Also, you can leverage the WAITFOR command to execute a T-SQL...

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

  • RE: Online T-SQL Scripts and Copyright

    I totally don't understand why someone would publish sample programming code on the public web and then expect other folks not to use it or even expect folks to ask...

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

  • RE: Happy Thanksgiving 2016

    mjh 45389 (11/30/2016)


    Eric M Russell (11/30/2016)


    If we eliminate cows as a source for green-house gas emissions then next up will be human produced gas emissions... particularly that of west coast...

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

  • RE: What is Normal?

    First, not everyone has a SSN, and another problem is that it's not verifiable. How do I know that John Smith's SSN is 111-22-3333?

    If you identify someone by their email...

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

  • RE: The Pressure to Compromise Ethics

    David.Poole (11/30/2016)


    What I'd like to see is a framework to support whistle blowers.

    By all means insist on evidence but whistle blowers need protection. Most companies have a whistle blower...

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

  • RE: Happy Thanksgiving 2016

    If we eliminate cows as a source for green-house gas emissions then next up will be human produced gas emissions... particularly that of west coast vegetarians.

    Will Vegetarian Humans...

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

  • RE: Change table from vertical to horizontal

    Whatever user requested to see the data pivoted into this cross-tab format should do it themselves within the reporting tool.

    Create a Matrix (Report Builder and SSRS)

    https://msdn.microsoft.com/en-us/library/dd207149.aspx

    Office Excel 2010 Tutorial: Pivot...

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

  • RE: A scenario where SQL Server doesn't seem to help

    What you've described is a terrible application for a traditional Row-Store / B-tree indexed table, but a ColumnStore index can help mitigate this type of dynamic access pattern. If this...

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

  • RE: Clustered Index on datetimeoffset?

    I often use a datetime stamp as the leading column in a clustered and/or primary key. Many types of entities are naturally unique within the context of time, and also...

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

  • RE: The Pressure to Compromise Ethics

    Brad Allison (11/30/2016)


    This topic is very timely and interesting as just yesterday I heard that the Breitbart company now wants to capitalize on working with data within the White House...

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

  • RE: Hire the Right People

    David.Poole (11/28/2016)


    What puzzles me is that developers aren't much better at data modelling. Surely you have to be pretty good to come up with a decent object model in...

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

  • RE: Happy Thanksgiving 2016

    I'm thinking that Thanksgiving is a British holiday inherited by the US, since Jamestown and Plymouth were British colonies at the time the first Thanksgiving was celebrated.

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

  • RE: What is Normal?

    One day we'll have a device that can scan a person's DNA and produce a unique and repeatable 16 byte hash code. No name, social security number, date of birth,...

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

  • RE: Hire the Right People

    web designers building databases...

    interns defining business requirements...

    database administrators interfacing with clients...

    executive management playing golf ...

    everybody supervising themselves...

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

Viewing 15 posts - 1,996 through 2,010 (of 6,041 total)