Forum Replies Created

Viewing 15 posts - 2,386 through 2,400 (of 2,756 total)

  • RE: Data Types

    That was an easy one.  I am a little confused why 1% of the people picked bigint though?  Thinking that has to be a rounding error.... right?

  • RE: what is good career Sql Developer or sql DBA ?

    My job title is DBA, but I do both DBA work and developer work (both database and software).
    It really depends on what the company is looking for.  I've read...

  • RE: SQL 2012 to 2014 upgrade

    Oh, one other piece of advice - Run the upgrade on a TEST environment first so you can see how it all works and test all of your reports.
    I'd...

  • RE: cluster disk expand

    tcronin 95651 - Monday, June 5, 2017 1:17 PM

    2012 NFTS

    Then you should be able to extend the partition inside disk manager.
    Where I...

  • RE: Need Help Getting Max Date

    meichmann - Monday, June 5, 2017 11:24 AM

    bmg002 - Monday, June 5, 2017 9:26 AM

  • RE: cluster disk expand

    tcronin 95651 - Monday, June 5, 2017 11:33 AM

    disk manager not cutting it looking at diskpart

    Disk Manager is essentially a GUI for...

  • RE: SPs calling other SPs

    rs80 - Monday, June 5, 2017 11:54 AM

    Thanks for your reply.

    The 3 variables @dtEffective, @dtCurBus, and @dtsCstBasStart are being used within the...

  • RE: SQL 2012 to 2014 upgrade

    Also, make sure your backups are good before you do an upgrade.  Nothing worse than having a failed upgrade and no rollback plan.

    And I agree, upgrading to 2016...

  • RE: SPs calling other SPs

    rs80 - Monday, June 5, 2017 10:31 AM

    I have a stored procedure that calls other stored procedures.  All of the other stored...

  • RE: cluster disk expand

    tcronin 95651 - Monday, June 5, 2017 11:19 AM

    On physical active/passive cluster, needed to expand drive for tempdb by 100 gig.  Had...

  • RE: Need Help Getting Max Date

    meichmann - Monday, June 5, 2017 4:24 AM

    bmg002 - Friday, June 2, 2017 1:56 PM

  • RE: Are the posted questions getting worse?

    Ed Wagner - Friday, June 2, 2017 7:06 PM

    bmg002 - Friday, June 2, 2017 2:58 PM

    June 5, 2017 at 9:12 am

    #1945426

  • RE: SQL server 2014 is very slow

    pranabpal - Monday, June 5, 2017 3:06 AM

    Grant Fritchey - Friday, June 2, 2017 6:01 AM

    June 5, 2017 at 9:02 am

    #1945421

  • RE: Are the posted questions getting worse?

    Sean Lange - Friday, June 2, 2017 1:44 PM

    bmg002 - Friday, June 2, 2017 1:27 PM

    June 2, 2017 at 2:58 pm

    #1945216

  • RE: Need Help Getting Max Date

    would this work:
    SELECT DISTINCT COUNTY.CountyName,
    MAX(ORDERS.UserDate2) OVER (PARTITION BY CountyName) AS LastCovered,
    MAX(FSLog.CompletedDate) OVER (PARTITION BY CountyName) as CompletedDate,
    property.State

    FROM ORDERS...

Viewing 15 posts - 2,386 through 2,400 (of 2,756 total)