Forum Replies Created

Viewing 15 posts - 5,971 through 5,985 (of 49,552 total)

  • RE: TRUNCATING MULTIPLE TABLES

    Truncate Table T1

    Truncate Table T2

    ...

    Truncate Table T11

    A truncate can only affect a single table so you have to write 11 truncate statements, and there cannot be a foreign key...

    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

    May 11, 2015 at 10:02 am

    #1797008

  • RE: Space needed for clustered index rebuild

    The only way you're going to change the fill factor is with a rebuild. It's up to you whether that and your sensibilities are worth the work that this 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

    May 11, 2015 at 10:00 am

    #1797006

  • RE: BULK Delete

    Ratheesh.K.Nair (5/11/2015)

    1.Is there anyway this can be achieved with less logging to database?

    Insert, maybe, delete no.

    Will it help if change the recovery mode to Bulk-Logged?

    For the insert, maybe, for...

    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

    May 11, 2015 at 9:52 am

    #1797003

  • RE: Space needed for clustered index rebuild

    Ken Davis (5/11/2015)

    The CI on the big 5-month archive table is highly fragmented. Background info: this was implemented with a terrible clustering key - a random GUID. About...

    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

    May 11, 2015 at 9:35 am

    #1796994

  • RE: How to check page splits number?

    In SQL 2008, with a huge amount of difficulty. The page splits perfmon counter doesn't track page splits but tracks page allocations. The extended event (if it was even 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

    May 11, 2015 at 8:31 am

    #1796965

  • RE: Space needed for clustered index rebuild

    Then I'm curious, why do you need an index rebuild?

    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

    May 11, 2015 at 8:29 am

    #1796964

  • RE: Query

    I'm asking so that I can be sure that I have your requirements right. I don't feel like writing queries multiple times

    Status 1 for maximum month (which will be 12)...

    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

    May 11, 2015 at 7:41 am

    #1796957

  • RE: Running a batch file to execute a stored procedure

    No. How could something running on their machine be able to access resources that can't be accessed from their machine?

    If a user runs a batch file on their machine,...

    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

    May 11, 2015 at 7:07 am

    #1796948

  • RE: Query

    For each row in the example data, please could you explicitly state what the value of status should be for that row?

    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

    May 11, 2015 at 5:59 am

    #1796927

  • RE: Trace Flag 4299?

    I'd push back on this someone and ask them. Because

    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

    May 11, 2015 at 5:40 am

    #1796922

  • RE: Query

    What value? Please be specific. For each row in the example you gave, what should the status column 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

    May 11, 2015 at 5:38 am

    #1796919

  • RE: Query

    So for the example you specified, what should be the output?

    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

    May 11, 2015 at 5:24 am

    #1796914

  • RE: Copying database failed

    Use backup/restore to copy a database from one server to another. Far easier and far less prone to fail than the copy database wizard

    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

    May 11, 2015 at 5:19 am

    #1796913

  • RE: Running a batch file to execute a stored procedure

    If you run the batch file from your machine, it's looking for files and folders on your machine. Hence D:\Path, means it's looking for the drive on your machine mapped...

    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

    May 11, 2015 at 5:17 am

    #1796912

  • RE: Running a batch file to execute a stored procedure

    And does the folder "D:\Path\" exist on your machine?

    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

    May 11, 2015 at 3:43 am

    #1796898

Viewing 15 posts - 5,971 through 5,985 (of 49,552 total)