SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 10/03/2006 :  09:58:14  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 10/03/2006 :  10:06:25  Show Profile  Visit spirit1's Homepage  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 10/03/2006 :  10:15:38  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22761 Posts

Posted - 10/03/2006 :  10:15:45  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
>>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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 10/03/2006 :  10:17:26  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/03/2006 :  10:41:05  Show Profile  Reply with Quote
"Rain Man"

I saw this savant piano player on the telly the other day. Utterly astonishing. I need a Savant SQL'er !

Kristen
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 10/03/2006 :  10:53:23  Show Profile  Reply with Quote
quote:
Then I will be the first person granting him asshattery and beyond any help.


Saint Peso, bestower of the asshat.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/03/2006 :  11:30:44  Show Profile  Reply with Quote
It is fairly obvious funketekun = gongxia649

Notice how funketekun complains on this thread
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72923
about people being made fun of on this thread
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56195&whichpage=3
even though it is gongxia649 who way being kidded there.




CODO ERGO SUM
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 10/03/2006 :  11:38:22  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17650 Posts

Posted - 10/03/2006 :  11:49:09  Show Profile  Reply with Quote
anybody notice the updated profile http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=21160


KH

Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/03/2006 :  11:57:19  Show Profile  Reply with Quote
"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
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22761 Posts

Posted - 10/03/2006 :  11:57:42  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Very lengthy Bio

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/03/2006 :  12:08:35  Show Profile  Reply with Quote
quote:
Originally posted by khtan

anybody notice the updated profile http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=21160


KH





Picture actor of Hugh Jackman.



CODO ERGO SUM
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/03/2006 :  12:31:18  Show Profile  Reply with Quote
Is that Hugh Jarse's cousin?
Go to Top of Page

pootle_flump
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 10/03/2006 :  12:49:18  Show Profile  Reply with Quote
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.
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 10/03/2006 :  13:10:22  Show Profile  Reply with Quote
quote:
Originally posted by Kristen

Is that Hugh Jarse's cousin?



you really need a Hugh Jarse to make a save like that




-ec
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/03/2006 :  15:00:53  Show Profile  Reply with Quote
"It is fairly obvious funketekun = gongxia649"

Profile recently updated:

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=22712

Non existent home page ...

Kristen

Go to Top of Page

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 10/03/2006 :  15:34:02  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
this will be one to watch:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72937

A nice very specific question ....

- Jeff
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/03/2006 :  15:44:47  Show Profile  Reply with Quote
Jogging?

I call it running around

http://www.margaritaville.com/lyrics_beachhouse.php



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 10/11/2006 :  00:51:42  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Who introduced the word "ungrateful" here?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73321


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000