Forum Replies Created

Viewing 15 posts - 26,431 through 26,445 (of 49,552 total)

  • RE: Each table in Owner Filegroup

    ulisseslourenco (5/1/2011)

    A coleague of mine was against manager split filegroups in same disk either. He thought to separate a big database table in other disk and partition it is better...

    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 1, 2011 at 8:55 am

    #1318180

  • RE: SQL Insert Trigger

    zayidka (5/1/2011)

    Yes I did make few changes based on your first response thank you. But it seems I ‘ still stack.

    I’m not asking you to do my homework, but 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

    May 1, 2011 at 8:53 am

    #1318179

  • RE: SQL Insert Trigger

    We're not going to do your homework for you. Help and advise, sure.

    Did you read any of my comments? Have you tried to fix the trigger based on those?

    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 1, 2011 at 8:18 am

    #1318172

  • RE: Each table in Owner Filegroup

    ulisseslourenco (5/1/2011)

    In fact, My manager based in split multiple text files in same disk is faster to seek some information than a big file so he thought if you...

    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 1, 2011 at 8:16 am

    #1318171

  • RE: SQL Insert Trigger

    zayidka (5/1/2011)

    I'm basicly trying to create a trigger with variables.

    Triggers shouldn't in general use variables. The modified rows can be found in the inserted pseudo-table. Think about what you want...

    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 1, 2011 at 6:51 am

    #1318157

  • RE: SQL Insert Trigger

    Lots of things wrong with the trigger...

    To start with...

    zayidka (4/30/2011)

    IF (SELECT Due_Amount

    FROM dbo.Student_Bill_Account

    WHERE SID = @sid AND semesterID = @semester) > 0

    BEGIN

    Print 'You can 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

    May 1, 2011 at 4:58 am

    #1318155

  • RE: Waits issues

    Syed Jahanzaib Bin hassan (5/1/2011)

    your database files structure,how many file groups and files places on different physical drives or simple on different partition,tempdb database place,how many files in tempdb database

    None...

    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 1, 2011 at 2:41 am

    #1318148

  • RE: Waits issues

    azhar.iqbal499 (4/30/2011)

    I am currently Confronting too much waits, which are hampering my DB performance. Most prominent waits are CXPACKET, LCK_X and LATCH_EX.

    Interesting collection...

    CXPacket is a parallel skew wait. It comes...

    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 1, 2011 at 2:40 am

    #1318147

  • RE: Each table in Owner Filegroup

    ulisseslourenco (4/30/2011)

    In fact if I move a big table to other filegroup I will gain some performance howerver separating each table I will gain some performance? and same disk?

    Unless 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

    May 1, 2011 at 2:37 am

    #1318146

  • RE: Each table in Owner Filegroup

    Syed Jahanzaib Bin hassan (5/1/2011)

    if you split tables on the same disk but different file group and data on the tables are huge then you should increase the performance 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

    May 1, 2011 at 2:35 am

    #1318145

  • RE: Interviews Part 2

    Please note: 6 year old thread.

    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

    April 30, 2011 at 7:41 am

    #1318063

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (4/30/2011)

    Combined with the Easter Holiday last weekend as well, April is not going to be the most productive month.

    Loads of people took last week off completely.

    Same here....

    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

    April 30, 2011 at 7:02 am

    #1318059

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (4/29/2011)

    Reported a posting (today) as an advetisement and look what I got back.

    I am currently out of the office, I will be back on Tuesday 3rd May.

    If the matter...

    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

    April 30, 2011 at 4:30 am

    #1318055

  • RE: Transaction

    As I said earlier

    GilaMonster (4/25/2011)

    Depends what is done in the transaction and what locks are taken.

    It's not as simple as they can or they can't access the table.

    Locks from insert,...

    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

    April 30, 2011 at 4:28 am

    #1318054

  • RE: What should I be doing with my points?

    No...

    Let me guess, you're tracing batch completed. The statement starts the trace and then completes, hence the trace is running before the complete event fires.

    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

    April 29, 2011 at 6:09 am

    #1317756

Viewing 15 posts - 26,431 through 26,445 (of 49,552 total)