Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 52,981 through 52,995 (of 66,569 total)

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

jasona.work SSC Guru Points: 50084 More actions · Answer 1

Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);

Destination

-------------------------------------------------- -----------

Jamaica mon! 9

(1 row(s) affected)

Brandie Tarvin SSC Guru Points: 173003 More actions · Answer 2

Thanks, all, for the reviews of the presentation.

While my class is now officially over, I'm debating on the possibility of redoing the presentation for a more real-world push of the subject. Any thoughts as to whether or not other people would be interested in it?

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.

Thomas Rushton SSC-Insane Points: 22648 More actions · Answer 3

At the last place, I put a seconds-to-end-of-contract countdown in my PowerShell prompt.

$([Convert]::ToInt32(([datetime]'2016-01-08 16:30' - (get-date)).duration().TotalSeconds))

That was the latest in my stream of various countdown apps. Previously I'd written a little 8-digit seven segment display type thing that sat (very small) in the top right corner of my screen doing the same thing. No idea where that code went!

Thomas Rushton
blog: https://thelonedba.wordpress.com

jasona.work SSC Guru Points: 50084 More actions · Answer 4

ThomasRushton (3/2/2016)
At the last place, I put a seconds-to-end-of-contract countdown in my PowerShell prompt.
$([Convert]::ToInt32(([datetime]'2016-01-08 16:30' - (get-date)).duration().TotalSeconds))
That was the latest in my stream of various countdown apps. Previously I'd written a little 8-digit seven segment display type thing that sat (very small) in the top right corner of my screen doing the same thing. No idea where that code went!

I sometimes miss the old Windows Vista desktop gadgets you could run. I had one that was a countdown timer, you could set it for any date you wanted. Was great for keeping an eye on stuff like this...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛

You could have done this:

http://sqlcruise.com/[/url]

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

Steve Jones - SSC Editor SSC Guru Points: 734562 More actions · Answer 6

Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛

Enjoy. We are aiming for Glacier National Park this summer.

Sean Lange SSC Guru Points: 286589 More actions · Answer 7

Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
Enjoy. We are aiming for Glacier National Park this summer.

Not a family trip but I am heading to Jazz Fest in New Orleans the last weekend in April. One of my good friends, who actually works for her company, grew up there. It was here idea. She said "you and James need some guy time in New Orleans, you should go to Jazz Fest". Seriously? My wife wants me to go there without the family for several days with no responsibilities of any kind? I of course promptly agreed. I will need a day or two to recover before coming home, it takes longer these days to recover from these kinds of things.

_______________________________________________________________

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/

Alan Burstein SSC Guru Points: 61136 More actions · Answer 8

Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
Enjoy. We are aiming for Glacier National Park this summer.
Not a family trip but I am heading to Jazz Fest in New Orleans the last weekend in April. One of my good friends, who actually works for her company, grew up there. [/b]It was her idea. She said "you and James need some guy time in New Orleans, you should go to Jazz Fest". Seriously? My wife wants me to go there without the family for several days with no responsibilities of any kind? I of course promptly agreed. I will need a day or two to recover before coming home, it takes longer these days to recover from these kinds of things.

Haha! In my home that would be a polite way of saying, "you've been getting on my nerves a bit much lately". ;-). We can't compete with New Orleans but I always recommend people check out Chicago's Jazz Fest. And nobody can compete with our Blues Fest.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Alan Burstein SSC Guru Points: 61136 More actions · Answer 9

SQLRNNR (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
You could have done this:
http://sqlcruise.com/[/url]

I wanted to very badly and still might do the Alaska one. I just found out SQL Cruise existed last year. I mentioned it to my dad and my niece (16) started singing the theme song for Love Boat but was singing "Nerrrrd Ship" instead of "Loooove Boat". :hehe:

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Sean Lange SSC Guru Points: 286589 More actions · Answer 10

Alan.B (3/2/2016)
Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
Enjoy. We are aiming for Glacier National Park this summer.
Not a family trip but I am heading to Jazz Fest in New Orleans the last weekend in April. One of my good friends, who actually works for her company, grew up there. [/b]It was her idea. She said "you and James need some guy time in New Orleans, you should go to Jazz Fest". Seriously? My wife wants me to go there without the family for several days with no responsibilities of any kind? I of course promptly agreed. I will need a day or two to recover before coming home, it takes longer these days to recover from these kinds of things.
Haha! In my home that would be a polite way of saying, "you've been getting on my nerves a bit much lately". ;-). We can't compete with New Orleans but I always recommend people check out Chicago's Jazz Fest. And nobody can compete with our Blues Fest.

