Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 9,399 total)

  • RE: Today's Random Word!

    ThomasRushton (4/4/2016)


    Ed Wagner (4/4/2016)


    ThomasRushton (4/4/2016)


    Ed Wagner (4/3/2016)


    TomThomson (4/2/2016)


    SQLRNNR (4/1/2016)


    crookj (4/1/2016)


    DonlSimpson (4/1/2016)


    TomThomson (4/1/2016)


    Ed Wagner (4/1/2016)


    SQLRNNR (4/1/2016)


    conversation

    Listen

    hear

    Fear

    Dread

    Locks

    You know those things that mean contention on resources and a winner is chosen while the...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/4/2016)


    Ed Wagner (4/4/2016)


    Brandie Tarvin (4/4/2016)


    So I didn't get out of work until after midnight on Friday thanks to the joys of month end. Finally someone found a switch...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/4/2016)


    So I didn't get out of work until after midnight on Friday thanks to the joys of month end. Finally someone found a switch that we could superglue...

  • RE: Why is this happening?

    mister.magoo (4/3/2016)


    maybe try posting some information about your problem?

    I for one am not willing to click your links to an external site, and I suspect many others feel the same.

    Agreed.

  • RE: Querying linked servers

    A nice and simple question to start the week. Thanks, Steve.

  • RE: What is the best to remove xp_cmdshell calls from t-sql code

    I'd first ask yourself why you want to replace it with something else.

    If this is to make it more secure, then I'd suggest looking at who can run it. ...

  • RE: Today's Random Word!

    ThomasRushton (4/4/2016)


    Ed Wagner (4/3/2016)


    TomThomson (4/2/2016)


    SQLRNNR (4/1/2016)


    crookj (4/1/2016)


    DonlSimpson (4/1/2016)


    TomThomson (4/1/2016)


    Ed Wagner (4/1/2016)


    SQLRNNR (4/1/2016)


    conversation

    Listen

    hear

    Fear

    Dread

    Locks

    You know those things that mean contention on resources and a winner is chosen while the other becomes a...

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/3/2016)


    Just in case you may have missed it, there are no longer any excuses. for the many that we try to help and that refuse to help themselves....

  • RE: Protecting sa

    Jeff Moden (4/2/2016)


    Yet Another DBA (3/30/2016)


    I tend to use a GUID for the password. Simple, straightforward and has approximately 5,300,000,000,000,000,000,000,000,000,000,000,000-ish combinations.

    Only issue is to remember which post-it-note it was...

  • RE: Today's Random Word!

    TomThomson (4/2/2016)


    SQLRNNR (4/1/2016)


    crookj (4/1/2016)


    DonlSimpson (4/1/2016)


    TomThomson (4/1/2016)


    Ed Wagner (4/1/2016)


    SQLRNNR (4/1/2016)


    conversation

    Listen

    hear

    Fear

    Dread

    Locks

    You know those things that mean contention on resources and a winner is chosen while the other becomes a victim?

    Tress

    I guess the...

  • RE: Oracle BETWEEN DateTime statement

    jimtimber (4/2/2016)


    I've found that it seems to accept the date format "01 JANUARY 2016" but no other format. Not sure why this is a default date type.

    In Oracle, you can...

  • RE: Convert Value Returned by Row_Number() Function to Text Based on Relationship to Overall Result Set

    It sounds like you might benefit from the NTILE function. Keep your ROW_NUMBER, but you can use your NTILE result to join to a table (either physical or table-valued-constructor) to...

  • RE: TSQL query to get employee name from employee table by using id from user table

    If the employees table has lots of rows, you shouldn't be using table variables, as they t get the benefit of statistics.

    If these were physical tables, I'd suggest primary keys....

  • RE: Need help with shrink

    Whenever your shrink the log, you're yielding space back to the operating system. However, activity that occurs in the database will be logged, so the log does need space....

  • RE: In Memory Code Name

    TomThomson (4/1/2016)


    SQLRNNR (4/1/2016)


    Why isn't the correct answer Hekaton?

    It was when I picked it, has it changed since?

    Since then some people have picked the mountain, so all the wrong answers have...

Viewing 15 posts - 3,436 through 3,450 (of 9,399 total)