Forum Replies Created

Viewing 15 posts - 34,186 through 34,200 (of 49,552 total)

  • RE: How to check sql server 2000 still receive data

    Edwin-376531 (2/5/2010)

    What is the Microsoft recommended good practices to cope this kind of scenario?

    A good backup strategy designed according to the downtime and data loss requirements of the application.

    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

    February 5, 2010 at 1:03 pm

    #1114737

  • RE: Table Variable Issue

    The estimated row count on your actual physical table is wrong. SQL thinks that the physical table contain only 1000 rows and hence that a scan of the physical table...

    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

    February 5, 2010 at 12:35 pm

    #1114714

  • RE: High Availability with zero RPO

    Bru Medishetty (2/5/2010)

    It would still be one of the better features for having multiple copies of data.

    Sure, it's fine for secondary reporting systems. It's just bad for hot failover...

    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

    February 5, 2010 at 12:15 pm

    #1114705

  • RE: Table Variable Issue

    Post the execution plans?

    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

    February 5, 2010 at 12:10 pm

    #1114700

  • RE: Are the posted questions getting worse?

    Luke L (2/5/2010)

    Yes, but you'll have to wait for Gail's Blog post on DBCC TimeWarp to make certain you get all 137 non-optional parameters correct.

    btw, as an aside, in case...

    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

    February 5, 2010 at 11:53 am

    #1114688

  • RE: High Availability with zero RPO

    Replication is not a high availability technique. While it can create a copy of a database, it's a pain to switch apps over, it may not be a complete copy...

    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

    February 5, 2010 at 11:41 am

    #1114673

  • RE: Lock hints

    namrata.dhanawade-1143388 (2/5/2010)

    But that would mean to look at other things for my performance issue.

    Yup. Poorly written queries, inadequate indexing. Main causes of any perf 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

    February 5, 2010 at 8:42 am

    #1114499

  • RE: Are the posted questions getting worse?

    BrainDonor (2/5/2010)

    Gail,

    How do you find them?

    Do you use divining rods? I admire your determination.

    Somedays I think they're finding me. If my divining rods worked, I'd use them to avoid some...

    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

    February 5, 2010 at 8:41 am

    #1114495

  • RE: Hourly backups + Weekly full = Overlap = problems???

    subs99 (2/5/2010)

    Or does SQL mindlessly try to do a Log file backup right during a Full backup? That would really mess things up, wouldn't it? What if it did 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

    February 5, 2010 at 8:37 am

    #1114488

  • RE: hdfgh f dfh fgh dfh fgh

    pradeep_kodley175 (2/5/2010)

    insert into TestReport (Answer) select Answer from Question where YourQues.TestReport= Question.Question;

    but its shoing error like "The multi-part identifire "YourQues.TestReport" could not be bound"...

    There's no object called 'YourQues' anywhere 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

    February 5, 2010 at 8:34 am

    #1114483

  • RE: physicaly Deleted LOG file...want new databse to point to MDF file.

    suresh.maddali (2/5/2010)

    Attach the data base --> Right click on Data base and choose attach. before this we need to complete following

    1. Go to c:\Program files\Microsof Sqlserver\MSSQL.1\Data...

    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

    February 5, 2010 at 7:15 am

    #1114413

  • RE: Database Crashed

    zhayatali (2/5/2010)

    then user told me we are facing such problem then i taken full database backup at 12:51.in this satuation can we go back database state before 12:41 or not...

    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

    February 5, 2010 at 4:22 am

    #1114311

  • RE: Database Crashed

    The backup that you took at 12:51 cannot be used to restore to 12:30. There's no time machine in SQL.

    You need to take the latest full backup from before 12:30,...

    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

    February 5, 2010 at 4:11 am

    #1114303

  • RE: Introduction to Indexes

    What more are you looking for?

    http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/

    http://sqlinthewild.co.za/index.php/2008/04/23/execution-plans-important-properties/

    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

    February 5, 2010 at 4:03 am

    #1114301

  • RE: Will The SQL Server Optimizer Recognize and Use More Than One Index on a Single Table?

    With the 3 indexes that you have defined there, the only queries that will perform optimally there will be the ones that filter on a single column. When using predicates...

    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

    February 5, 2010 at 12:03 am

    #1114206

Viewing 15 posts - 34,186 through 34,200 (of 49,552 total)