September 25, 2014 at 3:22 pm
Alvin Ramard (9/25/2014)
Question: Explain what DBCC TimeWarp is. 😀
I have used that question during an interview. It is a fun one.
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
September 25, 2014 at 3:41 pm
SQLRNNR (9/25/2014)
Alvin Ramard (9/25/2014)
Question: Explain what DBCC TimeWarp is. 😀
I have used that question during an interview. It is a fun one.
That is hilarious!!! Hopefully the response was something like "I would tell you but you seem like a nice guy and I am sworn with a blood oath to kill anyone else who knows the secret."
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 25, 2014 at 3:47 pm
Koen Verbeeck (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Have you ever seen a resume which states SSC points on it?😎
What? You haven't?
Should have been, have you ever written/submitted a... ~~~~\o/~~~/\~~
😎
September 25, 2014 at 3:48 pm
Sean Lange (9/25/2014)
SQLRNNR (9/25/2014)
Alvin Ramard (9/25/2014)
Question: Explain what DBCC TimeWarp is. 😀
I have used that question during an interview. It is a fun one.
That is hilarious!!! Hopefully the response was something like "I would tell you but you seem like a nice guy and I am sworn with a blood oath to kill anyone else who knows the secret."
No, I didn't answer:w00t:
😎
September 25, 2014 at 3:53 pm
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
SQLRNNR (9/25/2014)
Lynn Pettis (9/25/2014)
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.And all he says is "Thanks for the question."
Really? You want the points from posting that much?
Why yes!!
He probably even has another account that has been used to figure out what the correct answers are (like some of those "sme"s that haven't missed a single point). It's important to have all of those points so they can use it on a resume 😉
Now what is the point of that" Kind of pointless effort isn't it (excuse the pun)? Have you ever seen a resume which states SSC points on it?
😎
It doesn't have to be mentioned on a resume for potential employers to check it.
Guess you are right, just struggling with the idea of jitter being weighted on a resume. Don't take me wrong here, many of the points earned on this site are well earned but unless scrutinized, how can one tell the difference?
😎
I agree with you. The number of points, without knowing how the were earned, is not very meaningful.
On different note, I was just thinking about what would be an interesting interview question.
Question: Explain what DBCC TimeWarp is. 😀
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"
(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
September 25, 2014 at 4:00 pm
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
SQLRNNR (9/25/2014)
Lynn Pettis (9/25/2014)
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.And all he says is "Thanks for the question."
Really? You want the points from posting that much?
Why yes!!
He probably even has another account that has been used to figure out what the correct answers are (like some of those "sme"s that haven't missed a single point). It's important to have all of those points so they can use it on a resume 😉
Now what is the point of that" Kind of pointless effort isn't it (excuse the pun)? Have you ever seen a resume which states SSC points on it?
😎
It doesn't have to be mentioned on a resume for potential employers to check it.
Guess you are right, just struggling with the idea of jitter being weighted on a resume. Don't take me wrong here, many of the points earned on this site are well earned but unless scrutinized, how can one tell the difference?
😎
I agree with you. The number of points, without knowing how the were earned, is not very meaningful.
On different note, I was just thinking about what would be an interesting interview question.
Question: Explain what DBCC TimeWarp is. 😀
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"
(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
.... and LMGTFY 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 25, 2014 at 4:06 pm
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
SQLRNNR (9/25/2014)
Lynn Pettis (9/25/2014)
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.And all he says is "Thanks for the question."
Really? You want the points from posting that much?
Why yes!!
He probably even has another account that has been used to figure out what the correct answers are (like some of those "sme"s that haven't missed a single point). It's important to have all of those points so they can use it on a resume 😉
Now what is the point of that" Kind of pointless effort isn't it (excuse the pun)? Have you ever seen a resume which states SSC points on it?
😎
It doesn't have to be mentioned on a resume for potential employers to check it.
Guess you are right, just struggling with the idea of jitter being weighted on a resume. Don't take me wrong here, many of the points earned on this site are well earned but unless scrutinized, how can one tell the difference?
😎
I agree with you. The number of points, without knowing how the were earned, is not very meaningful.
On different note, I was just thinking about what would be an interesting interview question.
Question: Explain what DBCC TimeWarp is. 😀
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"
(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
.... and LMGTFY 🙂
He he, had to google that one:pinch:
😎
September 25, 2014 at 4:10 pm
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
SQLRNNR (9/25/2014)
Lynn Pettis (9/25/2014)
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.And all he says is "Thanks for the question."
Really? You want the points from posting that much?
Why yes!!
He probably even has another account that has been used to figure out what the correct answers are (like some of those "sme"s that haven't missed a single point). It's important to have all of those points so they can use it on a resume 😉
Now what is the point of that" Kind of pointless effort isn't it (excuse the pun)? Have you ever seen a resume which states SSC points on it?
😎
It doesn't have to be mentioned on a resume for potential employers to check it.
Guess you are right, just struggling with the idea of jitter being weighted on a resume. Don't take me wrong here, many of the points earned on this site are well earned but unless scrutinized, how can one tell the difference?
😎
I agree with you. The number of points, without knowing how the were earned, is not very meaningful.
On different note, I was just thinking about what would be an interesting interview question.
Question: Explain what DBCC TimeWarp is. 😀
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"
(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
.... and LMGTFY 🙂
He he, had to google that one:pinch:
😎
Let me know if you need help finding it, I can send you a link. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 25, 2014 at 4:15 pm
Sean Lange (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
SQLRNNR (9/25/2014)
Lynn Pettis (9/25/2014)
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.And all he says is "Thanks for the question."
Really? You want the points from posting that much?
Why yes!!
He probably even has another account that has been used to figure out what the correct answers are (like some of those "sme"s that haven't missed a single point). It's important to have all of those points so they can use it on a resume 😉
Now what is the point of that" Kind of pointless effort isn't it (excuse the pun)? Have you ever seen a resume which states SSC points on it?
😎
It doesn't have to be mentioned on a resume for potential employers to check it.
Guess you are right, just struggling with the idea of jitter being weighted on a resume. Don't take me wrong here, many of the points earned on this site are well earned but unless scrutinized, how can one tell the difference?
😎
I agree with you. The number of points, without knowing how the were earned, is not very meaningful.
On different note, I was just thinking about what would be an interesting interview question.
Question: Explain what DBCC TimeWarp is. 😀
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"
(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
.... and LMGTFY 🙂
He he, had to google that one:pinch:
😎
Let me know if you need help finding it, I can send you a link. 😀
LSMIH:laugh:
😎
September 25, 2014 at 4:32 pm
Sean Lange (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
SQLRNNR (9/25/2014)
Lynn Pettis (9/25/2014)
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.And all he says is "Thanks for the question."
Really? You want the points from posting that much?
Why yes!!
He probably even has another account that has been used to figure out what the correct answers are (like some of those "sme"s that haven't missed a single point). It's important to have all of those points so they can use it on a resume 😉
Now what is the point of that" Kind of pointless effort isn't it (excuse the pun)? Have you ever seen a resume which states SSC points on it?
😎
It doesn't have to be mentioned on a resume for potential employers to check it.
Guess you are right, just struggling with the idea of jitter being weighted on a resume. Don't take me wrong here, many of the points earned on this site are well earned but unless scrutinized, how can one tell the difference?
😎
I agree with you. The number of points, without knowing how the were earned, is not very meaningful.
On different note, I was just thinking about what would be an interesting interview question.
Question: Explain what DBCC TimeWarp is. 😀
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"
(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
.... and LMGTFY 🙂
He he, had to google that one:pinch:
😎
Let me know if you need help finding it, I can send you a link. 😀
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
September 25, 2014 at 4:38 pm
SQLRNNR (9/25/2014)
Sean Lange (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Alvin Ramard (9/25/2014)
Eirikur Eiriksson (9/25/2014)
SQLRNNR (9/25/2014)
Lynn Pettis (9/25/2014)
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.And all he says is "Thanks for the question."
Really? You want the points from posting that much?
Why yes!!
He probably even has another account that has been used to figure out what the correct answers are (like some of those "sme"s that haven't missed a single point). It's important to have all of those points so they can use it on a resume 😉
Now what is the point of that" Kind of pointless effort isn't it (excuse the pun)? Have you ever seen a resume which states SSC points on it?
😎
It doesn't have to be mentioned on a resume for potential employers to check it.
Guess you are right, just struggling with the idea of jitter being weighted on a resume. Don't take me wrong here, many of the points earned on this site are well earned but unless scrutinized, how can one tell the difference?
😎
I agree with you. The number of points, without knowing how the were earned, is not very meaningful.
On different note, I was just thinking about what would be an interesting interview question.
Question: Explain what DBCC TimeWarp is. 😀
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"
(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
.... and LMGTFY 🙂
He he, had to google that one:pinch:
😎
Let me know if you need help finding it, I can send you a link. 😀
😎
September 25, 2014 at 6:00 pm
Sean Lange (9/25/2014)
Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many people have decided to go elsewhere.
Commenting twice on most of them, too. It would be nice if he commented on old questions only when he had something useful to add to the discussion.
I'll refrain complain about content-free comments on current questions because that would upset far too many threadizens 😀 and anyway a timely "nice question" comment is maybe as much politeness as noise :cool:.
Tom
September 25, 2014 at 6:07 pm
Eirikur Eiriksson (9/25/2014)
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
That addition makes it an "unfair" question because it's totally ambiguous: does JCI mean what Joe does or does it mean what many of us say about what Joe does? 😀 Now if I were Joe I could go into a rant about how ambiguously formulated questions demonstrate that you are an idiot who shouldn't be allowed to writed SQL, but I'm a great believer in asking questions that are "unfair" in that sense, so I won't.
:hehe:
Tom
September 25, 2014 at 6:39 pm
TomThomson (9/25/2014)
Eirikur Eiriksson (9/25/2014)
Accompanied with "explain the difference between HLC, LOP, JCI and YASS"(Hopeless Case, Lost OP, Joe Celko Intollerance and Yet Another Silver Spoon)
😎
Edit: Added JCI
That addition makes it an "unfair" question because it's totally ambiguous: does JCI mean what Joe does or does it mean what many of us say about what Joe does? 😀 Now if I were Joe I could go into a rant about how ambiguously formulated questions demonstrate that you are an idiot who shouldn't be allowed to writed SQL, but I'm a great believer in asking questions that are "unfair" in that sense, so I won't.
:hehe:
I think an apostrophe was missed in the YASS. Shouldn't it be similar to Y'all? Therefore, Y'***?:-D:-D
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
September 26, 2014 at 5:22 am
Could anyone with a moment please check my answer here: http://www.sqlservercentral.com/Forums/Topic1618884-391-1.aspx
Want to make sure there's no small inaccuracy which could get exploited.
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
Viewing 15 posts - 45,886 through 45,900 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply