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!
Moderators, please add any other tips you may have.
Including T-SQL, C#, VB.Net Source Code(Thanks to Phil Brammer 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.
Not using the code block editor:
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)
Using the Editor:
(Thanks to Kalman Toth for these instructions.)
Use the Forum Editor method to Insert Image:
1. Save the image to disk
2. Use the Insert Image (right most) icon to upload the image
(Thanks to Todd McDermid for this tip)
- Copy your screen to the clipboard (ALT-PRTSCN) (alternatively, some image editors can do screen captures)
- Paste it in your favourite image editor
- Upload it to a free image hosting site like Flickr, ImageShack, ...
- Create your post, then press the "HTML" button on the post toolbar. This will open another browser window with HTML in it.
- Find the spot where you want the image, and add a standard IMG element, pasting in the URL to your image, like this:
- 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.
Check here to see if there is a suggestion that can guide you to a solution for your problem.
If you find that the Wiki provided you with useful informtion, please let us know by posting a synopsis of your problem and a comment about your successful use of that information.
Credit to Arnie Rowland
“Top Solution Content” blog
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!
Credit to Elvis Long
01 Desember 2009 22:19Moderator
Some guidelines from Clifford Dibble...When you post questions here, please strive to:
a) Post the simplest possible repro. Please do some up-front debugging and detective work, and post the narrowest possible repro. It's not helpful if you post 5 pages of code.
b) Post the DDL of your schema so that we know the data types, NULL-ability, and constraints.
c) Please indicate exactly which version and SP of SQL Server you are using.
d) Please indicate any additional info that may be useful, e.g., perf counters, SQL error log messages, NT event log messages, etc.
e) Provide the text query plan if needed.
Thanks20 Mei 2013 14:34Pemilik
From Kalman Toth...
Spanish Language Posting
This is an English language forum. You can use the following machine translators from Spanish to English:
Similarly, machine translation to English is available in the Bing Translator
Thanks.20 Mei 2013 14:38Pemilik