Forum Replies Created

Viewing 15 posts - 40,561 through 40,575 (of 49,552 total)

  • RE: Need help Urgent.. SP executing long time.. Whats wrong in this ?

    CH&HU (3/4/2009)

    IF EXISTS (SELECT * FROM sysobjects WHERE type = 'T' AND name = '#tmpDataSource') ...

    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

    March 5, 2009 at 2:03 am

    #953843

  • RE: Is there a way to select all columns except one or two columns?

    No worries. Please in future explain the entire problem up front.

    What are you still having a problem with?

    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

    March 5, 2009 at 1:54 am

    #953842

  • RE: Need help Urgent.. SP executing long time.. Whats wrong in this ?

    I'd suggest, to start, run the proc with Statistics Time and Statistics IO on and find out where the slow pieces are and then focus on the pieces that 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

    March 5, 2009 at 1:34 am

    #953835

  • RE: REBUILD INDEX DOES NOT REMOVE FRAGMENTATION

    mrhassell (3/4/2009)

    SAN is a 'storage area network', which is great for storing backups, but running production databases from such a complicated environment is bad practice.

    It is? You have any...

    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

    March 5, 2009 at 1:22 am

    #953830

  • RE: Are the posted questions getting worse?

    Derek Dongray (3/4/2009)

    Did anyone else bother to look at the other posts?

    Yes I did. None of the others I tested are exact copies from elsewhere.

    Basically, it seems you can 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

    March 5, 2009 at 12:55 am

    #953824

  • RE: differential Backup

    peace2007 (3/4/2009)

    Thanks Gail. That might be the problem, I'm sure developers take backups in between I have to ask them to do that with my coordination.

    Why do developers have...

    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

    March 5, 2009 at 12:54 am

    #953823

  • RE: Is there a way to select all columns except one or two columns?

    Santhosh (3/4/2009)

    Hi Gail,

    In the Remarks section I found the below statement

    Remarks

    The tablediff utility cannot be used with non-SQL Server servers.

    I'm Comparing a table of Access database(Linked Server) with...

    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

    March 5, 2009 at 12:37 am

    #953818

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/4/2009)

    Doesn't matter, our friend didn't even do a good job of copying & pasting. He reversed things that Brad had posted, such as the order in the WHERE...

    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

    March 4, 2009 at 3:22 pm

    #953652

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/4/2009)

    It looks like it was all pulled from Brad Magehee. I reported it to him via Twitter. No response yet.

    I doubt Brad wrote all of those. He knows...

    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

    March 4, 2009 at 1:48 pm

    #953574

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/4/2009)

    I don't know if they have a method of reporting on this guy or not.

    Yup, and after what I just found, I'm going to. Just need 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

    March 4, 2009 at 1:36 pm

    #953560

  • RE: Are the posted questions getting worse?

    Derek Dongray (3/4/2009)

    The items I did find suspect were from reading his blog, in particular a list of SQL query performance tips with no explanation as to why any 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

    March 4, 2009 at 1:33 pm

    #953555

  • RE: I need this Values

    souLTower (3/4/2009)

    Gail, I'm confused as to why to use the datediff function.

    The dateadd/datediff is a trick to 'truncate' a data to a certain precision (day, week, month, year)

    In the one...

    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

    March 4, 2009 at 1:05 pm

    #953538

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (3/4/2009)

    No offense, but if all that is required is put up a crappy blog with unverified recommendations, I can be an mvp in 7 days with 50$ out 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

    March 4, 2009 at 12:21 pm

    #953505

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/4/2009)

    I've got a poster that I really don't know how to help.

    http://www.sqlservercentral.com/Forums/FindPost668188.aspx

    Sorry, can't help you there.

    Check agent error logs?

    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

    March 4, 2009 at 12:04 pm

    #953490

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/4/2009)

    I've been running a loop of "I love living in the city" by the Fear in my head for days now, so, I'd almost welcome the Star Wars...

    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

    March 4, 2009 at 11:55 am

    #953479

Viewing 15 posts - 40,561 through 40,575 (of 49,552 total)