Forum Replies Created

Viewing 15 posts - 661 through 675 (of 844 total)

  • RE: does choosing indexed table col for where clause helps and does order of table matters?

    Visually this looks bad, see the pet pevee posts on formatting your code.

    update t1

    set a, b, c, d .f

    from t1 a

    join t2 b on a.poleid=b.poleid

    join t3 c on b.t3id...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Bad Meetings or Meeting Badly

    lptech (6/23/2014)


    If many/most of your meetings are conference calls, you'll love this:

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

    My manager's manager told us it was shown at off-site for higher ups as an example of what not...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    Sean Lange (6/18/2014)


    You might be surprised. Often times people in that position will write some beautifully formatted code. Especially if they are shown code with nice formatting from the beginning....

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    Jeff Moden (6/18/2014)


    below86 (6/18/2014)


    andrew gothard (6/18/2014)


    below86 (6/16/2014)


    andrew gothard (6/15/2014)


    Koen Verbeeck (6/14/2014)


    Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    andrew gothard (6/18/2014)


    below86 (6/16/2014)


    andrew gothard (6/15/2014)


    Koen Verbeeck (6/14/2014)


    Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in your Order Taken...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    andrew gothard (6/15/2014)


    Koen Verbeeck (6/14/2014)


    Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in your Order Taken timestamp column in...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    Evil Kraig F (6/13/2014)


    Offhand, even in my warehouses, I never really saw a significant value in storing the date as a four byte int instead of the 8 byte datetime....

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    Sean Lange (6/12/2014)


    below86 (6/12/2014)


    Sean Lange (6/12/2014)


    below86 (6/12/2014)


    I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    Sean Lange (6/12/2014)


    below86 (6/12/2014)


    I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This person also had...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This person also had the idea to...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Can some one confirm that - It is possible to find table size and in that table each row size.

    viresh29 (6/10/2014)


    SELECT

    t.NAME AS TableName,

    s.Name AS SchemaName,

    p.rows AS RowCounts,

    SUM(a.total_pages) * 8 AS TotalSpaceKB,

    ...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    Sean Lange (6/10/2014)


    below86 (6/10/2014)


    Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years ago we were...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Try to focus on the positive

    Each day is one day closer to vacation. 🙂

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • RE: Just curious, what are your SQL pet peeves ?

    How about doing data transformations in the ETL process. I know that's what the 'T' stands for. I can see changing date formats to work in SQL. ...

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

Viewing 15 posts - 661 through 675 (of 844 total)