| Author |
 Topic  |
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
 Posted - 10/03/2006 : 09:58:14
|
Sort of NZDF. Let him try and use the time spent trying to contemplate on the bad sides of using dynamic SQL.
Or, create a view for every 50 tables (that makes 10 views) and then a SUPERVIEW for the 10 views... What a performance!
Peter Larsson
Helsingborg, Sweden |
Edited by - SwePeso on 10/03/2006 09:59:22 |
 |
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 10/03/2006 : 10:06:25
|
i don't think that would even work... it'd still error out about too many columns. wouldn't it?
Go with the flow & have fun! Else fight the flow 
blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 10/03/2006 : 10:15:38
|
Not a UNION view. The number of columns are the same.
I have seen this recently at my current client. A layer of 3 views on top of each other. Base table is 29 million record table. And they wonder why the query against the top view was slow...
Peter Larsson
Helsingborg, Sweden |
|
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
Posted - 10/03/2006 : 10:15:45
|
>>Or, create a view for every 50 tables (that makes 10 views) and then a SUPERVIEW for the 10 views... What a performance!
What will happen when tables are created daily like MyTable20061002,MyTable20061003,etc? 
Madhivanan
Failing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 10/03/2006 : 10:17:26
|
Then I will be the first person granting him asshattery and beyond any help.
Peter Larsson
Helsingborg, Sweden |
Edited by - SwePeso on 10/03/2006 10:18:34 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 10/03/2006 : 10:41:05
|
"Rain Man"
I saw this savant piano player on the telly the other day. Utterly astonishing. I need a Savant SQL'er !
Kristen |
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 10/03/2006 : 11:38:22
|
Well the mods can determine if they are the same person. Snitz keeps track of IP addresses. It's come in handy in the past.
Tara Kizer |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 10/03/2006 : 11:57:19
|
"She earned her MD at St. Bartholomew?s Medical School, London"
Is the picture before the operation, or was the operation after the bio and before the picture?
Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
Posted - 10/03/2006 : 11:57:42
|
Very lengthy Bio
Madhivanan
Failing to plan is Planning to fail |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 10/03/2006 : 12:31:18
|
| Is that Hugh Jarse's cousin? |
|
|
|
pootle_flump
Flowing Fount of Yak Knowledge
United Kingdom
1064 Posts |
Posted - 10/03/2006 : 12:49:18
|
| So she was hitting on a waitress? She should have mentioned that to the suave lot - they could have got to the nub of the issue quite quickly then. |
|
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 10/03/2006 : 13:10:22
|
quote:
Originally posted by Kristen
Is that Hugh Jarse's cousin?
you really need a Hugh Jarse to make a save like that
-ec |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
|
|
jsmith8858
Dr. Cross Join
USA
7423 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
Topic |
|
Twit List
