Forum Replies Created

Viewing 15 posts - 4,966 through 4,980 (of 49,552 total)

  • RE: Hiding the security folder from contractors using SMSS

    Someone who is just dbo can't make changes to the sa account. Someone who's sysadmin (and dbo as a result of being sysadmin) can.

    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

    August 20, 2015 at 7:22 am

    #1821374

  • RE: always on error

    Are you running a 32-bit instance by any chance?

    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

    August 20, 2015 at 6:30 am

    #1821361

  • RE: Effect of Parallelism on Peformance Counters!

    But for getting the expensive queries you won't be using sys.dm_exec_requests (that shows currently running queries), so CPU not being displayed correctly in that one doesn't matter for your problem.

    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

    August 20, 2015 at 4:10 am

    #1821319

  • RE: Effect of Parallelism on Peformance Counters!

    AFAIK, the DMVs show correct data.

    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

    August 20, 2015 at 3:34 am

    #1821307

  • RE: Database integrity

    Well you should be running CheckDB on a regular basis anyway...

    As for whether the DBs are fine or not, depends on exactly what the drives went through, so rather be...

    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

    August 20, 2015 at 2:56 am

    #1821293

  • RE: Effect of Parallelism on Peformance Counters!

    Sorry, I don't understand your question

    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

    August 20, 2015 at 2:48 am

    #1821289

  • RE: Recommendation for Memory Allocation - Log Shipping

    It's not log shipping you need the memory for, it's when your primary fails and you have to switch over to the secondary to keep the app running. The question...

    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

    August 20, 2015 at 2:44 am

    #1821288

  • RE: Is the SQL Server Profiler Reads Column Incorrect For Parallel Plans?

    Actual rows 0, so not 100% sure, but I suspect what's happening is that the TOP only ends up requesting one row from the stream aggregate. Stream aggregate isn't a...

    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

    August 19, 2015 at 8:06 am

    #1821057

  • RE: Is the SQL Server Profiler Reads Column Incorrect For Parallel Plans?

    Open the XML in a text editor, do a find/replace for table and column names. Save, make sure it still loads in SSMS, if so post it.

    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

    August 19, 2015 at 7:36 am

    #1821044

  • RE: Is the SQL Server Profiler Reads Column Incorrect For Parallel Plans?

    Couple other things.

    Don't use the Profiler GUI against a production server. It can and will cause problems, up to and including crashing the server (I've done it). Statistics profile is...

    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

    August 19, 2015 at 7:01 am

    #1821021

  • RE: Is the SQL Server Profiler Reads Column Incorrect For Parallel Plans?

    Please post the execution plan. A picture doesn't have all the properties needed.

    It's worth noting that a scan doesn't have to be the entire table, and that's probably what's happening...

    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

    August 19, 2015 at 6:59 am

    #1821019

  • RE: Find Subject Combinations for each student

    NM, didn't read

    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

    August 19, 2015 at 5:14 am

    #1820985

  • RE: Tuts for performance tuning?

    Start with this: http://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/

    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

    August 19, 2015 at 5:06 am

    #1820981

  • RE: Transaction log not clearing at Checkpoint

    Updating data, if not in an explicit transaction, will be in what's called autocommit mode. An implicit transaction started as the statement starts and automatically committed when the update finishes.

    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

    August 19, 2015 at 3:04 am

    #1820963

  • RE: Is is possible to 'restore' the database from the 'raw' .mdf and .ldf files of the old computer to the new computer / database

    It's possible to recreate the DB from the files.

    It's not a restore though, you don't have a backup. You can attach the files as a new database, providing they are...

    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

    August 19, 2015 at 3:03 am

    #1820962

Viewing 15 posts - 4,966 through 4,980 (of 49,552 total)