Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 7,483 total)

  • RE: Tally Tables

    Rune Bivrin (9/3/2013)

    L' Eomot Inversé (9/3/2013)

    Rune Bivrin (9/3/2013)

    Just look at the execution plan and tell me if there is no difference.

    Or even try this, where NEWID() is completely eliminated from...

    Tom

    September 3, 2013 at 5:32 am

    #1646978

  • RE: Tally Tables

    Rune Bivrin (9/3/2013)

    Just look at the execution plan and tell me if there is no difference.

    Or even try this, where NEWID() is completely eliminated from the second query.

    -- 1

    SELECT ROW_NUMBER()...

    Tom

    September 3, 2013 at 3:44 am

    #1646939

  • RE: Tally Tables

    Nice clear and easy question (assuming the last option "no difference" means "no difference in what they the language specification says they return" - if it means what it actually...

    Tom

    September 3, 2013 at 3:37 am

    #1646934

  • RE: Question of the Day for 13 Oct 2004

    The most common cause of this error, in my experience, is that someone has failed to mark a trigger "not for replication" that needed to be so marked. The...

    Tom

    September 2, 2013 at 3:47 pm

    #1646811

  • RE: Help

    GilaMonster (8/31/2013)

    Snigdha Vartak (8/30/2013)

    Certification will definitely get you more money

    Not necessarily.

    As of last night, there are now 0 certifications that one can take that I will immediately respect. MCITP/MCTS/MCSA/MCSE tell...

    Tom

    September 1, 2013 at 9:54 am

    #1646627

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/31/2013)

    Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.

    I like...

    Tom

    August 31, 2013 at 9:58 am

    #1646573

  • RE: I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I am getting desired result as I have tested this on small set of data ,but while running on large set of records it taking huge of amount of time, might be due to multiple nested while looping

    The description od what is calculate says number of times a city is visited is calculated; the sample data and expected results are completely different from this; for example a...

    Tom

    August 30, 2013 at 6:18 pm

    #1646520

  • RE: Clause Group By

    If this is a more general thing than just the one case, maybe something like

    SELECT

    MIN([NAMES]) AS [NAMES], [NUMBER]

    FROM

    ( SELECT [CV].[dbo].[T40]

    ...

    Tom

    August 30, 2013 at 3:45 pm

    #1646505

  • RE: 5nf

    Francis Apel (8/30/2013)

    Simply put, tables are in fifth normal form when they comply with fourth normal form and the table consists of a key attribute and a non-key attribute ONLY.

    That's...

    Tom

    August 30, 2013 at 3:21 pm

    #1646501

  • RE: Communicating with Non-Technical Users

    Brandie's right. You have to understand what the nontechnical people do, what their concerns are, what there culture is, so that you can express your technical information in terms...

    Tom

    August 30, 2013 at 2:22 pm

    #1646492

  • RE: How to deny restore database in sql server to SA?

    Brandie Tarvin (8/29/2013)

    K. Brian Kelley (8/29/2013)

    With the different accounts in different environments, they are all admin accounts. Just one works for dev and one works for prod and dev never...

    Tom

    August 30, 2013 at 2:15 pm

    #1646486

  • RE: How to deny restore database in sql server to SA?

    SQLRNNR (8/28/2013)

    Here's another vote for multiple logins.

    In addition, another vote for taking greater care and caution when attempting to do a restore.

    The server trigger may work, but I agree with...

    Tom

    August 30, 2013 at 2:09 pm

    #1646484

  • RE: Sql query Help

    The reason that you are getting duplicate IDs is that at least one of your tables has more than one row with a given ID_NUM and some of the other...

    Tom

    August 30, 2013 at 2:00 pm

    #1646479

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/30/2013)

    YAY! I have a new computer at work.

    Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now...

    Tom

    August 30, 2013 at 12:43 pm

    #1646456

  • RE: Today's Random Word!

    ChrisM@Work (8/30/2013)

    jasona.work (8/30/2013)

    Daniel Bowlin (8/30/2013)

    sing4you (8/29/2013)

    Jersey Boy

    The Boss

    Springsteen

    Sprightly

    Sprite

    Tom

    August 30, 2013 at 8:37 am

    #1646389

Viewing 15 posts - 3,166 through 3,180 (of 7,483 total)