March 3, 2016 at 1:43 am
Has something gone wrong with sending notifications over the last day or two? A lot of new posts on the thread, but I haven't had a single notification for it (or for anything else at SQL Server Central, and there have been messages in at least a few other threads I'm subscribed to).
Tom
March 3, 2016 at 1:46 am
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]
Please please pretty please take a look at Jaeger's in the French Quarter. I went there as an impoverished postdoc in about 1987 and it was amazing. Jaeger's book in the link explains the holy trinity, describes how to make your own seasonings (the blackening seasoning is stunning with fresh tuna) and generally makes cooking all of your favourite Cajun grub a walk in the park.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 3, 2016 at 1:52 am
TomThomson (3/3/2016)
Has something gone wrong with sending notifications over the last day or two? A lot of new posts on the thread, but I haven't had a single notification for it (or for anything else at SQL Server Central, and there have been messages in at least a few other threads I'm subscribed to).
If there were problems, they appear to have been fixed now Tom. A notification for your post came through almost immediately.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 3, 2016 at 7:07 am
ChrisM@Work (3/3/2016)
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]
Please please pretty please take a look at Jaeger's in the French Quarter. I went there as an impoverished postdoc in about 1987 and it was amazing. Jaeger's book in the link explains the holy trinity, describes how to make your own seasonings (the blackening seasoning is stunning with fresh tuna) and generally makes cooking all of your favourite Cajun grub a walk in the park.
We went there last trip and I have plans to go again. It was good. I didn't know about the cookbook though. Will definitely grab a copy of that.
_______________________________________________________________
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/
March 3, 2016 at 7:43 am
TomThomson (3/3/2016)
Has something gone wrong with sending notifications over the last day or two? A lot of new posts on the thread, but I haven't had a single notification for it (or for anything else at SQL Server Central, and there have been messages in at least a few other threads I'm subscribed to).
Not that I know of. I'm getting notifications for this and other threads.
We have been fighting with Spamcop a bit. As some of the SPAM addresses slip through, apparently it's out fault someone registered with us, and some of the blacklists have us on them. We also get caught if a gmail/yahoo/hotmail address recycles and the person doesn't unsubscribe but reports spam.
March 3, 2016 at 8:27 am
March 3, 2016 at 8:59 am
Steve Jones - SSC Editor (3/3/2016)
TomThomson (3/3/2016)
Has something gone wrong with sending notifications over the last day or two? A lot of new posts on the thread, but I haven't had a single notification for it (or for anything else at SQL Server Central, and there have been messages in at least a few other threads I'm subscribed to).Not that I know of. I'm getting notifications for this and other threads.
We have been fighting with Spamcop a bit. As some of the SPAM addresses slip through, apparently it's out fault someone registered with us, and some of the blacklists have us on them. We also get caught if a gmail/yahoo/hotmail address recycles and the person doesn't unsubscribe but reports spam.
That's a near-constant battle. Sending lots of email to multiple domains, quick send rates, spam reports and your sender score are a part of the game. It doesn't make it any easier that different providers have different requirements and measures and they aren't consistent or even published in some cases.
March 3, 2016 at 9:26 am
It is a regular battle. One reason that RG moved to outsource the sending. I used to do this, and it was a day a week to work through spam issues with various providers and blacklists, fix sending and unsubscribe code, etc.
March 4, 2016 at 7:04 am
I suppose I could toss this question into it's own topic, but meh...
To anyone who has gone on any of the previous SQL Cruises, if you brought your SO along, about how much more did that add to the cost? Presuming said SO wasn't *also* a SQL junky...
I'm looking at the August 2017 cruise, and want to get an idea what it might run for me and the wife to go (me being a SQL Cruiser, her... Well, I'm glad she's not a shopper...)
March 4, 2016 at 8:31 am
The added cost is only for the SOs cruise. There's no added cost for the SO to be registered with the group and take part in the social aspects of the cruise. That stuff is assumed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 4, 2016 at 8:35 am
jasona.work (3/4/2016)
I suppose I could toss this question into it's own topic, but meh...To anyone who has gone on any of the previous SQL Cruises, if you brought your SO along, about how much more did that add to the cost? Presuming said SO wasn't *also* a SQL junky...
I'm looking at the August 2017 cruise, and want to get an idea what it might run for me and the wife to go (me being a SQL Cruiser, her... Well, I'm glad she's not a shopper...)
It's just the extra cabin fare. Depends on the cabin that you get. When I went in 2012, it was $2000 for an inside stateroom, and $3500 for a stateroom with a balcony (both with 2 persons)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
March 4, 2016 at 8:47 am
WayneS (3/4/2016)
jasona.work (3/4/2016)
I suppose I could toss this question into it's own topic, but meh...To anyone who has gone on any of the previous SQL Cruises, if you brought your SO along, about how much more did that add to the cost? Presuming said SO wasn't *also* a SQL junky...
I'm looking at the August 2017 cruise, and want to get an idea what it might run for me and the wife to go (me being a SQL Cruiser, her... Well, I'm glad she's not a shopper...)
It's just the extra cabin fare. Depends on the cabin that you get. When I went in 2012, it was $2000 for an inside stateroom, and $3500 for a stateroom with a balcony (both with 2 persons)
So to make sure I'm reading this right then:
$2000 for a stateroom, total, for both of us (not $2000/ea), plus for me the extra cost to attend the various sessions (social events both of us get to attend.)
Sound right?
Oh, and those are the prices from 2012, and have undoubtedly changed.
March 4, 2016 at 8:55 am
jasona.work (3/4/2016)
WayneS (3/4/2016)
jasona.work (3/4/2016)
I suppose I could toss this question into it's own topic, but meh...To anyone who has gone on any of the previous SQL Cruises, if you brought your SO along, about how much more did that add to the cost? Presuming said SO wasn't *also* a SQL junky...
I'm looking at the August 2017 cruise, and want to get an idea what it might run for me and the wife to go (me being a SQL Cruiser, her... Well, I'm glad she's not a shopper...)
It's just the extra cabin fare. Depends on the cabin that you get. When I went in 2012, it was $2000 for an inside stateroom, and $3500 for a stateroom with a balcony (both with 2 persons)
So to make sure I'm reading this right then:
$2000 for a stateroom, total, for both of us (not $2000/ea), plus for me the extra cost to attend the various sessions (social events both of us get to attend.)
Sound right?
Oh, and those are the prices from 2012, and have undoubtedly changed.
Contact the cruise line, but do it through the concierge assigned to SQL Cruise. You can find it at the web site. One key point, also look at and recheck the NCL web site regularly. They sometimes have specials that the concierge doesn't know about (which kinda sucks).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 4, 2016 at 9:40 am
Grant Fritchey (3/4/2016)
jasona.work (3/4/2016)
WayneS (3/4/2016)
jasona.work (3/4/2016)
I suppose I could toss this question into it's own topic, but meh...To anyone who has gone on any of the previous SQL Cruises, if you brought your SO along, about how much more did that add to the cost? Presuming said SO wasn't *also* a SQL junky...
I'm looking at the August 2017 cruise, and want to get an idea what it might run for me and the wife to go (me being a SQL Cruiser, her... Well, I'm glad she's not a shopper...)
It's just the extra cabin fare. Depends on the cabin that you get. When I went in 2012, it was $2000 for an inside stateroom, and $3500 for a stateroom with a balcony (both with 2 persons)
So to make sure I'm reading this right then:
$2000 for a stateroom, total, for both of us (not $2000/ea), plus for me the extra cost to attend the various sessions (social events both of us get to attend.)
Sound right?
Oh, and those are the prices from 2012, and have undoubtedly changed.
Contact the cruise line, but do it through the concierge assigned to SQL Cruise. You can find it at the web site. One key point, also look at and recheck the NCL web site regularly. They sometimes have specials that the concierge doesn't know about (which kinda sucks).
I concur. There was a deal on the website I saw right after talking to the concierge. It was a slightly better package than what he had. The concierge is also really good to work with.
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
March 4, 2016 at 10:25 am
I'll shoot the concierge an e-mail tonight. At the moment, I'm just trying to get a rough idea as to the price, so I can look at budgeting for it...
Wonder if I could get the boss to pay for it?
😉
On an unrelated note, the look of relief on the face of the guy who's in charge of acquiring the software licenses, when he finds out that we have SA and thus don't need to buy new licenses for SQL 2014 @ ~$11k/ea (2-core packs, and we'd need quite a few) is priceless...
:hehe:
(BTW, he talked to our licensing reps to get that info, we're not interpreting MS licensing in our favor)
Viewing 15 posts - 52,996 through 53,010 (of 66,547 total)
You must be logged in to reply to this topic. Login to reply