Forum Replies Created

Viewing 15 posts - 32,851 through 32,865 (of 49,552 total)

  • RE: Blocking Issue?

    Jeff Moden (5/16/2010)

    Ummm... you sure? WITH(NOLOCK) can be used in T-SQL to read updated rows that haven't been commited yet...

    Yes, it can be used to read them, but 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

    May 17, 2010 at 1:02 am

    #1168122

  • RE: Blocking Issue?

    Jeff Moden (5/16/2010)

    GilaMonster (5/16/2010)

    mike 57299 (5/16/2010)

    I have tested this issue by issuing an INSERT command in the command window. It hangs until I use the task manager to kill...

    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

    May 16, 2010 at 4:43 pm

    #1168073

  • RE: Stored procedure gives no compilation error but gives a run time error

    btw, this is one of the reasons why, when doing a SQL 2000-2005 upgrade (which I assume is what you're doing), you should be doing end-to-end testing 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

    May 16, 2010 at 3:23 pm

    #1168064

  • RE: Blocking Issue?

    mike 57299 (5/16/2010)

    * Trigger on queue causes small exe to fire that will populate an order with all the extra stuff needed into the normal order_hdr and order_dtl files.

    * Since...

    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

    May 16, 2010 at 3:17 pm

    #1168062

  • RE: Stored procedure gives no compilation error but gives a run time error

    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

    May 16, 2010 at 3:15 pm

    #1168061

  • RE: Blocking Issue?

    mike 57299 (5/16/2010)

    I have tested this issue by issuing an INSERT command in the command window. It hangs until I use the task manager to kill the exe process....

    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

    May 16, 2010 at 3:14 pm

    #1168060

  • RE: Blocking Issue?

    A trigger executed within the transaction that fired it. The transaction is not committed, and hence the locks are not released, until the trigger completes. Hence, if another connection (like...

    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

    May 16, 2010 at 2:08 pm

    #1168053

  • RE: Stored procedure gives no compilation error but gives a run time error

    This is called deferred name resolution. If, while creating/altering a stored procedure, SQL encounters a table/view/procedure that does not exist, it skips over that name, assuming that the object will...

    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

    May 16, 2010 at 2:03 pm

    #1168051

  • RE: Sample database design, development, test and deployment for an online student class.

    I suggest you make it clear to them that you are not familiar with database design and that your skills are around the writing of queries.

    If they ask you to...

    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

    May 16, 2010 at 8:16 am

    #1168011

  • RE: Clarification on Tail log bkp

    From Books Online: (emphasis mine)

    Backing up the tail of the log

    Like any log backup, a tail-log backup is taken by using the BACKUP LOG statement. We recommend that you take...

    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

    May 15, 2010 at 1:53 pm

    #1167956

  • RE: Looking for Ideas / Topics for Bachelor Thesis

    May I suggest some time with your favourite search engine. See what people have written about, see what people are asking about. If nothing else, it should spark some ideas.

    As...

    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

    May 15, 2010 at 1:11 pm

    #1167953

  • RE: Getting error 'Must declare the variable '@rc'.

    Yeah, but that doesn't allow for a where clause.

    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

    May 15, 2010 at 7:10 am

    #1167912

  • RE: Sample database design, development, test and deployment for an online student class.

    Irfan-358189 (5/14/2010)

    I am sorry If i have asked more than i should.I just want a step by step documentation to how to design and develop database.

    A step-by-step document? There are...

    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

    May 15, 2010 at 3:14 am

    #1167892

  • RE: suspect database after san failure

    Sunil Padarath (5/15/2010)

    Hi Gail

    in my test instance i have managed to changed the db status to mergency. this i was able to do so by putting the instance into single...

    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

    May 15, 2010 at 3:04 am

    #1167891

  • RE: More, More, More

    Jeff Moden (5/14/2010)

    Cory E. (5/14/2010)

    Jeff Moden (5/14/2010)

    3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely...

    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

    May 14, 2010 at 3:32 pm

    #1167802

Viewing 15 posts - 32,851 through 32,865 (of 49,552 total)