Forum Replies Created

Viewing 15 posts - 39,766 through 39,780 (of 49,552 total)

  • RE: Procedure Result as column data ..Need urgent help

    Sorry, I'm not following you. Could you maybe show the procedure and explain a bit more what it currently returns and what you want it to return?

    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 14, 2009 at 1:25 am

    #977056

  • RE: .mdmp Files & What to do with them

    Delete them

    .mdmp file are memory dumps, from when SQL has access violations or other similar errors. If you're getting them currently, call MS's customer support. If they're old and 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

    April 14, 2009 at 1:22 am

    #977055

  • RE: MCTS/MCITP for 2008 or 2005?

    A certification alone without any experience is unlikely to get you anything than a very junior job, if that. The certs are designed for people who have some experience (a...

    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 13, 2009 at 3:26 pm

    #976910

  • RE: Truncate/Delete

    There's a lot more to consider than performance.

    Truncate deletes all the data in the table. Delete can have a where clause allowing conditional deletes.

    Truncate does not fire triggers, delete does.

    Truncate...

    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 13, 2009 at 1:35 pm

    #976853

  • RE: Help me - Count function

    sreddy (4/13/2009)

    select

    user.userid,

    user.name,

    count(news.userid)

    from user

    inner join news on user.userid = news.userid

    group by user.userid,

    user.name

    Why count(userid)?

    j1a4l0: What do you want returned for a user that has no news items?

    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 13, 2009 at 12:54 pm

    #976825

  • RE: Which certification?

    http://www.microsoft.com/learning/mcp/certifications.mspx

    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 13, 2009 at 12:48 pm

    #976822

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/13/2009)

    Um, let's see, 1.5 hrs to Toronto, 6ish hours to Vancouver. But that was in anticipation of a cruise to Alaska, so hardly stressful. Like I said, spoiled rotten....

    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 13, 2009 at 9:04 am

    #976673

  • RE: Fine tuning Indexes.

    Vijaya Kadiyala (4/13/2009)

    These are great articles but i am not able to add any comments 🙁

    I can't help you with that. Mail or PM the Simple Talk people (Tony Davis)....

    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 13, 2009 at 8:46 am

    #976655

  • RE: Select statetment takes forever to return data

    Please post the table design, index definitions and the estimated execution plan (saved as a .sqlplan file, zipped and attached)

    If there query blocked by some other connection?

    Is that SELECT *...

    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 13, 2009 at 8:35 am

    #976645

  • RE: TSQL help needed

    Bob Hovious (4/12/2009)

    But I thought you or Gail said that you couldn't count on anything but a clustered index or an ORDER BY clause to maintain sequence. ...

    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 13, 2009 at 7:36 am

    #976595

  • RE: MCTS/MCITP for 2008 or 2005?

    There's no upgrade exam from 431 to 432. The upgrade is from the 2005 ITP certs to the 2008 ITP certs.

    If you've studied for the 2005 exam, write the 2005...

    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 13, 2009 at 7:30 am

    #976585

  • RE: A severe error occurred on the current command. The results, if any, should be discarded.

    Check the SQL error log, there may be more details there.

    just as a precaution, please run the following for the DB in question (during a quiet time)

    DBCC CHECKDB (< Database...

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

    #976576

  • RE: I cant install the server components

    cmrhema (4/13/2009)

    Thanks for the prompt reply

    But one question(sorry if its too silly),

    should i install

    SQL Server 2005 Express Edition,

    or

    SQL Server Management Studio Express,

    SQL Server 2005 Express...

    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 13, 2009 at 7:22 am

    #976573

  • RE: Are the posted questions getting worse?

    Gaby Abed (4/13/2009)

    Changing planes in Amsterdam is not very stressful, provided you have at least a two-hour layover. I have a sister living there and sometimes, if the layover...

    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 13, 2009 at 7:15 am

    #976557

  • RE: I cant install the server components

    Management Studio Express is, as the name implies, just Management Studio, ie the client components. If you want SQL Server Express Edition, it's a separate download.

    It's on the same page...

    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 13, 2009 at 7:11 am

    #976551

Viewing 15 posts - 39,766 through 39,780 (of 49,552 total)