Forum Replies Created

Viewing 15 posts - 21,991 through 22,005 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    I'm off to the middle of nowhere for a few days (middle of nowhere also known as the Free State). Can you guys keep an eye out for corrupt databases,...

    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

    November 24, 2011 at 9:18 am

    #1412746

  • RE: Filesystem free space

    Free space in the data file or free space in the filesystem?

    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

    November 24, 2011 at 9:14 am

    #1412744

  • RE: sql server profiler running trace

    File menu?

    You can alter the statuses of traces with sp_trace_setstatus (I think that's where the _ are). See Books Online for details, I can never remember the parameters offhand.

    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

    November 24, 2011 at 9:11 am

    #1412742

  • RE: Standby Logshipping DB that has gone into suspect mode

    I would just restore from backup. It's generally the recommended route when a database is suspect anyway. Emergency mode repairs are for those cases where a DB has gone suspect...

    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

    November 24, 2011 at 9:06 am

    #1412739

  • RE: Why oh Why isnt this updating any indexes....

    How big are those indexes? How many pages?

    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

    November 24, 2011 at 8:55 am

    #1412734

  • RE: Can't Shrink the Transaction Log

    Andeavour (11/24/2011)

    Argh... Shot down in flames by your sharp eyed skills 🙂

    You're right of course. I have actually only used it against Data files in the past, and now I'm...

    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

    November 24, 2011 at 8:54 am

    #1412733

  • RE: Troubles running sp_msForEachTable

    Alternate suggestion. Stop fighting with ForEachTable (which, by the way you don't need to create in user databases, it's a system procedure accessible from anywhere) and use this DMV

    sys.dm_db_index_physical_stats (See...

    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

    November 24, 2011 at 6:41 am

    #1412680

  • RE: Moving "E:\Program Files\Microsoft SQL Server\90\Tools"

    Don't, or reinstall SQL Server.

    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

    November 24, 2011 at 6:16 am

    #1412671

  • RE: Database server Upgrade from sql 2000 SP3 standard to SQL 2K Enterprise SP4

    SQL 2000 SP4 is also out of support unless you have a premier contract and extended support. Has been so for 3+ years.

    No chance of upgrading to SQL 2008 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

    November 24, 2011 at 5:22 am

    #1412652

  • RE: System database checksum file has invalid signature

    I'd suggest Microsoft support, but SQL 2000 has been out of support for 3 years or so.

    Maybe reinstall SQL and reattach the user databases, but I don't know 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

    November 24, 2011 at 5:15 am

    #1412651

  • RE: Can't Shrink the Transaction Log

    The NoTruncate and TruncateOnly options on a shrink are solely for data files. They are completely ignored when shrinking a log file.

    From Books Online (DBCC ShrinkFile)

    NOTRUNCATE

    Moves allocated pages from...

    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

    November 24, 2011 at 2:39 am

    #1412599

  • RE: System database checksum file has invalid signature

    You can try this: http://dbaspot.com/sqlserver-tools/226265-checksum-problem-system-database.html

    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

    November 24, 2011 at 2:37 am

    #1412597

  • RE: When are partitioned indexes slower than regular indexes?

    Ask the person who told you that for a query that shows the problem.

    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

    November 24, 2011 at 2:30 am

    #1412596

  • RE: Query execution plan difference

    Exact same table definitions? Exact same indexes? Exact same data volumes and distribution? Exact same hardware?

    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

    November 24, 2011 at 2:19 am

    #1412589

  • RE: which High Avaiblity Option is better?

    logicinside22 (11/23/2011)

    Hi folks,

    I have to keep report server real time updated with prodcution server databse . would like to know the suggestions which HA option is better...

    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

    November 24, 2011 at 2:12 am

    #1412586

Viewing 15 posts - 21,991 through 22,005 (of 49,552 total)