Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Asking a SQL Question

I've been a little surprised lately by some of the questions I've seen in our forums at SQLServerCentral.com with questions that weren't questions. I've seen people post things that make it hard for people to help them. Among those items:

  • statements, and never really ask a question.
  • An error message or partial error with no context.
  • Broad questions like "What do I need to watch out for when upgrading to SQL Server 2005?"
  • Posting a question you got asked and nothing else.
  • Advertisements - I delete these, even in response to a question if they don't apply.

Jeff Moden wrote a great article on Forum Etiquette that I've tried to rerun and point out to people so they can better frame what they need to post.

There isn't a set of things I can say you always need to post, but you really should think about your question for a minute and post what's appropriate. Imagine that most of us don't understand your context, so we need to know the version (pay attention to where you're posting), and some information about what is happening. It helps to see your observations of the system or the code you've tried and also what happened that you didn't want.

The one thing that always bugs me is someone giving me a test question. Or interview or some other question they got asked and they haven't done any work. I had someone do this recently, actually it happens regularly, but this person posted a question with no code. I gave a few hints and asked them to try, saying that I didn't want to give answers to questions. They responded with "this is not a test question"

OK, maybe it's not. I'm not assuming that it is, but just that it appears to be and the posted didn't show any work. I tried to explain that and hoped that no one else just posted the code. I can appreciate that you sometimes need a code answer, but if you haven't tried anything, it looks like you're lazy and not intersting in doing work. Or that you want a good grade. If you're willing to post a test question, wouldn't you be willing to lie and say it isn't?

The bottom line is that I enjoy helping people and try to do so, but I'm not interested in feeding people, I'm interested in teaching them to fish.

 

 

Comments

Posted by Sumit Rana on 10 July 2012

Hi All,

  Suppose i have two log files in tempdb. 1st file has filled completely and second log file in use. so if i delete second log file then what will happen about the data in second log file.where it will go.

Thanks

Sumit Rana

Posted by rachana.libra on 16 March 2013

Hello Everyone,

I have table of Attendance of Employee.

ATNSHT_ID (Attendance ID)

ATNSHT_ATTEN_DATE(Attendance  Date)

ATNSHT_EMPLOYEE (Employee)

ATNSHT_IN_TIME(In-time)

ATNSHT_OUT_TIME(Out-time)

ATNSHT_TOTAL_HRS(Total Hours)

ATNSHT_ATT_STATUS(Status means Absent(A) or Present(P))

I am using SQL server 2008 R2

I want to create an SP which display the Employee Attendance ,When i enter the particular month and year.

The result I want is Employee Name in Row and Month Days in Column and in that column A for Absent and P for Present .

Please Can anyone help me???

Posted by Bobby105 on 24 June 2013

how to apply distinct on varchar datatype column among int columns

Posted by Steve Jones - SSC Editor on 24 June 2013

If these are real questions, please post them at www.sqlservercentral.com/forums. The comment space here is for comments on the piece, not asking questions on SQL Server.

Of these questions, Sumit's questions is not bad. Bobby105's is poorly worded without enough information and no attempt. Rachana's question isn't bad, but you should include real DDL, not descriptive information and you should have attempted something and shown results, along with what is wrong with the results.

Leave a Comment

Please register or log in to leave a comment.