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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-09-26 : 04:47:30
|
| dear experts,i heard in a session, that the tables which are modifying continuously are known as dynamic tables.and which are not are known as static tables.my question is how to find the statics to judge static and dynamic tables? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-26 : 06:40:49
|
| There is no benchmark to decide which is dynamic table and which is static one..You just have to see at the the frequency at which the table is updated to know whether it is dynamic or static.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-09-26 : 07:17:57
|
| Dear harsh,checking the frequency means??select count(*) from that table?how frequently is the table changing or like that? |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-26 : 07:30:11
|
| Its means, how frequently DML(Update,Delete,Insert) statments are getting fired on that table..the one way to do is via SQL Profiler and maitaining the log file of it..Chirag |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2006-09-26 : 15:23:31
|
| Well, I know of 4 table typesPermanent TableTemporary TableTable VariablesDerived Tables(Does an output of a function count as a derived table?)In any case I've never heard of a dynamic table (well I guess all tables are dynamic)In any case, what's the question. Which one performs better than the other? The answer is it depends. Do you have a specific case you want us to measure against them to tell you which one we think would perform better.Do you have SQL Server Client tools installed? If so, start up Books Online and start reading. It's very useful.Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|
|
static and dynamic tables