Yeah the Blues Fest there is pretty awesome. Of course in KC we don't need a festival...it is all year long!!! 😉

_______________________________________________________________

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/

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

Sean Lange (3/2/2016)
Alan.B (3/2/2016)
Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
Enjoy. We are aiming for Glacier National Park this summer.
Not a family trip but I am heading to Jazz Fest in New Orleans the last weekend in April. One of my good friends, who actually works for her company, grew up there. [/b]It was her idea. She said "you and James need some guy time in New Orleans, you should go to Jazz Fest". Seriously? My wife wants me to go there without the family for several days with no responsibilities of any kind? I of course promptly agreed. I will need a day or two to recover before coming home, it takes longer these days to recover from these kinds of things.
Haha! In my home that would be a polite way of saying, "you've been getting on my nerves a bit much lately". ;-). We can't compete with New Orleans but I always recommend people check out Chicago's Jazz Fest. And nobody can compete with our Blues Fest.
Yeah the Blues Fest there is pretty awesome. Of course in KC we don't need a festival...it is all year long!!! 😉

And you have good BBQ there too. Of course, New Orleans has cajun, which is its own special breed of goodness.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Grumpy DBA SSChampion Points: 12437 More actions · Answer 12

Ed Wagner (3/2/2016)
And you have good BBQ there too. Of course, New Orleans has cajun, which is its own special breed of goodness.

Don't forget the beignets and chicory coffee.

Sean Lange SSC Guru Points: 286589 More actions · Answer 13

Ed Wagner (3/2/2016)
Sean Lange (3/2/2016)
Alan.B (3/2/2016)
Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
Enjoy. We are aiming for Glacier National Park this summer.
Not a family trip but I am heading to Jazz Fest in New Orleans the last weekend in April. One of my good friends, who actually works for her company, grew up there. [/b]It was her idea. She said "you and James need some guy time in New Orleans, you should go to Jazz Fest". Seriously? My wife wants me to go there without the family for several days with no responsibilities of any kind? I of course promptly agreed. I will need a day or two to recover before coming home, it takes longer these days to recover from these kinds of things.
Haha! In my home that would be a polite way of saying, "you've been getting on my nerves a bit much lately". ;-). We can't compete with New Orleans but I always recommend people check out Chicago's Jazz Fest. And nobody can compete with our Blues Fest.
Yeah the Blues Fest there is pretty awesome. Of course in KC we don't need a festival...it is all year long!!! 😉
And you have good BBQ there too. Of course, New Orleans has cajun, which is its own special breed of goodness.

Amen to that my friend. I haven't been there in a couple years so am really looking forward to it. And of course let's not forget the absinthe bar. http://www.ruebourbon.com/oldabsinthehouse/[/url]

_______________________________________________________________

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/

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 14

Sean Lange (3/2/2016)
Ed Wagner (3/2/2016)
Sean Lange (3/2/2016)
Alan.B (3/2/2016)
Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
Enjoy. We are aiming for Glacier National Park this summer.
Not a family trip but I am heading to Jazz Fest in New Orleans the last weekend in April. One of my good friends, who actually works for her company, grew up there. [/b]It was her idea. She said "you and James need some guy time in New Orleans, you should go to Jazz Fest". Seriously? My wife wants me to go there without the family for several days with no responsibilities of any kind? I of course promptly agreed. I will need a day or two to recover before coming home, it takes longer these days to recover from these kinds of things.
Haha! In my home that would be a polite way of saying, "you've been getting on my nerves a bit much lately". ;-). We can't compete with New Orleans but I always recommend people check out Chicago's Jazz Fest. And nobody can compete with our Blues Fest.
Yeah the Blues Fest there is pretty awesome. Of course in KC we don't need a festival...it is all year long!!! 😉
And you have good BBQ there too. Of course, New Orleans has cajun, which is its own special breed of goodness.
Amen to that my friend. I haven't been there in a couple years so am really looking forward to it. And of course let's not forget the absinthe bar. http://www.ruebourbon.com/oldabsinthehouse/[/url]

Right now, I'd settle for a Jethro-sized bowl of shrimp gumbo.

--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)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Alan.B (3/2/2016)
SQLRNNR (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
You could have done this:
http://sqlcruise.com/[/url]
I wanted to very badly and still might do the Alaska one. I just found out SQL Cruise existed last year. I mentioned it to my dad and my niece (16) started singing the theme song for Love Boat but was singing "Nerrrrd Ship" instead of "Loooove Boat". :hehe:

Just remind her that it would be wise for her to marry a nerd;-). That is a funny theme song for the cruise tho!

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