sticky
POSTING TIPS - Code, Images, Hyperlinks, Details

    General discussion

  • When you're posting a question - please search the forum first!  If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below.  If you want to show us what you see on your screen (pictures are worth a thousand words), see below! Check that a URL does not stay black/gray indicating an inactive hyperlink. All URL references should be blue and clickable.
    Moderators, please add any other tips you may have.

    Including T-SQL, C#, VB.Net Source Code

    (Thanks to Phil Brammer & Kalman Toth for this tip)
    When you are composing a post and you wish to paste code, please don't directly paste it into the post, instead paste it into the code block editor.  It will preserve formatting for you, which makes it easier for us to read it and help you with your issue.



    Examples follow...

    Not using the code block editor:

    select
    text, *
    from sys.dm_exec_cached_plans
    cross apply sys.dm_exec_sql_text(plan_handle)


    Using the code block editor (and with the same copy-n-paste buffer):

    select 
    text, *
    from sys.dm_exec_cached_plans 
    cross apply sys.dm_exec_sql_text(plan_handle)

    Including Images

    Using the Editor:

    (Thanks to Kalman Toth for these instructions)

    Use the Forum Editor method to Insert Image:

    1. Save the image to disk or copy the image URL

    2. Use the Insert Image (right most) icon to upload the image

    Make sure the URL hyperlink is active:

    The forum post editor automatically hyperlinks a typed URL in IE. But not all browsers do it.

    Use the chain link icon to hyperlink an inactive URL, title or reference.

    Using HTML:

    (Thanks to Todd McDermid & Ed Price for this tip)

    1. Copy your screen to the clipboard (ALT-PRTSCN) (alternatively, some image editors can do screen captures)
    2. Paste it in your favourite image editor
    3. Upload it to a free image hosting site like Flickr, ImageShack, ...
    4. Create your post, then press the "HTML" button on the post toolbar.  This will open another browser window with HTML in it.
    5. Find the spot where you want the image, and add a standard IMG element, pasting in the URL to your image, like this:
      < img src="http://your.url.here/your_image_filename_here">
    6. Press the Update button.


    The Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have created a Wiki to present Solutions to Common T-SQL Problems.

    (Thanks to Arnie Rowland  for this tip)

    Check here to see if there is a suggestion that can guide you to a solution for your problem.

       http://code.msdn.microsoft.com/SQLExamples

    If you find that the Wiki provided you with useful information, please let us know by posting a synopsis of your problem and a comment about your successful use of that information.

     “Top Solution Content” blog 

    (Thanks to Elvis Long  for this tip)

    As part of our efforts to keep our communities informed about the most relevant content that address the top questions that we are getting in out forums and other support channels we want to introduce the new “Top Solution Content” blog (http://blogs.technet.com/b/topsupportsolutions).

    In this blog you will find up-to-date and valuable information about Microsoft top support solutions for several of our popular products in the Server and Tools portfolio. You can use the tags (http://blogs.technet.com/b/topsupportsolutions/archive/tags) to easily locate the product of your preference or visit the home page to see what’s going on for the different Microsoft Enterprise and developer products. As a blog you can also subscribe to post and comments using the RSS feeds.

    We hope this will reduce time and effort when you are looking for relevant content. Enjoy it!




    Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design
    New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014

    Wednesday, March 12, 2014 1:05 PM
    Moderator