Forum Replies Created

Viewing 15 posts - 12,106 through 12,120 (of 49,552 total)

  • RE: Log LDF file

    Can't, not with your set of restrictions. You're insisting that the easiest solution not be used and that a feature that has nothing to do with audits be used instead.

    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 14, 2013 at 8:50 am

    #1641441

  • RE: Sql Server 2008 R2 Partitioning

    If you don't partition-align all your indexes, you cannot switch partitions out. If you don't partition the clustered index, then you haven't got a partitioned table at all.

    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 14, 2013 at 8:44 am

    #1641438

  • RE: Operating system error = 3

    initerrlog: Could not open error log file 'E:\MSSQL10.Cluster001SQL1\MSSQL\Log\ERRORLOG'. Operating system error = 3(The system cannot find the path specified.).

    Does the folder exist?

    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 14, 2013 at 8:42 am

    #1641436

  • RE: Removing log information from log file by using DBCC SHRINK FILE

    EmptyFile is only valid when shrinking a data file. It's completely ignored when specified on a log file. Nothing can ever move log records around within a log file.

    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 14, 2013 at 8:41 am

    #1641435

  • RE: Log LDF file

    OnlyOneRJ (8/14/2013)

    will that provide me data about who did what & what ahppened :w00t:

    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

    August 14, 2013 at 8:35 am

    #1641433

  • RE: Log LDF file

    You didn't answer any of my questions.

    GilaMonster (8/14/2013)

    What's the DB's RPO? RTO? What are the audit requirements for DDL? DML? What are the security requirements around who can do what?

    etc,...

    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 14, 2013 at 8:25 am

    #1641423

  • RE: Maintain the sort order of data file while using bcp

    Gil_Adi (8/14/2013)

    The file being read contains Receipt Header with it corresponding lines just after the Receipt Raw header

    The file includes several Receipts

    So Maintianing the read order is very important

    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 14, 2013 at 8:23 am

    #1641422

  • RE: Maintain the sort order of data file while using bcp

    Ed Wagner (8/14/2013)

    1. Import into a temporary table. Don't worry about the order.

    2. Insert into your real table using a SELECT on your temporary table with an ORDER BY...

    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 14, 2013 at 7:55 am

    #1641404

  • RE: Are the posted questions getting worse?

    Is there some muttering somewhere in the background?

    😛

    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 14, 2013 at 7:52 am

    #1641400

  • RE: Sql Server 2008 R2 Partitioning

    2, 3, 4 and 5, fine, all achievable

    1 - https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

    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 14, 2013 at 7:49 am

    #1641399

  • RE: Sql Server 2008 R2 Partitioning

    What's the goal of the partitioning? What are you expecting to achieve?

    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 14, 2013 at 7:26 am

    #1641385

  • RE: Use same partition scheme across multiple tables

    https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

    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 14, 2013 at 7:09 am

    #1641370

  • RE: Help:Need to run a query against multiple SQL server instances across SQL server version(2000,2005,2008,2008 R2)

    Open 2008's SSMS. Register all the servers you need to run the query against. Right click the folder (in Registered Servers) -> New Query. Write your query, run 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 14, 2013 at 5:31 am

    #1641326

  • RE: Use same partition scheme across multiple tables

    senthil kumar d (8/14/2013)

    Later when I want to merge/split these ranges will it involve a lock on all the tables involved.

    Yes. Splitting/merging partitions requires schema modification locks, that's essentially exclusive...

    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 14, 2013 at 5:11 am

    #1641316

  • RE: Log LDF file

    Well, I guess the first step is to identify requirements, before grabbing a solution at random.

    What's the DB's RPO? RTO? What are the audit requirements for DDL? DML? What 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 14, 2013 at 5:09 am

    #1641313

Viewing 15 posts - 12,106 through 12,120 (of 49,552 total)