February 27, 2012 at 2:45 pm
GSquared (2/27/2012)
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.
that's a thought.
---------------------------------------------------------
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."
February 27, 2012 at 2:56 pm
GilaMonster (2/27/2012)
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.
Thanks Gail, that's how I'm doing the math, so that part is the same, just trying to make it generic
---------------------------------------------------------
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."
February 28, 2012 at 7:13 am
Anyone for some interview questions, looks like the same ones from DBA.Stackexchange
http://www.sqlservercentral.com/Forums/Topic1258844-146-1.aspx
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
February 28, 2012 at 7:29 am
GilaMonster (2/28/2012)
Anyone for some interview questions, looks like the same ones from DBA.Stackexchangehttp://www.sqlservercentral.com/Forums/Topic1258844-146-1.aspx
Phew! Does this guy actually now ANYTHING?
February 28, 2012 at 8:12 am
Jan Van der Eecken (2/28/2012)
GilaMonster (2/28/2012)
Anyone for some interview questions, looks like the same ones from DBA.Stackexchangehttp://www.sqlservercentral.com/Forums/Topic1258844-146-1.aspx
Phew! Does this guy actually know ANYTHING?
He knows enough to post questions online. That's something. Now if he/she just learns to actually try to answer them first before asking.
February 28, 2012 at 8:36 am
Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used to be a couple of years ago.
Good sign.
-- Gianluca Sartori
February 28, 2012 at 9:27 am
Gianluca Sartori (2/28/2012)
Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used to be a couple of years ago.Good sign.
I have been getting so many feelers from the head hunters lately. More than usual, in fact. Lots of jobs to fill. And they keep trying to grab from the same subset of people.
It seems like there's not a lot of fresh blood in the market that actually wants to be a DBA or has the experience everyone is asking for.
February 28, 2012 at 9:40 am
Brandie Tarvin (2/28/2012)
Gianluca Sartori (2/28/2012)
Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used to be a couple of years ago.Good sign.
I have been getting so many feelers from the head hunters lately. More than usual, in fact. Lots of jobs to fill. And they keep trying to grab from the same subset of people.
It seems like there's not a lot of fresh blood in the market that actually wants to be a DBA or has the experience everyone is asking for.
I have to agree. I have been getting more hits. Unfortunately, most of the ones I get want Senior level skills/experience for Junior level wages and won't pay for relocation (not that I want to relocate at the moment). Plus, why would I when I start a new job next week that I am really excited about?
I guess we need to start encouraging more people to consider DBA work as a career choice.
February 28, 2012 at 11:10 am
Lynn Pettis (2/28/2012)
I guess we need to start encouraging more people to consider DBA work as a career choice.
What??? You mean less people!
What would I do for a living with all those DBAs around doing it much better than me??
No, no, no! More than enough DBAs!! 😛
-- Gianluca Sartori
February 28, 2012 at 11:40 am
Brandie Tarvin (2/28/2012)
Gianluca Sartori (2/28/2012)
Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used to be a couple of years ago.Good sign.
I have been getting so many feelers from the head hunters lately. More than usual, in fact. Lots of jobs to fill. And they keep trying to grab from the same subset of people.
It seems like there's not a lot of fresh blood in the market that actually wants to be a DBA or has the experience everyone is asking for.
I keep getting hit on by recruiters looking for .NET devs (my resume specifically says "trivial experience in .NET"), data entry clerk positions (the word "data" appears on my resume several times, that is true), and even for a data verification position for a law office (scary thought there in its own way).
I concluded a while back that these recruiters are:
a) Illiterate - their resume search software says my resume is a match based on keywords, but they can't read it themselves to see what it actually says.
b) Desperate - "maybe if we throw enough random people at it, someone will be a good match, get hired, and we'll make payroll this month".
and/or
c) Evil - Muahahahahah! Let's send them a DBA to be their legal data verification clerk! The resulting chaos will bring civilization that much closer to its inevitable collapse! Events are going exactly as I have forseen them!
I prefer (c), for the entertainment value, personally.
- 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
February 28, 2012 at 11:57 am
Gianluca Sartori (2/28/2012)
Lynn Pettis (2/28/2012)
I guess we need to start encouraging more people to consider DBA work as a career choice.What??? You mean less people!
What would I do for a living with all those DBAs around doing it much better than me??
No, no, no! More than enough DBAs!! 😛
You would manage them, and daily told them how surprised you are how long they take to accomplish their tasks.
February 28, 2012 at 12:31 pm
GSquared (2/28/2012)
Brandie Tarvin (2/28/2012)
Gianluca Sartori (2/28/2012)
Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used to be a couple of years ago.Good sign.
I have been getting so many feelers from the head hunters lately. More than usual, in fact. Lots of jobs to fill. And they keep trying to grab from the same subset of people.
It seems like there's not a lot of fresh blood in the market that actually wants to be a DBA or has the experience everyone is asking for.
I keep getting hit on by recruiters looking for .NET devs (my resume specifically says "trivial experience in .NET"), data entry clerk positions (the word "data" appears on my resume several times, that is true), and even for a data verification position for a law office (scary thought there in its own way).
I concluded a while back that these recruiters are:
a) Illiterate - their resume search software says my resume is a match based on keywords, but they can't read it themselves to see what it actually says.
b) Desperate - "maybe if we throw enough random people at it, someone will be a good match, get hired, and we'll make payroll this month".
and/or
c) Evil - Muahahahahah! Let's send them a DBA to be their legal data verification clerk! The resulting chaos will bring civilization that much closer to its inevitable collapse! Events are going exactly as I have forseen them!
I prefer (c), for the entertainment value, personally.
(c) does kinda sound like you...:-P
---------------------------------------------------------
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."
February 28, 2012 at 1:34 pm
GSquared (2/28/2012)
Brandie Tarvin (2/28/2012)
I keep getting hit on by recruiters looking for .NET devs (my resume specifically says "trivial experience in .NET")
Aha! It mentions .NET! That's good enough for most recruiters.
I've been getting contacted quite a lot lately. Sometimes they call me at the client I currently work with (the nerve of these guys).
Some try to add my to their LinkedIn network with "Person X has indicated that you are a Friend". Euh.... no.
Got contacted by 5 different for the same position. (although I have to admit that the position itself was quite a good match)
But the most funny one was the guy that send me an e-mail and addressed me with my colleague's name 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 28, 2012 at 2:03 pm
Koen Verbeeck (2/28/2012)
GSquared (2/28/2012)
Brandie Tarvin (2/28/2012)
I keep getting hit on by recruiters looking for .NET devs (my resume specifically says "trivial experience in .NET")Aha! It mentions .NET! That's good enough for most recruiters.
Yeah, that's why I'm sorry I have Oracle on my resume.
I've been getting contacted quite a lot lately. Sometimes they call me at the client I currently work with (the nerve of these guys).
Some try to add my to their LinkedIn network with "Person X has indicated that you are a Friend". Euh.... no.
Got contacted by 5 different for the same position. (although I have to admit that the position itself was quite a good match)
But the most funny one was the guy that send me an e-mail and addressed me with my colleague's name 🙂
It is also funny how often I get contacted for jobs that require my brother's skill set.
--------------------------------------
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
February 28, 2012 at 6:04 pm
Brandie Tarvin (2/28/2012)
Gianluca Sartori (2/28/2012)
Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used to be a couple of years ago.Good sign.
I have been getting so many feelers from the head hunters lately. More than usual, in fact. Lots of jobs to fill. And they keep trying to grab from the same subset of people.
It seems like there's not a lot of fresh blood in the market that actually wants to be a DBA or has the experience everyone is asking for.
I'm getting feelers too, but they are all for full time jobs needing a long term commitment - telling the agencies that I'm not prepared tp work more than 4 months a year hasn't had the desired effect, so maybe there's a shortage of people and some of the the agents are getting a bit desparate.
Tom
Viewing 15 posts - 34,501 through 34,515 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply