Post reply

Not sure with this

  • July 21, 2010 at 4:29 am

    #103958

    Good day to all,

    I'm not sure where to put this inquiry. And here it goes, When I execute a command in SQL Server 2000 for example

    SELECT * FROM tblName.

    Is there a way for me to know of how SQL Server get the data from the table? I mean the architecture behind when that script was executed? And also, Is there a buffer that sql server use for the output? If there is, What kind of buffer is that?

    Honestly I'm not a DB expert, But I need this information for my project. If anyone could give article/website/information that will help me on this inquiry, please let me know.

    Thank you in advance

    Martin

  • July 21, 2010 at 5:55 am

    #1196083

    Martin one of the things you can do to get a better look at what SQL is doing behind the scenes is to look at either the Estimated Execution Plan or the Actual Execution Plan;

    each functionality has a button to activiate it in SSMS; it shows you a graphical representation fo how SQL thinks it will get (or actually got) the data related to the query. complex queries can have a lot of stuff in them.

    Is that what you were after? give us some more detaisl if that's not what you were looking for.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 22, 2010 at 1:46 am

    #1196664

    Thanks for the reply, I think this will be a good start on my research in doing the project. But is there documentation for technical details for the output of the execution plan?

    Thank you very much

    Martin

  • July 22, 2010 at 3:08 am

    #1196700

    this is a good start

    http://msdn.microsoft.com/en-us/library/ms191158.aspx

  • July 22, 2010 at 6:04 pm

    #1197282

    Thanks to all, I'll just study this information that you've given. I'll just post questions for something I dont understand.

    Thank you

    Martin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply