Are the posted questions getting worse?
-
Sean Lange (10/17/2012)
jasona.work (10/17/2012)
Brandie Tarvin (10/17/2012)
dwain.c (10/16/2012)
Jeff Moden (10/16/2012)
... and he couldn't name the function to get the current date and timePerhaps he was so focused on the future he's never interested in the temporal currency. 😛
He's not an "in" member of the SQL Conspiracy, so doesn't know the truth about DBCC TimeWarp. Don't hold it against him.
Wait, I thought DBCC TimeWarp was being deprecated in favor of SP_Flux_Capacitor_1.21GW?
No the new version of DBCC TimeWarp call that as a CLR. 😀
Gives me hope that Jeff will get all worn out from these guys and I'll shine in an interview with him. :w00t::w00t:
-
Hey, as long as y'all stick to the basic questions (How do you spell your name, What is the true meaning of the universe, Demonstrate how to get the wingspan of an unladen swallow), I will pass any interview you throw at me!
Because we all know that 6 * 9 is more important than getting a function for dates and times. @=)
-
Excuse me a moment while I crow again. My new Shadowrun adventure "Sacrificial Limb" (the first book I've written as a solo author) came out last week from Catalyst Game Labs[/url] in PDF (with print pre-orders being taken).
And a few days later, I got my first review[/url]. 4 out of 5 stars, mostly positive. I'm absolutely stoked about the last line which says "...Sacrificial Limb is as much fun to read through as it is to play, and will definitely be a talking point both in the metaplot of the Sixth World and on Shadowrun oriented websites/forums for some time to come."
SQUEE. :w00t:
-
Brandie Tarvin (10/17/2012)
It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace I say.Young fella, do you even know what a chicken hawk is?
😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!
--------------------------------------
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 -
Stefan Krzywicki (10/17/2012)
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!+10,000,000
Just sayin'
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
Brandie Tarvin (10/17/2012)
Excuse me a moment while I crow again. My new Shadowrun adventure "Sacrificial Limb" (the first book I've written as a solo author) came out last week from Catalyst Game Labs[/url] in PDF (with print pre-orders being taken).And a few days later, I got my first review[/url]. 4 out of 5 stars, mostly positive. I'm absolutely stoked about the last line which says "...Sacrificial Limb is as much fun to read through as it is to play, and will definitely be a talking point both in the metaplot of the Sixth World and on Shadowrun oriented websites/forums for some time to come."
SQUEE. :w00t:
Congrats Brandie!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
Brandie Tarvin (10/17/2012)
Excuse me a moment while I crow again. My new Shadowrun adventure "Sacrificial Limb" (the first book I've written as a solo author) came out last week from Catalyst Game Labs[/url] in PDF (with print pre-orders being taken).And a few days later, I got my first review[/url]. 4 out of 5 stars, mostly positive. I'm absolutely stoked about the last line which says "...Sacrificial Limb is as much fun to read through as it is to play, and will definitely be a talking point both in the metaplot of the Sixth World and on Shadowrun oriented websites/forums for some time to come."
SQUEE. :w00t:
Very cool, Brandie. Congrats on the solo flight!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Sean Lange (10/17/2012)
Jeff Moden (10/16/2012)
Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and 5 years recent experience with SQL Server... and he couldn't name the function to get the current date and time in either. The resume also had on it that he had created stored procedures but then admitted that he never really created any... he just supposedly fixed them.It was one of the shortest interviews I've ever conducted with anyone for any job.
Jeff how dare you question somebody about the contents of their resume to see if it is actually true. What is this world coming to?? At least you didn't have to waste much time.
Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending on whether or not is was a reporting database or not, wrote stored procedures and triggers, but couldn't define what normalization is, couldn't explain why he used IDENTITY columns as PK's, insisted that you don't need a unique column on reference tables (enum tables, etc), and adds to the recent collection of "experts" that don't know the name of the function in SQL Server to get the current date and time through T-SQL.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff Moden (10/17/2012)
Sean Lange (10/17/2012)
Jeff Moden (10/16/2012)
Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and 5 years recent experience with SQL Server... and he couldn't name the function to get the current date and time in either. The resume also had on it that he had created stored procedures but then admitted that he never really created any... he just supposedly fixed them.It was one of the shortest interviews I've ever conducted with anyone for any job.
Jeff how dare you question somebody about the contents of their resume to see if it is actually true. What is this world coming to?? At least you didn't have to waste much time.
Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending on whether or not is was a reporting database or not, wrote stored procedures and triggers, but couldn't define what normalization is, couldn't explain why he used IDENTITY columns as PK's, insisted that you don't need a unique column on reference tables (enum tables, etc), and adds to the recent collection of "experts" that don't know the name of the function in SQL Server to get the current date and time through T-SQL.
Ok, I did some digging and think I finally know that answer:
ROLEX
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
Stefan Krzywicki (10/17/2012)
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!I've turned off the automatic updates for just that reason. Annoying at best, disastrous at worst.
Wiindows can remind me and then I do it at my leisure.
My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St -
SQLRNNR (10/17/2012)
Jeff Moden (10/17/2012)
Sean Lange (10/17/2012)
Jeff Moden (10/16/2012)
Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and 5 years recent experience with SQL Server... and he couldn't name the function to get the current date and time in either. The resume also had on it that he had created stored procedures but then admitted that he never really created any... he just supposedly fixed them.It was one of the shortest interviews I've ever conducted with anyone for any job.
Jeff how dare you question somebody about the contents of their resume to see if it is actually true. What is this world coming to?? At least you didn't have to waste much time.
Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending on whether or not is was a reporting database or not, wrote stored procedures and triggers, but couldn't define what normalization is, couldn't explain why he used IDENTITY columns as PK's, insisted that you don't need a unique column on reference tables (enum tables, etc), and adds to the recent collection of "experts" that don't know the name of the function in SQL Server to get the current date and time through T-SQL.
Ok, I did some digging and think I finally know that answer:
ROLEX
That answer is fine as long as you're content that your code will only be accurate to +or- 2 minutes a month.
My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St -
Jeff Moden (10/17/2012)
Sean Lange (10/17/2012)
Jeff Moden (10/16/2012)
Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and 5 years recent experience with SQL Server... and he couldn't name the function to get the current date and time in either. The resume also had on it that he had created stored procedures but then admitted that he never really created any... he just supposedly fixed them.It was one of the shortest interviews I've ever conducted with anyone for any job.
Jeff how dare you question somebody about the contents of their resume to see if it is actually true. What is this world coming to?? At least you didn't have to waste much time.
Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending on whether or not is was a reporting database or not, wrote stored procedures and triggers, but couldn't define what normalization is, couldn't explain why he used IDENTITY columns as PK's, insisted that you don't need a unique column on reference tables (enum tables, etc), and adds to the recent collection of "experts" that don't know the name of the function in SQL Server to get the current date and time through T-SQL.
I think he got a job already: http://www.sqlservercentral.com/Forums/Topic1373679-1292-1.aspx
My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St -
dwain.c (10/17/2012)
Stefan Krzywicki (10/17/2012)
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!I've turned off the automatic updates for just that reason. Annoying at best, disastrous at worst.
Wiindows can remind me and then I do it at my leisure.
I've done it twice. Company-wide settings override it.
--------------------------------------
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 -
SQLRNNR (10/17/2012)
Jeff Moden (10/17/2012)
Sean Lange (10/17/2012)
Jeff Moden (10/16/2012)
Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and 5 years recent experience with SQL Server... and he couldn't name the function to get the current date and time in either. The resume also had on it that he had created stored procedures but then admitted that he never really created any... he just supposedly fixed them.It was one of the shortest interviews I've ever conducted with anyone for any job.
Jeff how dare you question somebody about the contents of their resume to see if it is actually true. What is this world coming to?? At least you didn't have to waste much time.
Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending on whether or not is was a reporting database or not, wrote stored procedures and triggers, but couldn't define what normalization is, couldn't explain why he used IDENTITY columns as PK's, insisted that you don't need a unique column on reference tables (enum tables, etc), and adds to the recent collection of "experts" that don't know the name of the function in SQL Server to get the current date and time through T-SQL.
Ok, I did some digging and think I finally know that answer:
ROLEX
No, no, it is clearly fn_GetTheCurrentDateAndTimeThroughT-SQL(Current)
--------------------------------------
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
Viewing 15 posts - 38,101 through 38,115 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply