March 31, 2015 at 5:20 am
spaghettidba (3/31/2015)
GilaMonster (3/31/2015)
Not efficient as it prevents index seeks, not that a text column can have indexes, but I don't like teaching bad options.Exactly my point: a bad option is what he would have deserved.
But not anyone who ran across the post at a later date from a search.
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
March 31, 2015 at 6:57 am
GilaMonster (3/31/2015)
spaghettidba (3/31/2015)
GilaMonster (3/31/2015)
Not efficient as it prevents index seeks, not that a text column can have indexes, but I don't like teaching bad options.Exactly my point: a bad option is what he would have deserved.
But not anyone who ran across the post at a later date from a search.
I agree. Better no answer at all than one that might hurt someone else.
"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 31, 2015 at 7:01 am
TomThomson (3/30/2015)
GilaMonster (3/30/2015)
Steve Jones - SSC Editor (3/27/2015)
Late to the gender bias thing as I've been skiing all week. Not to open wounds, but I liked this: http://www.sqlservercentral.com/blogs/databases-infrastructure-security/2015/03/18/women-in-technology/I think I'm going to steal this phrase:
I’ve never seen Paris, but that doesn’t mean Paris doesn’t exist.
But, Paris? Me, I've never seen Paris and I would be utterly astounded if he (or either of his fathers-in-law) existed.
😛
March 31, 2015 at 7:04 am
GilaMonster (3/31/2015)
Nice attitude...if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
Dare we ask which poster?
March 31, 2015 at 7:51 am
Brandie Tarvin (3/31/2015)
GilaMonster (3/31/2015)
Nice attitude...if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
Dare we ask which poster?
I'm pretty sure google will find the link to the post I quoted. 😉
New one, hasn't been trained yet. Hope he goes somewhere like StackOverflow and doesn't come back.
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
March 31, 2015 at 8:35 am
Lynn Pettis (3/30/2015)
First day back to work after 4 weeks off. Felt like a new employee. I didn't know where my cube was, my laptop would not connect to the network, I have no real idea what I will be doing yet.The 4 weeks went by too fast, but the last week was fun, went on a college road trip with Kylie, and got to visit with Kirisa and see the Grand Canyon with them both.
Also, bought a new car two weeks ago with the help of my oldest daughter, Kassondra. I have a new 2015 Kia Optima LX, bought and paid for. Kylie and I put 3700+ miles on the car between 3/21 and 3/29. Awesome on gas. Hill City, SD to home in Widefield, CO on ONE tank of gas, 452.0 miles, still had 1/8th of a tank (about 4 gallons as I filled up this morning and only put in 14 gallons).
Welcome back and glad you got some vacation. need to get down there and see you.
March 31, 2015 at 8:37 am
GilaMonster (3/31/2015)
I've been to Paris 5 times and I have not once seen the Eiffel Tower. Therefore the Eiffel Tower does not exist!
Ok, the 5 times I've been to Paris have been 4 to the Airport and 1 where I only saw the inside of two train stations and the Paris Metro and so shouldn't expect to have seen the Eiffel Tower, but I think the phrase works better without the explanation.
Paris used to exist. Haven't been there since '87, but while it was beautiful, didn't enjoy the people very much. I'll have to give it another chance now that I'm older.
March 31, 2015 at 8:45 am
Steve Jones - SSC Editor (3/31/2015)
GilaMonster (3/31/2015)
I've been to Paris 5 times and I have not once seen the Eiffel Tower. Therefore the Eiffel Tower does not exist!
Ok, the 5 times I've been to Paris have been 4 to the Airport and 1 where I only saw the inside of two train stations and the Paris Metro and so shouldn't expect to have seen the Eiffel Tower, but I think the phrase works better without the explanation.
Paris used to exist. Haven't been there since '87, but while it was beautiful, didn't enjoy the people very much. I'll have to give it another chance now that I'm older.
I was there a couple of years ago. I can confirm the Eiffel Tower was there, but not working!
3 very nice snow covered days, and two back to back Marillion concerts - only repeated 4 songs over the two nights. Went via Eurostar. Discovered later that all the trains after the one I was one had been cancelled and a few Brits doing the same thing as me missed out. Steve, it might have been the snow, but I found most of the people there very nice, even with my almost non existent French - whcih I was expecting to be a problem :O
Didn't make it to the louvre, so still have to tick that one off the list, and learn a reasonable amount of French before hand 😉
Rodders...
April 1, 2015 at 5:28 am
Crystal ball to aisle 3 please. Crystal ball to aisle 3.
http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
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
April 1, 2015 at 5:31 am
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Sorry. No crystal here. Just muddy, occluded glass. Would that help?
April 1, 2015 at 5:37 am
Brandie Tarvin (4/1/2015)
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Sorry. No crystal here. Just muddy, occluded glass. Would that help?
Somehow I don't think so.
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
April 1, 2015 at 5:46 am
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Wow. "Here's a screen shot that says the same thing I already typed. That should clear up everything."
Frightening.
"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
April 1, 2015 at 5:51 am
Grant Fritchey (4/1/2015)
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Wow. "Here's a screen shot that says the same thing I already typed. That should clear up everything."
Frightening.
Hahahahahah :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
April 1, 2015 at 8:10 am
GilaMonster (4/1/2015)
Grant Fritchey (4/1/2015)
GilaMonster (4/1/2015)
Crystal ball to aisle 3 please. Crystal ball to aisle 3.http://www.sqlservercentral.com/Forums/Topic1673420-2572-1.aspx
Wow. "Here's a screen shot that says the same thing I already typed. That should clear up everything."
Frightening.
Hahahahahah :hehe: 😀
yeah go figure
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
April 1, 2015 at 8:11 am
Who remembered to do an April Fools post today?
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
Viewing 15 posts - 47,986 through 48,000 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply