| Author |
Topic |
|
spirit1
Cybernetic Yak Master
11752 Posts |
 Posted - 2007-12-12 : 07:59:11
|
| We're having an ASK the Expert day on Tuesday the 18th december.i was asked to prepare a few tough SQL question.The expert is Dejan Sarka, Sql Server MVP and a very smart guy.any suggestions?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-12 : 08:06:35
|
maybe you can pick some from SQLTeam where replies = 0 ? 
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 08:06:38
|
In what area? Administration or development?Is it possible he can see this toic and prepare accordingly? 
E 12°55'05.25"N 56°04'39.16" |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-12 : 08:12:16
|
| IMHOAsk the expert day should be for your benefit, so you should be looking for questions that can solve your own sql problems - or enhance certain areas of your system at your place of work. It's not going to be as beneficial if you ask him other peoples questions, now would it?Duane. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-12 : 08:22:39
|
| @peso:probably more dev oriented.@ditch:i don't have any problems at work, that's my problem _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-12 : 08:28:16
|
| Ha! Ha! Spirit - you and me Both Duane. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2007-12-12 : 18:19:27
|
| Also, id love to hear how an expert might approach the problem of tracking user activity in a system where a common login is used (webuser).Short of passing in a UserID to every procedure in place, I dont see a clean way of implementing this directly at the db level. Ive seen some articles where developers have tried to leverage context_info or spid-based solutions, but of course connection pooling makes this complicated.http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124652Nathan Skerl |
|
|
|
wskanaan
Starting Member
2 Posts |
Posted - 2007-12-13 : 02:42:58
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94160 |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-13 : 05:58:03
|
| the tough question is who?????????/is causing trouble since 1980???????????am i correct?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-13 : 05:59:17
|
| there's a simple answer to that...I'm causing it _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-13 : 06:17:40
|
quote:
Originally posted by spirit1
there's a simple answer to that...I'm causing it _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
ok then....the tough question for you...which is first? egg? or chicken?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-13 : 07:02:56
|
between spirit1 and ditch, they have all the answer 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-13 : 07:39:00
|
| of course! toghether we count as one _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-12-13 : 09:30:44
|
| How about how to clean up a database? We have Sharepoint Teamsites here that have not been accessed for 2 - 4 years, but when you ask the user about them, they invariably say "That's vital information! Don't delete it!". |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-12-13 : 09:37:59
|
quote:
Originally posted by mcrowley
How about how to clean up a database? We have Sharepoint Teamsites here that have not been accessed for 2 - 4 years, but when you ask the user about them, they invariably say "That's vital information! Don't delete it!".
Just delete the old data.If anyone complains, tell them you know nothing about it, and suggest it must have been something they did.CODO ERGO SUM |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-12-13 : 09:57:29
|
| Tell them you're going to do it in one month and they must send you a list of all the things they need. You will get no responses. Then pull the plug and see who screams!Jim |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-13 : 12:52:19
|
| ok now we can also talk about administration and warehousing..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-12-13 : 13:20:07
|
quote:
Originally posted by jezemine
hard problems? implement the solution to all of these in SQL: http://www.claymath.org/millennium/
elsasoft.org
Those are tough. The only one I have been able to solve so far is the Riemann Hypothesis.CODO ERGO SUM |
|
|
|
Next Page
|
need some tough SQL questions