June 25, 2014 at 2:39 pm
Evil Kraig F (6/25/2014)
Lynn Pettis (6/25/2014)
Really? Just because SQL Server setup defaults to a CI collation that makes it the "DEFAULT" collation?I give up.
I gotta say "Yes." to that one, Lynn. Default = "What is setup with the minimum input from the user/installer", at least to me.
Not seeing the disconnect.
Like Kraig said, it boils down to minimal effort from person setting it up.
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
June 25, 2014 at 2:39 pm
jcrawf02 (6/25/2014)
Sean Lange (6/25/2014)
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/2014)
Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What is your question?" and the post back "It's in my original post." It was not.That happens here too. And developers are always whingeing that the specs they are given don't contain sufficient information to complete the task. Gaaah!
Right.
Or when you propose a solution and they go like "Aaaah yes. But actually in my real-life scenario I need to do it like this..."
That's why we pass the crystal ball around. But it seems somebody has been hogging it of late.:hehe:
Yeah sorry, I dropped it. It's in the shop for repairs.
Likely story. Now we know how you are able to zip through the forums so fast.
Yeah, really. When it gets out of the shop, I'd like to be added to the rotation. I'll even volunteer do the testing to make sure it still works well.
Apparently Craig has it (in his other pants):
http://www.sqlservercentral.com/Forums/Topic1586022-2799-1.aspx
Ah hah! Now all he has to do is find his pants. :w00t: It's time for a rotation!
Cute!
It's from the Lego Movie. You probably haven't had much chance to keep up with that sort of stuff. 😉 As usual though, about the only movies worth seeing are the kids ones. Thankfully we have 2 little ones so we have an excuse.
Except that movie was definitely not for kids.
Agreed. My two boys love it since it is all Legos but otherwise it is for adults.
_______________________________________________________________
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/
June 25, 2014 at 2:44 pm
Evil Kraig F (6/25/2014)
Sean Lange (6/25/2014)
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/2014)
Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What is your question?" and the post back "It's in my original post." It was not.That happens here too. And developers are always whingeing that the specs they are given don't contain sufficient information to complete the task. Gaaah!
Right.
Or when you propose a solution and they go like "Aaaah yes. But actually in my real-life scenario I need to do it like this..."
That's why we pass the crystal ball around. But it seems somebody has been hogging it of late.:hehe:
Yeah sorry, I dropped it. It's in the shop for repairs.
Likely story. Now we know how you are able to zip through the forums so fast.
Yeah, really. When it gets out of the shop, I'd like to be added to the rotation. I'll even volunteer do the testing to make sure it still works well.
Apparently Craig has it (in his other pants):
http://www.sqlservercentral.com/Forums/Topic1586022-2799-1.aspx
Ah hah! Now all he has to do is find his pants. :w00t: It's time for a rotation!
Cute!
It's from the Lego Movie. You probably haven't had much chance to keep up with that sort of stuff. 😉 As usual though, about the only movies worth seeing are the kids ones. Thankfully we have 2 little ones so we have an excuse.
After seeing what Lynn was doing with his mystic abillities of long range mind reading, I figured I'd attempt my own mystic arts... so I made sure I got put into the front of the list via my psyonic abilities. However, I apparently blew the memory fuse when I did that...
...I've once again lost my pants. Usually it's just my shirt at the casino, but my pants after 2 weeks without a day off apparently took a hike without me.
At least my clothing is getting exercise. 😀
If you didn't know already, you have your own fanclub 😉
http://www.sqlservercentral.com/Forums/Topic1586080-61-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2014 at 3:33 pm
Lynn Pettis (6/25/2014)
Really? Just because SQL Server setup defaults to a CI collation that makes it the "DEFAULT" collation?I give up.
Ha! Well, yeah, I suppose I would refer to a default value as the default. Guilty.
"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
June 25, 2014 at 3:46 pm
Koen Verbeeck (6/25/2014)
Evil Kraig F (6/25/2014)
Sean Lange (6/25/2014)
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/2014)
Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What is your question?" and the post back "It's in my original post." It was not.That happens here too. And developers are always whingeing that the specs they are given don't contain sufficient information to complete the task. Gaaah!
Right.
Or when you propose a solution and they go like "Aaaah yes. But actually in my real-life scenario I need to do it like this..."
That's why we pass the crystal ball around. But it seems somebody has been hogging it of late.:hehe:
Yeah sorry, I dropped it. It's in the shop for repairs.
Likely story. Now we know how you are able to zip through the forums so fast.
Yeah, really. When it gets out of the shop, I'd like to be added to the rotation. I'll even volunteer do the testing to make sure it still works well.
Apparently Craig has it (in his other pants):
http://www.sqlservercentral.com/Forums/Topic1586022-2799-1.aspx
Ah hah! Now all he has to do is find his pants. :w00t: It's time for a rotation!
Cute!
It's from the Lego Movie. You probably haven't had much chance to keep up with that sort of stuff. 😉 As usual though, about the only movies worth seeing are the kids ones. Thankfully we have 2 little ones so we have an excuse.
After seeing what Lynn was doing with his mystic abillities of long range mind reading, I figured I'd attempt my own mystic arts... so I made sure I got put into the front of the list via my psyonic abilities. However, I apparently blew the memory fuse when I did that...
...I've once again lost my pants. Usually it's just my shirt at the casino, but my pants after 2 weeks without a day off apparently took a hike without me.
At least my clothing is getting exercise. 😀
If you didn't know already, you have your own fanclub 😉
http://www.sqlservercentral.com/Forums/Topic1586080-61-1.aspx
I missed that earlier, apparently...
The idea of having a fanclub is odd to me. Not disturbing, just odd.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 26, 2014 at 12:22 am
Crystal ball needed!
http://www.sqlservercentral.com/Forums/Topic1585731-3412-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2014 at 2:48 am
Koen Verbeeck (6/26/2014)
Crystal ball needed!http://www.sqlservercentral.com/Forums/Topic1585731-3412-1.aspx
... and another one
http://www.sqlservercentral.com/Forums/Topic1586022-2799-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2014 at 6:57 am
Koen Verbeeck (6/26/2014)
Koen Verbeeck (6/26/2014)
Crystal ball needed!http://www.sqlservercentral.com/Forums/Topic1585731-3412-1.aspx
... and another one
http://www.sqlservercentral.com/Forums/Topic1586022-2799-1.aspx
I am doing a bunch of things.
Now I want to do another thing, and it is similar, just in SSIS.
Please tell me exactly how.
Good test for the Crystal Ball to verify it's been correctly repaired. 😉
June 26, 2014 at 6:59 am
Greg Edwards-268690 (6/26/2014)
Koen Verbeeck (6/26/2014)
Koen Verbeeck (6/26/2014)
Crystal ball needed!http://www.sqlservercentral.com/Forums/Topic1585731-3412-1.aspx
... and another one
http://www.sqlservercentral.com/Forums/Topic1586022-2799-1.aspx
I am doing a bunch of things.
Now I want to do another thing, and it is similar, just in SSIS.
Please tell me exactly how.
Good test for the Crystal Ball to verify it's been correctly repaired. 😉
I'll tell you exactly how:
you give me money, I do it in your place 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2014 at 7:20 am
Oooh, another case for the crystal ball. Or maybe the magic 8-ball...
http://www.sqlservercentral.com/Forums/Topic1586405-2799-1.aspx
Magic 8-ball says "unknown"
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
June 26, 2014 at 4:56 pm
The crystal ball is malfunctioning. Sorry, I'm sending it back to the shop. The next person who wants to try using it is welcome to grab the fees.
PM: Why is this still not done?
ME: l be perfectly happy to finish a piece of your project if you'll STOP CHANGING MY GODDAMNED *nuclear level right goddamned now!* PRIORITIES.
PM: I gave this to you three weeks ago!
ME: You mean the day after the last day I had a day off? Stay still, my vision's a bit blurry so reloading may take a moment.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 26, 2014 at 5:00 pm
Love it when they change priorities, not day by day, but minute by minute basis. Makes it a lot of fun to decipher what really needs to be done.
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
June 26, 2014 at 5:13 pm
Evil Kraig F (6/26/2014)
The crystal ball is malfunctioning. Sorry, I'm sending it back to the shop. The next person who wants to try using it is welcome to grab the fees.PM: Why is this still not done?
ME: l be perfectly happy to finish a piece of your project if you'll STOP CHANGING MY GODDAMNED *nuclear level right goddamned now!* PRIORITIES.
PM: I gave this to you three weeks ago!
ME: You mean the day after the last day I had a day off? Stay still, my vision's a bit blurry so reloading may take a moment.
You must get up to date, crystal is out, Extrasensory perception network is in, still working on the reception though:alien:
😎
June 26, 2014 at 8:07 pm
Eirikur Eiriksson (6/26/2014)
Evil Kraig F (6/26/2014)
The crystal ball is malfunctioning. Sorry, I'm sending it back to the shop. The next person who wants to try using it is welcome to grab the fees.PM: Why is this still not done?
ME: l be perfectly happy to finish a piece of your project if you'll STOP CHANGING MY GODDAMNED *nuclear level right goddamned now!* PRIORITIES.
PM: I gave this to you three weeks ago!
ME: You mean the day after the last day I had a day off? Stay still, my vision's a bit blurry so reloading may take a moment.
You must get up to date, crystal is out, Extrasensory perception network is in, still working on the reception though:alien:
😎
I didn't see you in my office today, Craig, but it sure sounds like you were there.
June 27, 2014 at 2:20 am
Eirikur Eiriksson (6/26/2014)
You must get up to date, crystal is out, Extrasensory perception network is in, still working on the reception though:alien::cool:
The problem with the ESP network is the signal:noise ratio is bad. I don't want to be hearing what all my colleagues are thinking (really don't) while trying to figure out if an OP has ever written T-SQL before. :hehe:
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 - 44,416 through 44,430 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply