Forum Replies Created

Viewing 15 posts - 16,651 through 16,665 (of 22,211 total)

  • RE: Row Count in Stored Procedure

    guestuser31 (8/27/2009)


    I have the code below.

    I need the row count to display in the text file but it doesnt. I can see it in my query result.

    How can I get...

  • RE: What are some tips to improve performance of dynamic SQL

    Like Gail said, you can get the execution plan in Management Studio. You can also query the cache through DMV's to look at the execution plan stored there.

    I'd suggest building...

  • RE: Performance Dashboard

    Ryan D. (8/26/2009)


    Hi,

    I have a question regarding the missing indexes section of the performance dashboard. What is the best way to approach the recommended indexes?

    Slowly, maintain eye contact, and carry...

  • RE: Are the posted questions getting worse?

    GilaMonster (8/26/2009)


    K. Brian Kelley (8/26/2009)


    Lynn Pettis (8/26/2009)


    So, what was the question and how did you handle it? I've just started ignoring requests for help sent via PM. I...

  • RE: Operations Manager Custom Collection

    Yep, you found your alias (there is a way to edit that, but I'm not sure what it is). If it saved, you should be there. You mapped the property...

  • RE: Are the posted questions getting worse?

    GSquared (8/26/2009)


    Alvin Ramard (8/26/2009)


    What's worse than OP too lazy to search how to do something simple and asking in the thread?

    OP that send you a PM asking the question.

    I get...

  • RE: Nested Transaction

    What error are you getting?

    BTW, a nested transaction is not one transaction after another. It's one transaction inside another.

  • RE: Operations Manager Custom Collection

    Nah, let's keep it on here. If the article wasn't clear, this can help to explain the issues for someone else.

    No, don't put in the name of a single server....

  • RE: Operations Manager Custom Collection

    j.bradshaw (8/25/2009)


    Thx very much Grant.

    "There is an alias included in the parameter, SqlServer3, that's probably not the same on your system. You'll need to replace this with the appropriate setting...

  • RE: duplicating an sql database

    SQLBOT (8/25/2009)


    Lastly and most cheaply...

    download SQL Toolbelt and use SQL Compare to build your schema & assign appropriate security, then use SQL Data Compare to fill up some...

  • RE: duplicating an sql database

    To selectively move parts of the structure and parts of the data you will have to perform manual tasks to create something that can be transmitted. There are number of...

  • RE: RAISERROR Help

    The problem is in your code, not in the TSQL. You have to be able to retrieve the error message from the error.

  • RE: Improving Site Navigation

    Mel Harbour (8/25/2009)


    Hi all,

    One of the things that we're looking into at the moment involves ways in which we can improve the site navigation. I mean this in the broadest...

  • RE: Operations Manager Custom Collection

    j.bradshaw (8/24/2009)


    This is all a bit scary to me. I was handed Grant's article by one of our DBA's and asked to get this working. :w00t:

    Well, I have several beginner's...

  • RE: Favourite development tools

    I'd suggest the Red Gate Tool Belt for SQL Server. Great stuff, Data compare, SQL compare, SQL Prompt...

Viewing 15 posts - 16,651 through 16,665 (of 22,211 total)