Sign in or Join FriendFeed
FriendFeed is the easiest way to share online. Learn more »
Jason Strate just showed how to tell which query caused which missing index warning in the DMV #sqlpass
#summit12 #sqlpass this place is just chock full o SWAG
Going to have live music at the end of SQL I/O Uh-Oh, session coming up at 10:15 #sqlpass
Hash warning means query used exceeded memory allocated for operation based on insufficient stats, learning so much at #sqlpass!
Monitoring tempdb contention script from Robert Davis class at #sqlpass, HUGE find!!
Checking out the vendor booths at #sqlpass, bumping into faces from all throughout my SQL career too!
Flash mob at #sqlpass!
#sqlpass dynamic pivot example, really fantastic! Itzik Ben Gan in high gear.
#sqlpass Itzik Ben Gan’s matrix example was simplistically brilliant!!
Partition, unbounded preceding, current row, holy smokes! #sqlpass amazing new stuff.
#sqlpass in Itzik Ben Gan’s class this am, anyone else?
RT @johnolilly: “@FactHive: Price of 1 gb of storage over time: 1981 $300,000 1987 $50,000 1990 $10,000 1994 $1,000 1997 $100 2000 $10 2004 $1 2012 $0.10”
Getting ready this AM to head to Seattle to #sqlpass. Presenting 2 sessions this year, so pretty exciting for me.
Cutting Strips for the Bindings - http://www.youtube.com/watch...
Cutting Strips for the Bindings
Play
#sqlhelp thanks. I know how I do it, but curious to see other solutions. is sp_whoisactive is ok 4 production w/5000+ connections??
#sqlhelp curious to hear preferred/fav ways u all use to quickly detect head of blocking chain
#sqlhelp quick, easy one. 128GB RAM, dedicated x64 SQL Server. How large page file & is Hard Drive location important for page file?
#sqlhelp SQL05 EstExecPlan cost estimate for steps > 100%, some of them in the millions of %. Anyone seen this? Have saved plan to share.
#sqlhelp LIKE with no % does >= and <= whereas = does =, just saying....so odd. Is that normal? Exec Plans diff. Code needs to chg from app
Very odd. ActExecPlan same for = and LIKE w/o %s, but exec time and reads very different. #sqlhelp. Added covering index, prob gone. Nvrmnd
My bad...but very odd. Act Exec Plan shows as same for = and LIKE with no wildcard >= and <=, but execution time and reads vastly different.
#sqlhelp 9.0.4035 using LIKE with no wildcard on either side acts as wildcards on both sides, normal SQL behavior or just this build?
#abq FINALLY talked to shift mgr, she said she'd call back, never did. 8 calls to them & no info on lost item. @avis FAIL. 1 Less Customer!
#abq FINALLY talked to shift mgr, she said she'd call back, never did. 8 calls to them & no info on lost item. @avis FAIL. 1 Less Customer!
#abq #avis @avis lost & found NOT helpful! Left VMs, don't rtrn calls, Mgr VM full, didn't look 4 lost item til asked 2X. Waiting 4 callback
Just dropped off all the clothes for Danyell's memory quilts.
Teaching 6 SQL classes to TMW software users @ our Transforum event this yr in FL. Want to give away SQL books as prizes. Sponsor ideas?
I'm raising $ for a child in my daughter's 3rd grade class who lost her Mom in an accident. No father. Can u help? http://www.indiegogo.com/p...
Other ways to read this feed:Feed readerFacebook