POSTING TIPS - source code, screen images, details within...

Question

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.

 

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

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

 

Using HTML:

(Thanks to Todd McDermid 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.

---

Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

Answer 1

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.

Thanks

---

Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

Answer 2

From Kalman Toth...

 

Spanish Language Posting

This is an English language forum. You can use the following machine translators from Spanish to English:

http://www.spanishdict.com/translation

http://www.bing.com/translator 

Similarly, machine translation to English is available in the Bing Translator

Thanks.

---

Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!