| Author |
Topic |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2006-08-31 : 08:53:26
|
Is it just me, or has the usage of DYNAMIC SQL just went through the roof?  Peter LarssonHelsingborg, Sweden |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-31 : 09:37:49
|
| It's cyclical.Odd but you seem to get a lot of unrelated questions on the same topic.Translaction log filling upDynamic sqlaudit trailsdisk space estimationClusteringTrees......Some of it's probably due to homework but it's odd.It's almost as though a load of managers will see something on a site and ask their developers about it who will all post the questions here.Could just be that a lot of companies have the budget to start new projects at the same time and the developers are all out of their depth.Dynamic sql could be due to redeveloping systems in .net and v2005 - the old systems been working happily for some time and the people who knew what they were doing are no longer invloved.Also with v2005 I suspect a lot of managers don't realise the principles are still valid and are hiring people who have read a v2005 book rather than have 10 years experience in sql server.Who would you take - the cheap person with 6 months v2005 experience or 5 years v2000 at twice the rate - and who would you put in charge.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-31 : 09:44:19
|
I consider that as a retorical question  Peter LarssonHelsingborg, Sweden |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-31 : 09:59:11
|
| It should be but unfortunately isn't.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2006-08-31 : 11:59:24
|
quote:
Originally posted by Peso
Is it just me, or has the usage of DYNAMIC SQL just went through the roof? Peter LarssonHelsingborg, Sweden
Infrequent poster but regular reader. I was just thinking exactly the same thing. Funny thing is - not so much over at DBforums. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-31 : 20:20:32
|
When you google for Dynamic SQL, SQLTeam comes up as no 3 & 4. And the top 2 is www.sommarskog.se/dynamic_sql.html. Strange why the posters did not go for this site but SQLTeam ? We will refer them to that site anyway 
KH |
|
|
|
pootle_flump
1064 Posts |
Posted - 2006-09-01 : 03:13:25
|
quote:
Originally posted by pootle_flump
Funny thing is - not so much over at DBforums.
Turns out I am wrong. This one is a bit of a beauty - it could yet beat your own prodigal son OBINNA_EKE:http://www.dbforums.com/showthread.php?t=1607497 |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-09-01 : 04:04:27
|
| It's amazing what you can learn about people from Googling around a bit. Take OBINNA_EKE for example...steve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-01 : 05:04:38
|
" It's amazing what you can learn about people from Googling around a bit"This is amazing. I did a google on elwoos and came out on top is "GameKnot: chess player elwoos (from United Kingdom)"What is more amazing is you have played 1262 games of chess ?
KH |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-01 : 05:39:26
|
and he lost most of them Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-01 : 06:01:49
|
Oh that too. The amazing part is assuming he spend one hour per game that is 1262 hours glueing to screen, thinking of moves, strategy, pulling hairs etc.
KH |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-01 : 06:12:26
|
| well my personal score against him is:10 wins, 7 losses, 1 drawbut i'm comimg up to the 8th loss slowly Chess can be a very relaxing thing if you want it to be Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-09-01 : 06:44:54
|
Yes, it didn't take long to realise that my last post wasn't a wise one! quote:
The amazing part is assuming he spend one hour per game that is 1262 hours glueing to screen, thinking of moves, strategy,
You obviously didn't look at my rating ([url]http://gameknot.com/rating_graph.pl?elwoos[/url] for those sad enough to be interested)! I think you're assuming a considerably greater level of skill than is actually there quote:
pulling hairs etc.
That's why I'm bald! I've worked hard to lose that many games-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-01 : 09:13:16
|
" It's amazing what you can learn about people from Googling around a bit"WARNING ! Don't google for Kristen. We have to give the man some respect. Everybody in some way has some deep secret that should be kept as a secret.
KH |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2006-09-01 : 18:47:22
|
| Once upon time I won a chess program in 11 moves!It was delicious!======================Let me hug & kiss you... |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2006-09-01 : 18:54:53
|
This one: ======================Let me hug & kiss you... |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2006-09-01 : 18:57:13
|
| Chemical Brothers - Hey Boy, Hey Girl.mp3Sounds great....======================Let me hug & kiss you... |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-09-04 : 03:25:00
|
| Maybe Dynamic SQL should be renamed to Lethargic SQL people may be less interested in it thensteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-09-04 : 03:25:32
|
| And Cursors should be called Slugs toosteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 03:29:23
|
| I thought Landmines where a named suggested earlier? Peter LarssonHelsingborg, Sweden |
|
|
|
|
Dynamic SQL