Get short, timely messages from Brian Dill.

Twitter is a rich source of instantly updated information. It's easy to stay updated on an incredibly wide variety of topics. Join today and follow @bdill.

Get updates via SMS by texting follow bdill to 40404 in the United States
Codes for other countries

Two-way (sending and receiving) short codes:
Country Code For customers of
Australia
  • 0198089488 Telstra
Canada
  • 21212 (any)
United Kingdom
  • 86444 Vodafone, Orange, 3, O2
Indonesia
  • 89887 AXIS, 3, Telkomsel
Ireland
  • 51210 O2
India
  • 53000 Bharti Airtel, Videocon
Jordan
  • 90903 Zain
New Zealand
  • 8987 Vodafone, Telecom NZ
United States
  • 40404 (any)

bdill

  1. @SQL_Kiwi no luck. 92% is a key lookup. Weirdness. select is 10 seconds (440k records) #sqlhelp 1:42 PM May 21st via TweetDeck in reply to SQL_Kiwi
  2. @SQL_Kiwi no luck. 92% is a key lookup. Weirdness. select is 10 seconds (440k records) 1:40 PM May 21st via TweetDeck in reply to SQL_Kiwi
  3. SEL A, B, C FROM x fast, but INS INTO tmp SEL A, B, C From X is slow? tmp = A VARCHAR(5) NOT NULL, B INT NOT NULL, C INT NOT NULL #sqlhelp 1:12 PM May 21st via TweetDeck
  4. @Sean_Massey thx! Looks like persisted computed col in FK tbl is my issue. My workaround: drop FK, run, add FK back #sqlhelp 5:22 PM Apr 11th via TweetDeck in reply to Sean_Massey
  5. #sqlhelp wtf? INSERT/SELECT generates "query processor could not produce a query plan". Works if I drop FK on inserted tbl. 5:05 PM Apr 11th via TweetDeck
  6. @elijahmanor green day - good riddance (time of our lives) 4:42 PM Jan 1st via TweetDeck in reply to elijahmanor
  7. excited about #bcn11 coming up soon. barcampnashville.org/bcn11/ 7:05 PM Oct 6th, 2011 via web
  8. #sqlhelp - thx to @jdgonzalez - it was parameter sniffing. http://bit.ly/kG2Ds8 now the SP exec plan is same as ad hoc 12:26 PM May 9th, 2011 via TweetDeck
  9. @HenryT the exec plans differ on the ad hoc and the SP. Don't know why that is though 12:15 PM May 9th, 2011 via TweetDeck
  10. @HenryT queries are copy/paste. Y, SP is 30 to 32 sec every time. ad hoc is < 1 every time. back and forth - same result.. 12:14 PM May 9th, 2011 via TweetDeck in reply to HenryT
  11. #sqlhelp I'm at a loss. Big ugly select runs < 1 sec directly , but same code as SP takes 30 sec+. Tried w/ recompile to no avail. 11:48 AM May 9th, 2011 via TweetDeck
  12. @sqlfool odds of sync independent fail: low. Odds of causal fail: very high. A bad PSU can screw up a mobo in no time flat. 12:37 PM Nov 23rd, 2010 via TweetDeck in reply to sqlfool
  13. @BrentO hahah, so does that make you the Czar of the Bro's? :) 6:36 AM Nov 1st, 2010 via TweetDeck in reply to BrentO
  14. #jqueryhelp want to use #jquery to parse a full html doc residing in a textarea. How to make mytextarea.val() be treated like a DOM obj? 11:20 AM Oct 21st, 2010 via TweetDeck
  15. @chaoskitten82 was nice bumping into you at Chuys Sun night. 9:49 PM Oct 17th, 2010 via web
  16. #bcn10 rocked again this year. Thx 2 all organizers, volunteers & speakers. So much knowledge; so little time... 10:54 AM Oct 17th, 2010 via TweetDeck
  17. #bcn10 rocks again. Thx 2 all organizers, volunteers & speakers. 6:14 AM Oct 17th, 2010 via txt
  18. I just got CPR from @ianrhett at #bcn10. Now I'm more effective. 2:29 PM Oct 16th, 2010 via TweetDeck
  19. Just saw awesome presentation by @Kevin_Thompson at #bcn10 on Corp vs LLC. 7:48 AM Oct 16th, 2010 via TweetDeck