Forum Replies Created

Viewing 15 posts - 4,156 through 4,170 (of 6,041 total)

  • RE: Closer to the Heart

    I would love a job where I could spend half my time behind the computer and the other half outdoors in the field, traveling and getting my hands dirty. Perhaps...

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

  • RE: Closer to the Heart

    david.gugg (2/13/2015)


    Being an avid fisherman, I've always thought there would be great value in a site where you could share fishing results and in return, receive other people's results. ...

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

  • RE: Super long running queries (bad users)

    It sounds like in your case the users are actually working for external clients, so unfortunately you're in a position where both you and your managers have to tread lightly....

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

  • RE: Closer to the Heart

    Any job that involves ingesting data feeds or managing databases for a number of different external clients can be a pain in the asscii. When an internal user submits a...

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

  • RE: Starting a New Job

    I'm sure our current employers probably benefit from scripts we may have written in our previous jobs. When a company hires a senior level developer or DBA, those of us...

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

  • RE: Starting a New Job

    Gary Varga (2/13/2015)


    Brian J. Parker (2/12/2015)


    Steve Jones - SSC Editor (2/12/2015)


    Brian J. Parker (2/12/2015)


    Gosh, I'd be surprised if any DBA or database developer did NOT have a folder full of...

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

  • RE: Starting a New Job

    Brian J. Parker (2/12/2015)


    Steve Jones - SSC Editor (2/12/2015)


    Brian J. Parker (2/12/2015)


    Gosh, I'd be surprised if any DBA or database developer did NOT have a folder full of T-SQL scripts...

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

  • RE: Super long running queries (bad users)

    Jeff Moden (2/12/2015)


    Killing even the most ridiculous users sessions is a really good way to need an updated resume. I know it takes a whole lot longer to do...

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

  • RE: Super long running queries (bad users)

    jchapman (2/12/2015)


    Clever idea... I had not thought of that. The big question would be if that change kicked in immediately (changing the behavior of existing open connections, and possibly...

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

  • RE: Super long running queries (bad users)

    jchapman (2/12/2015)


    Ah... an idealist in the group. 😉

    Well, it's good to hold on to our ideals... but we must also carry a big stick. First try to educate and...

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

  • RE: Super long running queries (bad users)

    It's odd that the developers would be writing SQL involving complex sub-queries in a data warehouse. Perhaps it's not a star-schema or they're not familar with the data model.If you...

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

  • RE: Starting a New Job

    Assuming there is only one DBA, and you're now it (perhaps the last one left unexpectedly), then taking an inventory of your IT environment is important, but perhaps not the...

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

  • RE: Will order of fields create any performance issues?

    Changing the ordinal position of columns in the ORDER BY clause can cause a change in the execution plan. If the ordinal position matches an index, then it can leverage...

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

  • RE: Will order of fields create any performance issues?

    The order of columns in the insert does not matter to the optimizer or engine. Also the order of columns in the SELECT, WHERE, and JOIN do not matter.

    First,...

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

  • RE: Ship Safe...Ship Often

    If by deploying often we mean more iterative and incremental deployments, then that can also result in safer deployments, because changes within each release are fewer and more manageable. It's...

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

Viewing 15 posts - 4,156 through 4,170 (of 6,041 total)