Forum Replies Created

Viewing 15 posts - 5,311 through 5,325 (of 49,552 total)

  • RE: Performance monitoring on a new DB Server

    print_mug (7/15/2015)

    Hi everyone. I am quite new to this so please be kind! 🙂

    I have been given a project to centralise all our databases onto one DB server. Currently in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 15, 2015 at 5:43 am

    #1812575

  • RE: compression backup

    Use SQL's native backup compression.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 15, 2015 at 3:21 am

    #1812557

  • RE: Why use Select 1

    Personally, to make it clear(er) that EXISTS doesn't care what the columns are.

    And 1/0 works, but something like LOG(-1) doesn't. I suspect the latter is a parse-time error.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 4:07 pm

    #1812487

  • RE: Syntax Error IS NULL

    SolveSQL (7/14/2015)

    what's the purpose of comparing same column from same table?

    ..."WHERE Loss_state = #tmpTotals.Loss_State"

    He's not.

    The table inside the subquery is aliased as t and the binding order for columns...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 1:26 pm

    #1812454

  • RE: SQL 2012 or 2014?

    As I said above, the MCSE exams have been updated to include the 2014 material. There's only one set of MCSE exams.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 12:03 pm

    #1812423

  • RE: Applying a snapshot in SQL Server Replication

    Fixed

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 8:20 am

    #1812329

  • RE: Applying a snapshot in SQL Server Replication

    Mark the subscription for reinitialisation.

    Please note you don't need to reinit a subscription unless something has occurred to change the subscriber or it's been offline for longer than the retention...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 7:15 am

    #1812304

  • RE: Stats Updates

    Please post new questions in a new thread. Thank you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 7:13 am

    #1812302

  • RE: How can I close ALL Connections to a particular Database Engine in Management Studio?

    Eirikur Eiriksson (7/14/2015)

    Quick suggestion, run an instance of ssms for each server.

    😎

    This.

    Enforce it by using different windows logins for the two servers. Then one instance of SSMS is run as...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 7:01 am

    #1812292

  • RE: MS sql database slow performance issue suddenly in peak hour

    No, it's not a good solution. By updating the stats you're likely forcing all plans to recompile. It's probably only one or two queries which are causing the problem and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 6:43 am

    #1812288

  • RE: large tables in OLTP

    How long is a piece of string?

    I've got 20 million row tables in my test DB. I've seen tables with billions of rows in them. I've seen systems where no...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 6:24 am

    #1812281

  • RE: SQL 2014 cluster on existing SQL 2008 cluster

    Bear in mind that it's not just a case of whether you can install it, but also whether you should, whether the server have spare capacity for the workload that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 6:04 am

    #1812276

  • RE: How to track modification date on specific table

    RTaylor2208 (7/14/2015)

    If all you want to know is when was a row changed are you able to add a new column to the table called something like DateModified and have...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 5:54 am

    #1812271

  • RE: Daily sum aggregation

    Depending what your data looks like and what data types are involved, that query could aggregate to the day, to the minute or to the millisecond. Can't tell.

    To return only...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 4:14 am

    #1812251

  • RE: varbynary(max) to varchar(max)

    CAST (SomeColumn AS VARCHAR(Max))

    CAST (SomeColumn AS VARBINARY(MAX))

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 14, 2015 at 3:42 am

    #1812244

Viewing 15 posts - 5,311 through 5,325 (of 49,552 total)