August 12, 2011 at 9:03 am
Tom.Thomson (8/12/2011)
Ninja's_RGR'us (8/11/2011)
Tom.Thomson (8/11/2011)
Ninja's_RGR'us (8/11/2011)
If you love synchronicities you'll love the humor in this one!http://www.sqlservercentral.com/Forums/Topic1158766-391-1.aspx
But which is crazier there - the locking hint or the tortuous where clause (getting rid of all those pointless IsNull operations and the ludicrous case statement would give the otimiser a chance to do something with that where clause; with the current awful thing, there's no way the optimiser stands a chance).
Yes, there's synchronicity - the OP name fits both the hint and the where clause very well.
SqlMaverick uses nolock with a nuclear warning on the thread emoticon.
'nuff said 😀
But was the nuclear warning for the hint or the where clause or maybe for both?
You could make a strong case for both. However I always preffer slow data to wrong data... or nuked connection! :alien:
August 12, 2011 at 9:30 am
Brandie Tarvin (8/11/2011)
I'm published again! "Tales We'll Tell Tomorrow" is the final chapter in the Shadowrun Street Legends sourcebook. It's a novelette this time and my editor loved my fight scene.
Congrats, and hope it sells well!
Once again I feel like I've let too much time go without writing a book 🙁
August 12, 2011 at 9:37 am
Lynn Pettis (8/11/2011)
Forever it won't dominate your destiny. Life there is after the dark side.I was going to wait until tomorrow night, but it is close enough.
I am resigning my position with Honeywell. I will be giving my two weeks notice tomorrow.
I have accepted a contract position through TEKSystems at Progressive Insurance here in Colorado Springs.
Congrats!
August 12, 2011 at 9:44 am
Steve Jones - SSC Editor (8/12/2011)
Once again I feel like I've let too much time go without writing a book 🙁
Planning to write a book then? If so, and you need help, count me in. 🙂
-Roy
August 12, 2011 at 9:49 am
Grant Fritchey (8/12/2011)
Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A product of the down tools week experimentation they allow at the company. Check it out.Oh, and there's a competition going on between a couple of teams... guess which one I'm backing.
Looking at it real quick, and I think that app has real merit.
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
August 12, 2011 at 9:51 am
Anybody else feel like reporting this person/post?
:w00t::cool::hehe::w00t:;-):-P:w00t:
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
August 12, 2011 at 9:55 am
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy there (what with being so close to the Dark Side and all). Seriously, I'm glad you're getting back to something that you like a lot better. Hopefully, this will mean that you will be out here on SSC a bit more also!
Thank you Wayne, and I enjoyed your presentation tonight as well.
You know that code for concatenating strings, that was what I could not remember for the life of me when I was up interviewing for a position with Microsoft. Think you can send me that code snippet so I can put it on a flash drive for future reference?
Maybe Wayne could start that blog of his and post it there too?
Seriously, a flash drive just doesn't seem like enough sometimes for all of the scripts.
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
August 12, 2011 at 10:02 am
Roy Ernest (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
Once again I feel like I've let too much time go without writing a book 🙁
Planning to write a book then? If so, and you need help, count me in. 🙂
I have 2 that Red Gate wants me to write, which I keep delaying. I have ideas for fiction, and maybe when I grow up I'll get to be like Brandie. 😛
August 12, 2011 at 10:04 am
SQLRNNR (8/12/2011)
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy there (what with being so close to the Dark Side and all). Seriously, I'm glad you're getting back to something that you like a lot better. Hopefully, this will mean that you will be out here on SSC a bit more also!
Thank you Wayne, and I enjoyed your presentation tonight as well.
You know that code for concatenating strings, that was what I could not remember for the life of me when I was up interviewing for a position with Microsoft. Think you can send me that code snippet so I can put it on a flash drive for future reference?
Maybe Wayne could start that blog of his and post it there too?
Seriously, a flash drive just doesn't seem like enough sometimes for all of the scripts.
http://www.edgetechcorp.com/usb-flash-drives/diskgo-combos-watch-dress.asp
--------------------------------------
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
August 12, 2011 at 10:07 am
Is anyone here working with, or struggling to
- work in a complex development environment that does automated builds at high volumes (> 1x day)
- handle complex continuous development or refactoring of databases
- cloud development or deployment with databases
Red Gate looking to learn more about complex processes and pain points. We have a wandering developer that would like to visit a few places in the US over the next few months.
August 12, 2011 at 10:09 am
Steve Jones - SSC Editor (8/12/2011)
Roy Ernest (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
Once again I feel like I've let too much time go without writing a book 🙁
Planning to write a book then? If so, and you need help, count me in. 🙂
I have 2 that Red Gate wants me to write, which I keep delaying. I have ideas for fiction, and maybe when I grow up I'll get to be like Brandie. 😛
Steve think you should add a third title. "How I Manage My Time to do all the Chores I want/have to do" Might be considered less of a book and more of a instruction manual by some.
August 12, 2011 at 10:13 am
Steve Jones - SSC Editor (8/12/2011)
Is anyone here working with, or struggling to- work in a complex development environment that does automated builds at high volumes (> 1x day)
- handle complex continuous development or refactoring of databases
- cloud development or deployment with databases
Red Gate looking to learn more about complex processes and pain points. We have a wandering developer that would like to visit a few places in the US over the next few months.
CRUD - not at the moment.
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
August 12, 2011 at 10:16 am
bitbucket-25253 (8/12/2011)
Steve think you should add a third title. "How I Manage My Time to do all the Chores I want/have to do" Might be considered less of a book and more of a instruction manual by some.
Lol. I think I could co-author that, if I had time....
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
August 12, 2011 at 10:17 am
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy there (what with being so close to the Dark Side and all). Seriously, I'm glad you're getting back to something that you like a lot better. Hopefully, this will mean that you will be out here on SSC a bit more also!
Thank you Wayne, and I enjoyed your presentation tonight as well.
You know that code for concatenating strings, that was what I could not remember for the life of me when I was up interviewing for a position with Microsoft. Think you can send me that code snippet so I can put it on a flash drive for future reference?
Maybe Wayne could start that blog of his and post it there too?
Seriously, a flash drive just doesn't seem like enough sometimes for all of the scripts.
http://www.edgetechcorp.com/usb-flash-drives/diskgo-combos-watch-dress.asp
Nice gadget - too bad there isn't a 1TB model.
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
August 12, 2011 at 10:30 am
SQLRNNR (8/12/2011)
Stefan Krzywicki (8/12/2011)
SQLRNNR (8/12/2011)
Lynn Pettis (8/11/2011)
WayneS (8/11/2011)
Lynn Pettis (8/11/2011)
...Lynn, I'm very glad that you are moving back. I know you've been a bit unhappy there (what with being so close to the Dark Side and all). Seriously, I'm glad you're getting back to something that you like a lot better. Hopefully, this will mean that you will be out here on SSC a bit more also!
Thank you Wayne, and I enjoyed your presentation tonight as well.
You know that code for concatenating strings, that was what I could not remember for the life of me when I was up interviewing for a position with Microsoft. Think you can send me that code snippet so I can put it on a flash drive for future reference?
Maybe Wayne could start that blog of his and post it there too?
Seriously, a flash drive just doesn't seem like enough sometimes for all of the scripts.
http://www.edgetechcorp.com/usb-flash-drives/diskgo-combos-watch-dress.asp
Nice gadget - too bad there isn't a 1TB model.
Great. A new way for nefarious employees to sneak data out.
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
Viewing 15 posts - 28,996 through 29,010 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply