Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2011-03-09 : 02:49:26
|
| i have BI server, every night i extract 2 month ago from DB2.how can i know how many giga i extract?i know the rows,can i tranlate it to size of giga? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-09 : 04:06:58
|
| Well...you can look at the data types, add the byte size for all the columns for one row and then multiply that by the number of rows.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2011-03-09 : 06:28:14
|
| Is query for that?find the size of the row? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-09 : 06:48:22
|
| No, you will need to use Books Online and look up the documentation for the different data types -> http://msdn.microsoft.com/en-us/library/ms187752.aspxHow accurate do you need it to be? You'll face problems calculating this accurately if you have variable length columns like varchar in your dataset. A varchar column with the value "lumbago" will take up 7+2 bytes of storage while the same column with the value "inbs" will only take up 4+2 bytes.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
|
|
|
how many giga i extract