Forum Replies Created

Viewing 15 posts - 766 through 780 (of 1,111 total)

  • RE: The Office

    I like a mixture of both. My only issue with the remote office is the issue with bigger companies where there is already a gap in the communication due to...

  • RE: NoSQL Complaints

    I really don't understand this article at all.

    NoSQL is such a broad topic that you really can't push out blanket statements about everything under the NoSQL umbrella much like...

  • RE: What is DevOps?

    Course, you could always bridge the gap by coming other rather than relying on a bridge.

    One team. Not One (Ops), Two (Devs) and Three (DevOps) teams.

  • RE: The Command Line is Back

    podmate (11/12/2015)


    chrisn-585491 (11/9/2015)


    Dave,

    Increased license costs of SQL Server will drive more business away from MS than security concerns. If the industry were concerned about security, we would have abandon C...

  • RE: The Command Line is Back

    I live in command line for my Linux machines and Python. I would love it for everything Windows too.

  • RE: What Kind of DBA Are You?

    Gary Varga (12/2/2015)


    Disappointingly few non-DBAs then. I can't be the only non-SQL Server bod here. Can I? No. I am sure that I read in the comments above that someone...

  • RE: writing queries that easily readable

    GilaMonster (12/2/2015)


    xsevensinzx (12/2/2015)


    But, you're really splitting hairs here. You're confusing badly written code with human error. Not correctly terminating a statement can happen to anyone just as it does in...

  • RE: writing queries that easily readable

    GilaMonster (12/2/2015)


    We can compensate for badly written code with more badly written code. Excellent plan.

    Correctly terminate all statements with a semicolon (they're statement terminators). The end.

    If someone did not...

  • RE: writing queries that easily readable

    The thing is, not everyone ends with a semicolon. So, when you have things like:

    WITH Test AS

    (

    SELECT TOP 1

    *

    FROM [DW].[dbo].[SomeTable]

    )

    SELECT * FROM Test;

    SELECT TOP 1

    *

    FROM [DW].[dbo].[SomeTable] -- Missing semicolon

    WITH...

  • RE: writing queries that easily readable

    GilaMonster (12/2/2015)


    xsevensinzx (12/2/2015)


    Don't forget to put it at the beginning of each CTE too.

    !Gah !No

    .A semicolon is a statement *terminator* .It is not something that gets placed at the beginning...

  • RE: writing queries that easily readable

    Can't stress semi-colons enough. I didn't have it in my sample, but it should be at the end of each statement. Don't forget to put it at the beginning of...

  • RE: Rethinking Hiring

    I feel that so many people put too much emphasis on knowing syntax than the people themselves. For DBA's, it becomes a knowledge capacity assessment from the start. Do you...

  • RE: writing queries that easily readable

    polkadot (12/1/2015)


    xsevensixzx, I find brackets looks nice but is hard for me to do with proper typing technique (hard on pinky) and so many extra characters. But looks nice.

    Yeppers,...

  • RE: writing queries that easily readable

    GilaMonster (12/1/2015)


    polkadot (12/1/2015)


    Seriously, does any team really have discussions about these things?

    Yes, good teams do, because they know that making time to establish standards and practices saves time later on.

    If...

  • RE: writing queries that easily readable

    Jeff Moden (12/1/2015)


    xsevensinzx (12/1/2015)


    This is what I like that everyone despises.

    You're right ... I don't care for all the bracketing BUT, when it's "Squared Up" like you have it,...

Viewing 15 posts - 766 through 780 (of 1,111 total)