Forum Replies Created

Viewing 15 posts - 16 through 30 (of 78 total)

  • RE: Federation_filtering_value

    Interesting question. Almost got my Star Trek mixed up with my Star Wars there for a moment - had Empire on the brain! 😛

    I honestly thought it was a...

    October 2, 2015 at 11:58 am

    #1831140

  • RE: Column aliases

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

    I do agree with the = and try to use it, precisely because complex code becomes hard to read when the name is buried...

    September 2, 2015 at 9:05 am

    #1824027

  • RE: Column aliases

    david.gugg (9/2/2015)

    Xavon (9/2/2015)

    Sean Lange (9/2/2015)

    I am guessing that Aaron did NOT convince Steve to use = instead of as. 😉

    I have to say that I disagree with Aaron on this....

    September 2, 2015 at 8:14 am

    #1823998

  • RE: Column aliases

    handkot (9/1/2015)

    I think the same thing

    AS Alias And AS 'Alias'

    also i can write AS [Alias], or write CTE

    so there are only three ways: "=", "AS" and column

    This is where I...

    September 2, 2015 at 7:45 am

    #1823988

  • RE: Global temporary table visibility

    Stewart "Arturius" Campbell (7/31/2015)

    Closing Query 1 effectively disconnects the session.

    Query 2, being a SELECT *, while running, takes an exclusive table lock on the table, thus query 3 will be...

    July 31, 2015 at 7:43 am

    #1816417

  • RE: Max DB Size for SQL Server Express

    mark.hanson 59091 (7/24/2015)

    "Nice easy one today!" - 48% of us disagree 🙂

    Now up to 60%. I'll take that upon myself for not reading the title as well as the...

    July 24, 2015 at 7:40 am

    #1814760

  • RE: Integer lengths (I)

    Stewart "Arturius" Campbell (6/30/2015)

    Nice question, thanks Tom

    Never been fond of the STR() function myself, as i prefer explicit cast/convert

    +1. My thoughts exactly.

    June 30, 2015 at 7:16 am

    #1809106

  • RE: CTE Problem Redux

    Hany Helmy (4/27/2015)

    Great, good to know that, thanx.

    +1

    April 28, 2015 at 7:26 am

    #1793921

  • RE: Using LAG

    Koen Verbeeck (4/17/2015)

    Hugo Kornelis (4/15/2015)

    RLilj33 (4/15/2015)

    On that note, I know that the ORDER BY clause is in general a performance killer. Can anyone speak to / point to a...

    April 17, 2015 at 7:05 am

    #1791662

  • RE: Using LAG

    Stephanie Giovannini (4/15/2015)

    Outer join to a calendar table to ensure that there are no missing months, order by the date, and it should work.

    Good practice when doing reporting. This allows...

    April 15, 2015 at 12:47 pm

    #1791167

  • RE: Using LAG

    Ed Wagner (4/15/2015)

    Nice question. Of all the things we get when we upgrade to 2012 or 2014, LEAD and LAG are the ones I'm looking forward to the most....

    April 15, 2015 at 7:18 am

    #1791086

  • RE: Computed Column

    Wasn't aware of that. Thanks for the question!

    April 14, 2015 at 6:22 am

    #1790764

  • RE: Temp Table Names

    To see a working example of the 116+12 naming in action, see:

    http://blog.sqlauthority.com/2012/05/01/sql-server-maximum-allowable-length-of-characters-for-temp-objects-is-116-guest-post-by-balmukund-lakhani/.

    April 10, 2015 at 7:06 am

    #1790144

  • RE: CTE Syntax

    I use semicolons on terminators for all my statements. Everyone should.

    +1. We instituted a shop standard to apply this practice in all new code and any older code being...

    March 31, 2015 at 8:00 am

    #1787734

  • RE: CTE Syntax

    GilaMonster (3/30/2015)

    .But starting statements with terminators teaches bad habits .For example I had a dev recently who scattered ; randomly until the SQL proc started working .Once it had been...

    March 30, 2015 at 7:09 am

    #1787327

Viewing 15 posts - 16 through 30 (of 78 total)