Forum Replies Created

Viewing 15 posts - 41,686 through 41,700 (of 49,571 total)

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

    Ramesh (1/16/2009)

    Thanks gail, for letting me know about the optimizer and correcting me. One thing, is it do the same in all environments? Or is it dependent on...

    January 16, 2009 at 6:48 am

    #928067

  • RE: Internal Table

    CrazyMan (1/16/2009)

    When i tried to apply the CU that MS mentioned, it said that an advanced version is been installed on the machine 🙂

    It's one of the service broker...

    January 16, 2009 at 6:46 am

    #928064

  • RE: Database size trouble

    Ramesh (1/16/2009)

    Thanks again Gail, but I was thinking about the shrinking the logs. Does it break the log chain of the database?

    No. Shrinking logs does not break the log...

    January 16, 2009 at 6:45 am

    #928062

  • RE: Database size trouble

    Ramesh (1/16/2009)

    So, if the database is not in production or you don't need any information from the logs then you can simply hrink the database, and take the...

    January 16, 2009 at 6:18 am

    #928023

  • 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...

    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...

    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...

    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...

    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?

    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...

    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...

    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...

    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...

    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...

    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...

    January 16, 2009 at 12:58 am

    #927877

Viewing 15 posts - 41,686 through 41,700 (of 49,571 total)