Forum Replies Created

Viewing 15 posts - 361 through 375 (of 49,552 total)

  • RE: Restore database with Attach

    Yup, I'll chip in with advice:

    Ask the client to hunt and see if he has any backups from before he got hit with a ransomware attack, because 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

    February 9, 2018 at 5:27 am

    #1979217

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, February 8, 2018 10:57 AM

    Chris Harshman - Thursday, February 8, 2018 10:39 AM

    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

    February 8, 2018 at 1:43 pm

    #1979105

  • RE: I need a opinion

    Lynn Pettis - Wednesday, February 7, 2018 8:26 AM

    msimone - Wednesday, February 7, 2018 7:37 AM

    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

    February 7, 2018 at 10:27 am

    #1978930

  • RE: sa account login_time field

    You want to filter for is_user_process = 1, as all the system processes appear as 'sa'

    And querying sys.dm_exec_sessions isn't sufficient for auditing. Create an extended events session or...

    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

    February 7, 2018 at 6:15 am

    #1978847

  • RE: can we configure transaction replication in log shipping primary database

    No. They're completely unrelated features.

    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

    February 7, 2018 at 5:36 am

    #1978835

  • RE: can we configure transaction replication in log shipping primary database

    Yes.

    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

    February 7, 2018 at 2:59 am

    #1978818

  • RE: Stored proc with variables

    I strongly recommend that you use one procedure for one thing. No dynamic code. Or use an ORM for those drop downs
    Yes, it's some up-front work, but it makes...

    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

    February 6, 2018 at 3:19 am

    #1978670

  • RE: SQL user account lost its stored procedure execution access

    adisql - Monday, February 5, 2018 2:48 PM

    GilaMonster - Monday, February 5, 2018 12:11 AM

    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

    February 6, 2018 at 1:00 am

    #1978661

  • RE: Checking for duplicate clients before INSERT

    That's a discussion that needs to be had with the business users. It's business rules around what's valid and invalid 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

    February 5, 2018 at 2:00 am

    #1978512

  • RE: Views based on Multiple tables causing Locks?

    subramaniam.chandrasekar - Monday, February 5, 2018 1:10 AM

    ash.blair - Friday, February 2, 2018 8:39 AM

    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

    February 5, 2018 at 1:52 am

    #1978510

  • RE: SQL user account lost its stored procedure execution access

    Either that object does not exist in the user's default schema or dbo, or the user does not have permission on that table. Please check which it is.

    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

    February 5, 2018 at 12:11 am

    #1978502

  • RE: Attach DB fails

    The error's a 'file not found', so the obvious question is, is the file there?

    Double-check that path please, because it doesn't look correct

    C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Galactic.mdf

    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

    February 5, 2018 at 12:03 am

    #1978500

  • RE: How to List All table Modified, altered, updated, inserted in sqlserver 2000 database Last N Days.

    patelmaulesh007 - Saturday, February 3, 2018 4:54 AM

    SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
    FROM sys.dm_db_index_usage_stats
    WHERE database_id = DB_ID( 'TreatmentFADT')
    AND OBJECT_ID=OBJECT_ID('CommercialTeams')

    Won't work on SQL 2000.

    8...

    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

    February 3, 2018 at 5:24 am

    #1978441

  • RE: How can identify those indexes which are slow down database performance.

    Indexes don't slow down query performance though. And what exactly do you define as an 'incorrect' index?

    Technically all indexes will slow down data changes (inserts), but that's usually...

    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

    February 2, 2018 at 6:09 am

    #1978334

  • RE: Two tables that they have foreign keys pointing to each other

    Joe Torre - Thursday, February 1, 2018 3:16 PM

    Try doing both in a single transaction:

    begin tran
       delete tbl1 where ...
       delete tbl2...

    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

    February 2, 2018 at 12:49 am

    #1978306

Viewing 15 posts - 361 through 375 (of 49,552 total)