Forum Replies Created

Viewing 15 posts - 32,386 through 32,400 (of 49,552 total)

  • RE: DBCC CHECKDB Errors Advice

    kevin77 (6/17/2010)

    I ran this over a month ago and have not done anything about it. As far as I know, the database and application are functioning properly. But...

    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

    June 17, 2010 at 11:36 am

    #1181749

  • RE: DBCC CHECKDB Errors Advice

    kevin77 (6/17/2010)

    Thanks, Steve. I did try dropping and rebuilding several indexes (just like you suggested, on a backup server using a recent restore of the database). But 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

    June 17, 2010 at 11:27 am

    #1181742

  • RE: Recover corrupted mdf file - SS 2000

    You may be able to hack the DB back into the server. See this blog post. It's for 2005/2008, but the procedure's the same on 2000 up until the point...

    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

    June 17, 2010 at 11:22 am

    #1181736

  • RE: can I shrink the database include log file, when database is a Transaction (Subscription) database

    Is this the publisher? Is the log reader running? If not, the log will not be cleared and will grow.

    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

    June 17, 2010 at 11:16 am

    #1181734

  • RE: Query tunning

    Blocking?

    Please post query, table definitions, index definitions and execution plan (both for fast and slow), as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    June 17, 2010 at 11:15 am

    #1181732

  • RE: DBCC CHECKDB Errors Advice

    kevin77 (5/21/2010)

    It then says that the minimum repair level for the errors is 'repair_allow_data_loss'. I've researched some of these errors and can't find much information other than to run...

    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

    June 17, 2010 at 11:08 am

    #1181727

  • RE: Execution Plan reporting different row numbers depending upon maxdop settings

    Can you post the execution plan? It's kinda hard to talk about them in abstract.

    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

    June 17, 2010 at 7:10 am

    #1181534

  • RE: Different behaviour of query on 64 bit and 32 bit

    p.s. You should patch that server up to at least SP3. SQL 2005 should not be left at RTM.

    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

    June 17, 2010 at 6:24 am

    #1181502

  • RE: Different behaviour of query on 64 bit and 32 bit

    That's not an answer. 32-bit and 64-bit are supposed to be feature equivalent. I know the one that you say runs fine works on SQL 2000, I've never seen 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

    June 17, 2010 at 6:23 am

    #1181501

  • RE: create username and password in sqlserver 2008

    Databases don't have logins and passwords, servers do. You need to add a SQL login to the SQL instance. If you're sysadmin or security admin you can do it yourself,...

    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

    June 17, 2010 at 4:32 am

    #1181447

  • RE: Performance tuning on insert query

    Can you post the things I asked for?

    Is this supposed to be an unrestricted select? No where clause?

    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

    June 17, 2010 at 4:22 am

    #1181444

  • RE: Page verify - Backup with checksum

    beppe_30 (6/17/2010)

    Do we need to modify this option which is set to "none" or "Torn_Page_Detection" to "checksum"?

    You should. Checksum is recommended, it detects more IO corruptions than torn page did.

    If...

    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

    June 17, 2010 at 3:41 am

    #1181429

  • RE: dbcc showcontic output analysys

    Rather don't use showcontig. It's deprecated and will be removed in a future version of SQL. The 2005 replacement for showcontig is sys.dm_db_index_physical_stats.

    The columns of interest (well, of most interest)...

    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

    June 17, 2010 at 3:23 am

    #1181423

  • RE: Performance tuning on insert query

    Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    June 17, 2010 at 3:17 am

    #1181418

  • RE: Different behaviour of query on 64 bit and 32 bit

    Can you run the following on both the 32 bit and 64 bit versions please

    SELECT @@version

    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

    June 17, 2010 at 3:16 am

    #1181417

Viewing 15 posts - 32,386 through 32,400 (of 49,552 total)