|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
March 24th, 2004, 02:51 AM
|
|||
|
|||
data amount selected.
Hi all,
is it possible to cout size of data selected form mssql database table for each databse user. Lets say Scott seleceted 100 rows from table tiger which is 50Kb. Could use sample statement  thank You. Janis.
|
|
#2
March 24th, 2004, 07:04 PM
|
|||
|
|||
|
I hope so, maybe in the next version of SQL
but in the meanwhile you can always do a comparaison with the size of you table with this function : sp_spaceused <table name> which will return the number of row & the space your data take (ex: for 500 rows your table takes 10 megs, and you want to know for 35 just do 35/500 *10 megs := 0.7megs) wait a minutes! just turn the Show Client Statistics on in the Query analyzer in the Query menu
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > data amount selected. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
