Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 34,486 through 34,500 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

GilaMonster (2/27/2012)
Koen Verbeeck (2/27/2012)
I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, I would've already kicked him out.
Pre-interview technical test maybe.

As much as I would like to go skiing, I haven't been on the slopes since 1981.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Post bug bit me but I'm not going to try and fix it using my phone.

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 3

Lynn Pettis (2/27/2012)
Post bug bit me but I'm not going to try and fix it using my phone.

I like it as is, very Dadaist.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

LutzM SSC Guru Points: 107049 More actions · Answer 4

Koen Verbeeck (2/27/2012)
..
This one obviously is (on another site):
interview questions
...
I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, I would've already kicked him out.

Here are my first 5 answers:

1a) I'm sorry, that's confidential.

1b) Latest backup or point in time recovery (depending on the recovery mode)

2) We're not allowed to accept any presents. Not even clustering ones.

3) It depends. Please be more specifc.

4) (use AWE): Nowadays in most environments not at all. Either due to the 64bit system or simply because it's deprecated.

5) It depends. Please clarify.

Would I be allowed to stay? 😛

Edit: Bonus answer:

20) I've never been at Saragate[/url]. Therefore, I don't know the key.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 5

LutzM (2/27/2012)
Koen Verbeeck (2/27/2012)
..
This one obviously is (on another site):
interview questions
...
I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, I would've already kicked him out.
Edit: Bonus answer:
20) I've never been at Saragate[/url]. Therefore, I don't know the key.

Ah, yes, Mr. Lutz. Good answer.

<Steve, this is one of those rubes pretending to be a real SQL Server user. If he were a real one, he'd have the key and know about our conspiracy. Should we eliminate his access, or remove his existence?>

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

LutzM SSC Guru Points: 107049 More actions · Answer 6

So, is SaraGate a new name for RedGate? :unsure:

And, thank you, Brandie. Now I know there's a key required. So the area seems to be locked. I'll keep asking questions from time to time to get more details. First step to uncover the conspiracy succeeded.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

GSquared SSC Guru Points: 260824 More actions · Answer 7

LutzM (2/27/2012)
So, is SaraGate a new name for RedGate? :unsure:
And, thank you, Brandie. Now I know there's a key required. So the area seems to be locked. I'll keep asking questions from time to time to get more details. First step to uncover the conspiracy succeeded.

Oh c'mon!

EVERYBODY knows that the first rule about conspiracies is SOMEONE outside the conspiracy has to know about it. How else would we keep the world paranoid?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 8

Jeff Moden (2/25/2012)

It'll be so close that I can ride my unicycle to work without having to powder for chaffing. 😀

This is a YouTube video just WAITING to happen. 😀

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

LutzM SSC Guru Points: 107049 More actions · Answer 9

Evil Kraig F (2/27/2012)

Jeff Moden (2/25/2012)
It'll be so close that I can ride my unicycle to work without having to powder for chaffing. 😀
This is a YouTube video just WAITING to happen. 😀

Photo already taken 🙂

Source:google

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 10

Ah yes, those Detroit cacti are a real pain...

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 11

Has anyone implemented an ENDOFTIME()/BEGINNINGOFTIME() pair of functions before? taking a date and a period, returning the start/end of said period? Read an article from Itzik which mentioned such a thing, gave it a shot, but I'm annoying myself with implementation. Using Dynamic SQL to build something to allow for each period, but can't execute within a function (or don't know how), so end up just generating the string that still needs executed.

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

LutzM SSC Guru Points: 107049 More actions · Answer 12

jcrawf02 (2/27/2012)
Ah yes, those Detroit cacti are a real pain...

I guess you're not referring to those on the ground, are you? 😀

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 13

jcrawf02 (2/27/2012)
Has anyone implemented an ENDOFTIME()/BEGINNINGOFTIME() pair of functions before?

Not exactly, I wrote a bunch of period start and end functions (day, week,month, quarter, year) functions a while back. Suppose you could use them in a set of IF statements. Not elegant but...

http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/

Please note that code is ancient.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

TomThomson SSC Guru Points: 104773 More actions · Answer 14

LutzM (2/27/2012)

Evil Kraig F (2/27/2012)
Jeff Moden (2/25/2012)
It'll be so close that I can ride my unicycle to work without having to powder for chaffing. 😀
This is a YouTube video just WAITING to happen. 😀
Photo already taken 🙂

One of those newfangled two-wheeled unicycles, I guess.

Here's one with an old-fashioned one-wheeled unicycle (courtey of utube, via the daily record and google, - original is http://www.youtube.com/watch?v=ZbfD9OKwqBs&feature=player_embedded about 18 seconds in).

Tom

GSquared SSC Guru Points: 260824 More actions · Answer 15

jcrawf02 (2/27/2012)
Has anyone implemented an ENDOFTIME()/BEGINNINGOFTIME() pair of functions before? taking a date and a period, returning the start/end of said period? Read an article from Itzik which mentioned such a thing, gave it a shot, but I'm annoying myself with implementation. Using Dynamic SQL to build something to allow for each period, but can't execute within a function (or don't know how), so end up just generating the string that still needs executed.

I think I'd bypass the runtime-math on it entirely and just build a calendar table with it all pre-calculated. But then, I already have such a table, so that's easy for me to say.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon