Forum Replies Created

Viewing 15 posts - 41,671 through 41,685 (of 49,552 total)

  • RE: Top N sub query workaround - Does it exist?

    Ramesh (1/16/2009)

    You are using correlated sub-queries, which is another form of RBAR...,

    The optimiser can handle most correlated subqueries just fine. If the comparison with the outer query is an...

    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 16, 2009 at 6:17 am

    #928019

  • RE: Internal Table

    Ah, those.

    You still didn't answer my question. What's the name of the table that you think is causing the error?

    Have you considered apply Cumulative update 2 (or higher) as, according...

    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 16, 2009 at 6:12 am

    #928013

  • RE: distinct view

    cotzan (1/16/2009)

    Firstly thank you very much friends.

    these datas a pieace of my view. see 8,9 coloums. they have same datas. but i cant distinct

    8Adomat Matbaa Baski Ltd Sti.Emre Güzeldal11.05.20071

    9Adomat Matbaa...

    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 16, 2009 at 5:35 am

    #927986

  • RE: Buffer latch type 3Msdb Cannot backup\Cannot view history of Jobs

    Try running checkDB with the tablock option. It won't try to create a snapshot.

    Can you try and view job information and then, while it's waiting, check sys.dm_exec_requests and see 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

    January 16, 2009 at 5:31 am

    #927982

  • RE: Internal Table

    What version of SQL are you on? (SELECT @@version)

    What do you mean by 'internal table'? What's the name of the table that you think is responsible?

    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 16, 2009 at 5:25 am

    #927973

  • RE: clusterd index

    CrazyMan (1/16/2009)

    Alter table

    Alter table Table Name Drop Constraint ConstraintName

    True, if the clustered index is part of a primary key or unique constraint. If it's just...

    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 16, 2009 at 5:23 am

    #927972

  • RE: Are the posted questions getting worse?

    Adi Cohn (1/16/2009)

    Actually when you have legal weapons there are procedures in air lines that lets you fly with your weapons.

    I think it depends on the airline and...

    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 16, 2009 at 5:16 am

    #927970

  • RE: How to move log file ON-LINE ?

    Suresh Kumar Maganti (6/11/2008)

    The path would be changed in catalog views immediately but the actual log file would be physically moved to the new location at the next restart of...

    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 16, 2009 at 1:07 am

    #927883

  • RE: How to restore .bbk file to SQL!!!!!

    What's a .bbk file? It's not the standard extention for a SQL backup (though that doesn't mean it isn't a sQL backup)

    Where did you get the file? How was 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

    January 16, 2009 at 1:04 am

    #927881

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/15/2009)

    Gail, according to your web site you've done web development at one time, so I have a very basic question for you, where would I look to check...

    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 16, 2009 at 1:00 am

    #927879

  • RE: Which SQL would run faster?

    Well, running them would be a far quicker way of seeing which is faster than asking.

    I can say that the third will probably be the slowest. Don't know about...

    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 16, 2009 at 12:58 am

    #927877

  • RE: I/O requests taking more than 15 seconds

    Sandra Skaar (1/15/2009)

    I talked with the SAN team some more today. There are no errors to correlate. The network backups run from 6PM to 4AM, which is when many of...

    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 16, 2009 at 12:53 am

    #927875

  • RE: Managing the Transaction Log size growth during an index rebuild

    Marker (1/15/2009)

    GilaMonster: it does not backup up the TRN log during the index rebuild.

    As in it runs for the duration of the index rebuild (and if that'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 16, 2009 at 12:32 am

    #927872

  • RE: tables data changes question

    Paresh Prajapati (1/15/2009)

    Create DDL trigger to change track and send mail notification.

    Um...

    DDL triggers fire when there's a change to the table structure, not the table's data (which is what foxjazz...

    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 16, 2009 at 12:31 am

    #927871

  • RE: Fully justified text

    george (1/15/2009)

    I've simply posted in the wrong forum.

    No prob.

    All of these forums here are dedicated to SQL server. We have no .net forums. I'd recommend you a good .net...

    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 16, 2009 at 12:27 am

    #927869

Viewing 15 posts - 41,671 through 41,685 (of 49,552 total)