July 17, 2014 at 10:19 am
The Dixie Flatline (7/16/2014)
Cafe du Monde in the French Quarter? Probably a few miles as the crow flies. I'd take a cab.
First thing she told me this morning was they walked there for breakfast.
Guess the walking justified the caloric intake.
July 17, 2014 at 10:23 am
Lynn Pettis (7/17/2014)
Lynn Pettis (7/17/2014)
Eirikur Eiriksson (7/17/2014)
SQLRNNR (7/17/2014)
Eirikur Eiriksson (7/16/2014)
Jack Corbett (7/16/2014)
Eirikur Eiriksson (7/16/2014)
No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub me the wrong way:-D😎
Hmmm, I hope I'm not the JC who rubbed you the wrong way.
No this one is Lynn's best pal and a traveling SQL standard salesman.
😎
You were supposed to let that play out. Let jc worry that he was the JC you were talking about.
Point taken, won't happen again:-D
😎
Eirikur, Thanks for helping with WC. Now I am waiting for him to have more problems when he moves the encrypted data to another database and then can't decrypt it to read it.
Then again, it looks like his problems have hit earlier than I thought. Pretty sure what he isn't doing but I think I'll go eat instead. The DFAC is only open for another hour.
He figured it out. It was what I was thinking as well. Should give him a gold star for solving one, but I'll hold off for now.
July 17, 2014 at 10:26 am
Greg Edwards-268690 (7/17/2014)
The Dixie Flatline (7/16/2014)
Cafe du Monde in the French Quarter? Probably a few miles as the crow flies. I'd take a cab.First thing she told me this morning was they walked there for breakfast.
Guess the walking justified the caloric intake.
You can't go to New Orleans without visiting Cafe du Monde. Just don't sneeze or cough when eating these things.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 17, 2014 at 10:34 am
Jack Corbett (7/17/2014)
Greg Edwards-268690 (7/17/2014)
The Dixie Flatline (7/16/2014)
Cafe du Monde in the French Quarter? Probably a few miles as the crow flies. I'd take a cab.First thing she told me this morning was they walked there for breakfast.
Guess the walking justified the caloric intake.
You can't go to New Orleans without visiting Cafe du Monde. Just don't sneeze or cough when eating these things.
And bring a wet wipe with you. It is almost a requirement after getting that sticky!!!
_______________________________________________________________
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/
July 17, 2014 at 10:38 am
Lynn Pettis (7/17/2014)
Lynn Pettis (7/17/2014)
Lynn Pettis (7/17/2014)
Eirikur Eiriksson (7/17/2014)
SQLRNNR (7/17/2014)
Eirikur Eiriksson (7/16/2014)
Jack Corbett (7/16/2014)
Eirikur Eiriksson (7/16/2014)
No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub me the wrong way:-D😎
Hmmm, I hope I'm not the JC who rubbed you the wrong way.
No this one is Lynn's best pal and a traveling SQL standard salesman.
😎
You were supposed to let that play out. Let jc worry that he was the JC you were talking about.
Point taken, won't happen again:-D
😎
Eirikur, Thanks for helping with WC. Now I am waiting for him to have more problems when he moves the encrypted data to another database and then can't decrypt it to read it.
Then again, it looks like his problems have hit earlier than I thought. Pretty sure what he isn't doing but I think I'll go eat instead. The DFAC is only open for another hour.
He figured it out. It was what I was thinking as well. Should give him a gold star for solving one, but I'll hold off for now.
Edit:Ooops, phone playing up on me, meant as a comment on Cafe du Monde in the French Quarter:-P
Been a while, my kind of starting the day, beats the hell out of XXX beagles and Star#ucks!
😎
July 17, 2014 at 12:11 pm
Hate asking a technical question in the thread, but I can't find the answer online and no-one is responding to my post so I'm hoping someone here can point me in the right direction.
Does the SQL Server memory grant process allocate 1 gig or 4000 bytes for an nvarchar(max)? Either is a problem, but they're different kinds of problems.
--------------------------------------
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
July 17, 2014 at 12:24 pm
Lynn Pettis (7/17/2014)
Lynn Pettis (7/17/2014)
Lynn Pettis (7/17/2014)
Eirikur Eiriksson (7/17/2014)
SQLRNNR (7/17/2014)
Eirikur Eiriksson (7/16/2014)
Jack Corbett (7/16/2014)
Eirikur Eiriksson (7/16/2014)
No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub me the wrong way:-D😎
Hmmm, I hope I'm not the JC who rubbed you the wrong way.
No this one is Lynn's best pal and a traveling SQL standard salesman.
😎
You were supposed to let that play out. Let jc worry that he was the JC you were talking about.
Point taken, won't happen again:-D
😎
Eirikur, Thanks for helping with WC. Now I am waiting for him to have more problems when he moves the encrypted data to another database and then can't decrypt it to read it.
Then again, it looks like his problems have hit earlier than I thought. Pretty sure what he isn't doing but I think I'll go eat instead. The DFAC is only open for another hour.
He figured it out. It was what I was thinking as well. Should give him a gold star for solving one, but I'll hold off for now.
I feel your pain. I was following the thread and honestly tried to help, but it was starting to drive me crazy. Even after I said that a simple update will do it, he posted the question several more times. I eventually unsubscribed from that thread so I don't go completely nuts. I need to learn to be more calm and patient.
July 17, 2014 at 12:33 pm
Ed Wagner (7/17/2014)
Lynn Pettis (7/17/2014)
Lynn Pettis (7/17/2014)
Lynn Pettis (7/17/2014)
Eirikur Eiriksson (7/17/2014)
SQLRNNR (7/17/2014)
Eirikur Eiriksson (7/16/2014)
Jack Corbett (7/16/2014)
Eirikur Eiriksson (7/16/2014)
No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub me the wrong way:-D😎
Hmmm, I hope I'm not the JC who rubbed you the wrong way.
No this one is Lynn's best pal and a traveling SQL standard salesman.
😎
You were supposed to let that play out. Let jc worry that he was the JC you were talking about.
Point taken, won't happen again:-D
😎
Eirikur, Thanks for helping with WC. Now I am waiting for him to have more problems when he moves the encrypted data to another database and then can't decrypt it to read it.
Then again, it looks like his problems have hit earlier than I thought. Pretty sure what he isn't doing but I think I'll go eat instead. The DFAC is only open for another hour.
He figured it out. It was what I was thinking as well. Should give him a gold star for solving one, but I'll hold off for now.
I feel your pain. I was following the thread and honestly tried to help, but it was starting to drive me crazy. Even after I said that a simple update will do it, he posted the question several more times. I eventually unsubscribed from that thread so I don't go completely nuts. I need to learn to be more calm and patient.
Must admit it smells of an executive stakeholders meeting, one does all the talk, answers all questions, only to get the same questions repeated in several different flavours 😛
I'd go a long way to help a drowning person but this is almost like a spilled drink on a wind mattress in a tropical swimming pool:hehe:
😎
July 18, 2014 at 7:38 am
SQLRNNR (7/17/2014)
Jack Corbett (7/17/2014)
Sean Lange (7/17/2014)
Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for me to have to fork over, I know my company won't shell out that kind of money for me to go.
That's where volunteerism pays off. Volunteer at your local PASS Chapter (start one if you don't have one nearby) or for the Summit Program Committee and you have a good opportunity to get a decent discount on registration. Then get someone to split a room with you and it really isn't that expensive. I attended last year's Summit on my own dime and it cost me like $600 because of being a PASS volunteer & finding someone to bunk with. I also don't drink so that saves me a ton of money as well.
Winner Winner on that one.
There are some that will probably double their cost due to the amount they will drink during the week.
Knew some guys in college who got gigs as the house band on a cruise ship, 2nd week out the manager was passing out paychecks, asked the bass player for money back to cover his bar tab. (D'oh!)
---------------------------------------------------------
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."
July 18, 2014 at 7:49 am
**Edit - duplicate post, must be drunk...
---------------------------------------------------------
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."
July 18, 2014 at 8:01 am
jcrawf02 (7/18/2014)
SQLRNNR (7/17/2014)
Jack Corbett (7/17/2014)
Sean Lange (7/17/2014)
Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for me to have to fork over, I know my company won't shell out that kind of money for me to go.
That's where volunteerism pays off. Volunteer at your local PASS Chapter (start one if you don't have one nearby) or for the Summit Program Committee and you have a good opportunity to get a decent discount on registration. Then get someone to split a room with you and it really isn't that expensive. I attended last year's Summit on my own dime and it cost me like $600 because of being a PASS volunteer & finding someone to bunk with. I also don't drink so that saves me a ton of money as well.
Winner Winner on that one.
There are some that will probably double their cost due to the amount they will drink during the week.
Knew some guys in college who got gigs as the house band on a cruise ship, 2nd week out the manager was passing out paychecks, asked the bass player for money back to cover his bar tab. (D'oh!)
That is too funny!!!! Those darn bass players. They are notorious for drinking a bit much...oh wait...I am one of them. 😉
_______________________________________________________________
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/
July 18, 2014 at 8:08 am
jcrawf02 (7/18/2014)
**Edit - duplicate post, must be drunk...
You don't play bass do you?
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
July 18, 2014 at 10:41 am
Why do I feel that WC is heading down a deep dark hole??
July 18, 2014 at 10:45 am
Lynn Pettis (7/18/2014)
Why do I feel that WC is heading down a deep dark hole??
Did you see somebody push him in the hole?
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
July 18, 2014 at 10:51 am
SQLRNNR (7/18/2014)
Lynn Pettis (7/18/2014)
Why do I feel that WC is heading down a deep dark hole??Did you see somebody push him in the hole?
I have plausible deniability, I did not realize there was a hole. 😀
_______________________________________________________________
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/
Viewing 15 posts - 44,716 through 44,730 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply