Forum Replies Created

Viewing 15 posts - 28,501 through 28,515 (of 49,552 total)

  • RE: IS Shrink part of Full Backup by default or as an option

    MothInTheMachine (1/12/2011)

    Our CIO said he wanted us to shrink the database because a confidential document had been put onto a public SharePoint site. As part of our cleanup we...

    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

    January 12, 2011 at 9:32 am

    #1272451

  • RE: Integration Service and Oracle 8 whit ODBC connection

    Source: Inserta Horas Hombre Empleados ADO NET Source [337] Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default...

    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

    January 12, 2011 at 8:10 am

    #1272392

  • RE: Execute sql without writing on transaction log

    Schadenfreude-Mei (1/12/2011)

    Unless you change the ricovery model and then run your reindex (buts it is not advisable).

    It's logged regardless of the recovery model. Minimally logged in recovery models other than...

    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

    January 12, 2011 at 8:08 am

    #1272390

  • RE: Restoring individual filegroups

    You have to restore primary. Primary is where all the system tables are and without those the database would be useless.

    You need to restore primary, then one of more filegroups,...

    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

    January 12, 2011 at 8:06 am

    #1272389

  • RE: SQL deadlock issue in Sharepoint 2007.

    From what I've heard (from CSS), deadlocks on Sharepoint search crawl are expected and are not a problem, the crawl retries.

    You cannot make any code, structure or index changes to...

    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

    January 12, 2011 at 8:05 am

    #1272386

  • RE: Future Forecast for performance

    Not exactly stress testing. Fiddling the statistics will make the optimiser produce execution plans as though the row count was different, it won't make the queries run as though there...

    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

    January 12, 2011 at 6:58 am

    #1272342

  • RE: SQL 2008 - View - Order by Problem

    Order by is not honoured anywhere other than in the outer-most select statement, that is, the one that selects from the view. This is not a bug, it's intentional. The...

    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

    January 12, 2011 at 5:15 am

    #1272295

  • RE: Temporary variables in SQL

    tharucse (1/12/2011)

    Thanks Gail.I just asked one person who has this practice of using temporary variables.They say that they keep it as a standard way to write sql procedures even there...

    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

    January 12, 2011 at 5:10 am

    #1272294

  • RE: What is the best method for backup and restore VLDB and auto-delete data from the backup database?

    If it's for high availability, database mirroring is probably best. It won't make the production database readonly (it would be pretty worthless if it did), the mirror database will 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

    January 12, 2011 at 3:17 am

    #1272253

  • RE: Integration Service and Oracle 8 whit ODBC connection

    Source: Incidentes Connection manager "Oracle" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider...

    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

    January 12, 2011 at 3:10 am

    #1272249

  • RE: Sql Server 2008 Integration Server and ODBC for Oracle

    Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1046340-1044-1.aspx

    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

    January 12, 2011 at 3:07 am

    #1272247

  • RE: What is the best method for backup and restore VLDB and auto-delete data from the backup database?

    Um, yes. In simple recovery you can't take log backups.

    Why full and diff? That's a bit overkill for a tiny database. The full backup should finish in minutes.

    Now, what's the...

    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

    January 12, 2011 at 2:58 am

    #1272243

  • RE: Allocate memory to SELECT statement in sql server 2005

    Then the answer is simple - you can't.

    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

    January 12, 2011 at 2:37 am

    #1272240

  • RE: What is the best method for backup and restore VLDB and auto-delete data from the backup database?

    Depends. What's the current recovery model and what's your current log backup frequency?

    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

    January 12, 2011 at 2:36 am

    #1272238

  • RE: What is the best method for backup and restore VLDB and auto-delete data from the backup database?

    wcyip (1/12/2011)

    What would it be the best backup and restore from the this VLDB - 1 database of 60 Gb in size in 1 physical server to 1 empty database...

    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

    January 12, 2011 at 1:42 am

    #1272223

Viewing 15 posts - 28,501 through 28,515 (of 49,552 total)