Forum Replies Created

Viewing 15 posts - 43,321 through 43,335 (of 49,552 total)

  • RE: Query is in suspended mode

    balbirsinghsodhi (11/4/2008)

    I think it's not a bad idea to start some kind of web site and help people by charging some money.

    What, like this one? Except of course...

    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 4, 2008 at 11:52 pm

    #894067

  • RE: Query is in suspended mode

    balbirsinghsodhi (11/4/2008)

    Hi Gail..

    Here is the attached actual execution plan.

    Thanks. I'll take a look at it later in the week. I've got a lot of things to get done in 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

    November 4, 2008 at 11:48 pm

    #894066

  • RE: transaction logs

    Lynn Pettis (11/4/2008)

    WHY is everyone so eager to shrink their databases transaction log files?

    Beats me. I'm wondering why people are so eager to throw away log records and expose...

    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 4, 2008 at 6:40 pm

    #893994

  • RE: Help with Query

    htt (11/4/2008)

    Table definitions is in the sample data. I am just looking for a query to produce a result that look like the result when you run the second...

    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 4, 2008 at 6:33 pm

    #893991

  • RE: Backup

    SQL 2000 or SQL 2005? This is a SQL 2005 forum.

    If SQL 2000, was there a full or diff database backup occurring at that time?

    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 4, 2008 at 5:48 pm

    #893984

  • RE: Msg 62309, Level 19, State 1, Line 1 on Litespeed RESTORE

    Jayakumar Krishnan (11/4/2008)

    2008-11-04 16:08:39.130 spid74 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:11748607; actual 23:5220531). It occurred during a read...

    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 4, 2008 at 5:47 pm

    #893983

  • RE: Defragmentation in 2005 vs 2000

    What do you mean by 'external fragmentation'?

    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 4, 2008 at 5:44 pm

    #893982

  • RE: How actually the restore works?

    Mani (11/4/2008)

    Well, when I restore full backup(z:\Backup\SPProd_Cfg.bak at 1am), the mdf file of SPProd_Cfg.mdf will be replaced with the newly restored .bak file and creates the new mdf file?

    Yes,...

    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 4, 2008 at 5:41 pm

    #893979

  • RE: Msg 62309, Level 19, State 1, Line 1 on Litespeed RESTORE

    What does the following do?

    RESTORE DATABASE DATABASE1 WITH RECOVERY

    Is there anything interesting in the SQL error log from that time?

    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 4, 2008 at 5:37 pm

    #893975

  • RE: Help with Query

    Table definitions and expected output please.

    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 4, 2008 at 5:37 pm

    #893973

  • RE: transaction logs

    clive (11/4/2008)

    I normally use this method:

    1. backup log Pubs with no_log

    2. dbcc shrinkfile(Pubs_log, 100) -- shrink log file

    3. dbcc updateusage(Pubs) ...

    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 4, 2008 at 5:31 pm

    #893971

  • RE: Query is in suspended mode

    balbirsinghsodhi (11/4/2008)

    There are scans but cost is 0%, do you think we should consider those too.

    Yes, because they are still scans, ie a read of all the pages 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

    November 4, 2008 at 5:29 pm

    #893970

  • RE: transaction logs

    sayfrend (11/4/2008)

    What is the reason to kill the open Transaction. Correct me if I am wrong, When SQL Server takes Transactional log backup, it removes all the inactive transactions...

    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 4, 2008 at 5:26 pm

    #893969

  • RE: Query is in suspended mode

    What do you mean, you don't see lots of scans? Are you looking at the same execution plan I am? See attached. There are only two seeks in the entire...

    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 4, 2008 at 1:47 pm

    #893878

  • RE: Database in recovery mode

    Have a look in the error log. What does it say about that 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

    November 4, 2008 at 1:04 pm

    #893845

Viewing 15 posts - 43,321 through 43,335 (of 49,552 total)