Forum Replies Created

Viewing 9 posts - 16 through 24 (of 24 total)

  • Reply To: The Counter Offer - Part 1

    For myself, if I am looking for a new job it's because I've tried and failed to get my current one improved. Any counter offer would therefor be questioned as...

  • RE: No More SQL Server Installs

    n.ryan - Wednesday, March 27, 2019 3:44 AM

    Yes, however due to regional sites if the data centre...

  • RE: No More SQL Server Installs

    Geoff.Sturdy - Wednesday, March 27, 2019 1:26 AM

    n.ryan - Tuesday, March 26, 2019 3:26 AM

  • RE: No More SQL Server Installs

    I'm with N.Ryan on this, but will add a spin: You'll need to configure SQL to meet your needs, and test that configuration, so at some point you'll need to...

  • RE: The Devil is in the Monitoring Details

    If you only check the monitor data when something goes wrong, you're reacting to an issue, not being proactive in managing your servers.

    No, you won't catch every instance,...

  • RE: TOP vs Max/Min: Is there a difference?

    Lynn Pettis - Tuesday, December 18, 2018 2:09 PM

    I can actually say that I have never used ORDER BY ordinal position...

  • RE: TOP vs Max/Min: Is there a difference?

    denisock: Yes, ORDER BY 1 is accepted syntax. It's used when you're uncertain of the column names but know you want to order by column 1 in the select list....

  • RE: TOP vs Max/Min: Is there a difference?

    Logically the two operations would be different and give different results. ORDER BY <column> ASC/DESC with TOP (X) may be used to obtain the maximum or minimum value from a...

  • RE: Plan Offsets

    Going to take exception to this: The supposed answer is wrong: 'ys.dm_exec_requests' does not exist. It is, as on the previous line 'sys.dm_exec_requests'. Think you have a typo in the...

Viewing 9 posts - 16 through 24 (of 24 total)