August 24, 2011 at 7:56 am
Hi Guys,
I know it, the question is Funny, but i just wondering the SQL system workout, how the data is populated and placed to the grid, it is holding in memory and then one by one, Means row by row and column by column data is placeing in grid control,
How we are Binding data in ASP or Vb, the same thing is happening in SQL Server? if yes please give me some articles to research it's system
Thanks in Advance
Patel Mohamad
August 24, 2011 at 8:15 am
I don't understand your question, sorry.
What do you mean with "grid"?
Can you please clarify, possibly with an example?
Thank you
Gianluca
-- Gianluca Sartori
August 24, 2011 at 8:18 am
SQL Server doesn't care what the client does with the data. It'll send the data to the client what happens after that is on the client side and the database engine is unaffected.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2011 at 8:04 am
I think the OP is asking how does SSMS handle the data before it displays the results in the output window? In this case SSMS IS the client so it doesn't matter really. SSMS is just an application that connects to your sql server and consumes the data just like your asp.net application.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 30, 2011 at 12:50 am
Hi Sean,
Agree with you but in Asp.Net application we holds the data in DataTable,List or Dataset Basically the Data holder and then display in grid, my question is same for SQL server where the data is stored? before displaying in grid.
Thanks,
Patel Mohamad
August 30, 2011 at 3:24 am
patelmohamad (8/30/2011)
Hi Sean,Agree with you but in Asp.Net application we holds the data in DataTable,List or Dataset Basically the Data holder and then display in grid, my question is same for SQL server where the data is stored? before displaying in grid.
Thanks,
If you're talking about SQL Server Management Studio (SSMS), probably it's implemented with something similar (it's a .NET application, after all).
However, this has nothing to do with how data is stored internally in the RDBMS (SQL Server).
-- Gianluca Sartori
August 30, 2011 at 3:41 am
patelmohamad (8/30/2011)
Hi Sean,Agree with you but in Asp.Net application we holds the data in DataTable,List or Dataset Basically the Data holder and then display in grid, my question is same for SQL server where the data is stored? before displaying in grid.
SQL doesn't store the results of queries. It computes them, sends them to the client, what the client app does it solely it's concern.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply