TechNet WebCast: SQL Server Locking & Blocking

Next Monday, I’m presenting a TechNet WebCast for Microsoft Thrive Live! The subject: SQL Server Locking & Blocking Made Simple. Here are the details:

Event Overview

A good working knowledge of how Microsoft SQL Server makes use of locking and transaction isolation levels can help you greatly improve an application’s performance. In this webcast, we explore the SQL Server locking methodology and share techniques for enhancing query response times.

Language(s): English
Product(s): Microsoft SQL Server
Audience(s): IT Generalist
Duration: 60 Minutes
Start Date: Monday, December 07, 2009 9:00 AM Pacific Time (US & Canada)
Event ID: 1032432983

I’d love to have you join me for this free session. Click here to register.

Goodbye Twitter/FaceBook Integration, Hello Readability

I’m me. At least I try to be. I’m not one to put on airs or to be pretentious about things. I’m pretty much a simple what-you-see-is-what-you-get kind of guy. I guess that’s why I once ended up at a fairly exclusive, by-invitation-only, leadership training event in Chicago a few years ago with chicken poo on my shoe, but that’s another story.

Being yourself is easy, despite what Rodney Dangerfield may have said. It’s much easier than trying to be someone else. Or trying to be several someones at different times. As amateur philosopher Kurt Cobain once quipped “Wanting to be someone else is a waste of the person you are.” And while I certainly don’t turn to Cobain’s works for issues of life guidance, that axiom does make a certain amount of sense.

Social Media

I guess that’s one reason why, when I finally started getting involved with Social Media, I didn’t want to create multiple persona’s, each with a distinct group of friends. I didn’t want to have one outlet for my SQL Server Professional colleagues, another for my Church family, yet another for my Scouting friends, and still another for my farming/prepping friends, and who knows how many more. Who has time for all that? Not me!

So, as I joined Twitter and FaceBook and LinkedIn and Plaxo I looked for ways to bring those independent and disparate worlds together. I sought ways to participate in all of them without having to spend a lot of time duplicating my efforts.

After trying a number of different ways to integrate my experiences in the different sites, I found one that seemed to work. I could tweet with Twitter and have those messages automatically become status updates for all the other Social Networking sites. Perfect! Or so I thought.

When Worlds Collide

But I slowly realized (much slower than most of my FaceBook friends would like, I suspect) that what seemed like a good idea at the time, really wasn’t.

Conversations I had with my Twitter friends were automatically finding their way to FaceBook, LinkedIn, and Plaxo status messages. Seeing one side of a conversation was definitely confusing to my non-Twitter friends. When combined with the hash tags, the non-intuitive reply nomenclature, and the technical acronyms of my chosen profession, most of my FaceBook statuses were utterly nonsensical.

Separate But Equal

So at long last, I’ve decided to completely sever the Twitter to other Social Media links in my Social Networking endeavors. My FaceBook friends will no longer have to put up with partial conversations, incoherent techno-babble, and strange looking, comic-book-cussing-like status updates. My tweets will be tweets and my status updates will be status updates and never the twain shall meet.

An Exception to Every Rule

Every rule has an exception (except that rule, right?). I have found a way to post status updates to all of my Social Media sites using one source – Ping.fm. When I feel that a single status update is relevant everywhere, I’ll use my Ping.fm acount to send it to all sites simultaneously. But rest assured that will be few and far between.

What about you?

I’d like to hear how you’ve tackled this modern day Chinese finger trap known as Social Media.

  • Are you active in more than one Social Media?
  • Have you tried to integrate them in some way?
  • What have your experiences been?

Indentifying Performance Bottlenecks presentation

heartmonitor-2009-11-13c

Thanks to everyone who attended the State of Tennessee’s .NET User Group meeting yesterday. I really enjoyed spending time with you and learning about how you use SQL Server and some of the challenges you face.

As promised, here is a copy of the presentation materials that I used during the session.

Speaking at the .NET User Group meeting

cogs2009-11-10When a SQL Server application is under performing, how can you isolate where the actual problem is? Would more memory help? What about adding additional processors? Or maybe some indexes are missing?

At the Tennessee State Employee’s .NET User Group meeting this Thursday (November 12th, 2009), I will demonstrate how SQL Profiler and Performance Monitor can be used to uncover your SQL Server’s bottleneck.

If you’d like more information about this meeting, just send me an email. I hope to see you there.

 

SQL Server MVP Deep Dives Book Signing at PASS

The PASS Community Summit is one of the highlights of my professional year. It’s a time when members of the SQL Community from around the globe can gather together at one place for learning, sharing, and networking. As I’ve often said, the best part about the PASS Community Summit is getting to catch up with friends that I only see once or twice a year. I love that.

And this year’s Summit was doubly special in that regard. This year I was able to get together with a bunch of other folks for the official release of the SQL Server MVP Deep Dives book.

If you haven’t already heard, 52 really smart people and I got together to write a SQL Server book. All of the proceeds from the book are being donated to charity, WarChild.org.

It was a great pleasure and honor to work with Manning Publications and this group of renowned experts in their field to benefit a charity that crosses geographical, political, and socioeconomic boundaries to help children in war ravaged parts of the world.

And it was rewarding to see how the SQL community at PASS responded. The conference bookstore sold out of the book after the first day of the conference and sales of the book surpassed all prior title sales at the conference by a factor of five!

Those who bought a book on-site were able to get it signed by many of the authors; 35 were at the conference.

All in all, this was a special time and I hope you consider buying the book and supporting the effort and WarChild.

Day 1 of PASS

Day 1 of the PASS Community Summit 2009 was a great day; lots of fun and good information.

Thanks for everyone who attended my Birds-of-a-Feather table during lunch. Feel free to shoot me an email to stay in touch.

And a big thanks to everyone who came to my “Enhance Your T-SQL for Better Performance” session yesterday afternoon. The demo code will be available on the PASS Summit site and my blog site in the next day or two. Stay tuned.

Here are my notes from Day 1 of the 2009 PASS Community Summit.

  • http://twitpic.com/o79jd @kekline has a long line at the Quest booth for his book signing at # sqlpassabout 14 hours ago from TweetDeck
  • Need to think about having a Twitter monitor during one of my sessions much like @PaulRandal did for @KimberyLTripp. That was good. #sqlpassabout 15 hours ago from TweetDeck
  • Need to think about having a dedicated Twitter monitor during one of my sessions much like @PaulRandal did for @KimberyLTripp. That was goodabout 15 hours ago from TweetDeck
  • Moving from the 6th Floor of #sqlpass where I was working down to the Exhibitors Reception on the 4th Floor. #sqlbingoabout 15 hours ago from TweetDeck
  • OH “Today has been really great.” talking about #sqlpass.about 15 hours ago from TweetDeck
  • @PaulRandal Cool that you’re monitoring this. I just pointed someone at #sqlpass to your blog post about it too.about 15 hours ago from TweetDeck in reply to PaulRandal
  • @AndyLeonard Did you just vote for something?about 15 hours ago from TweetDeck in reply to AndyLeonard
  • @kbriankelley hesitantly clicked on the link. Yeah, @PaulRandal had this convo on twitter a while back too. Just caught up with @AjarnMarkabout 15 hours ago from TweetDeck in reply to kbriankelley
  • @t_burger Not in there right now, but I’m on twitter so keep us posted. :) #sqlpassabout 15 hours ago from TweetDeck in reply to t_burger
  • @Tim_Mitchell Pleasure was all mine! Hoping to catch up with you more before #sqlpass is over.about 16 hours ago from TweetDeck in reply to Tim_Mitchell
  • @SQLSarg @kbriankelley Yes, that’s dated recommendations from what I understand. Was it the presenter that said it? #sqlpassabout 16 hours ago from TweetDeck
  • @t_burger Excellent point. I’ll PASS this along to the program folks.about 16 hours ago from TweetDeck in reply to t_burger
  • is hanging out on the 6th floor at #sqlpass catching up on email and work related activities. #sqlbingoabout 16 hours ago from TweetDeck
  • @WesBrownSQL I don’t about being the guy, but I’m more than happy to talk. Now work?about 17 hours ago from TweetDeck in reply to WesBrownSQL
  • Excellent session by @kekline at #sqlpass. His voice lasted through the whole session. Woot!about 17 hours ago from TweetDeck
  • Need to try out OpenDbDiff – free tool to compare and sync 2 databases – @kekline at #sqlpassabout 17 hours ago from TweetDeck
  • YourSQLDBA, AITScripts, AbaPerls, OlaH, Product Sample Scripts – more free stuff mentioned in @kekline’s session at #sqlpassabout 17 hours ago from TweetDeck
  • OH “If you’re not a script person, I need to slap you on the wrist and chastize you.” ~ @kekline at #sqlpassabout 17 hours ago from TweetDeck
  • CEO to DBA – “Hey, I was reading this thing in SkyMall and we’re going to be implementing it next week.” @kekline at #sqlpassabout 17 hours ago from TweetDeck
  • FineBuild, Assessment & Planning Toolkit, Infrastructure Planning and Design Guide, Best Practice Analyzer – more tools @kekline at #sqlpassabout 17 hours ago from TweetDeck
  • glowing accounts of tools by created @sqlsarg and @MladenPrajdic by @kekline at #sqlpassabout 18 hours ago from TweetDeck
  • SSMS Tools Pack, Tarantino, SQLPSX are some more tools shared/recommended by @kekline at #sqlpassabout 18 hours ago from TweetDeck
  • Extended Events Manager, MSSQL Blocks, Internals Viewer, StandardCDC are some of the tools @kekline is sharing at #sqlpassabout 18 hours ago from TweetDeck
  • if you attended my session today and have the inclination, please let me know how I did at http://bit.ly/3N6tHj (Speakerrate.com) #sqlpassabout 18 hours ago from TweetDeck
  • if you attended my session today and have the inclination, please let me know how I did at http://bit.ly/3N6tHj (Speakerrate.com)about 18 hours ago from TweetDeck
  • OH “With stick figures, you’re not going to get too unsafe for work” ~ @kekline at #sqlpassabout 18 hours ago from TweetDeck
  • OH “There’s no patch for stupidity!” @kekline is cracking the room up at #sqlpass.about 18 hours ago from TweetDeck
  • @leeannepedersen @t_burger @billinkc @mike_walsh Thanks for coming to and tweeting about my session today. #sqlpassabout 18 hours ago from TweetDeck
  • OH “Strap on your goofy, because we’re going to go 100 mph” ~ @kekline #sqlpassabout 18 hours ago from TweetDeck
  • sitting in @kekline’s session in room 615 at #sqlpass on free tools in SQL Server. He’s going to cover a ton of info.about 18 hours ago from TweetDeck
  • RT @SQLRockstar: meeting @PaulRandal -Tripp #passawesomeness #sqlpass <– getting absolutely spanked by them in the SQL Bowl was fun too.about 18 hours ago from TweetDeck
  • Thanks to everyone who attended my T-SQL session today. I hope you found it worth while. #sqlpass #sqlbingoabout 18 hours ago from TweetDeck
  • @billinkc doh! Thanks for letting me know about the typo!about 18 hours ago from TweetDeck in reply to billinkc
  • getting setup for my T-SQL session in room 615-617 – #sqlpass #sqlbingoabout 20 hours ago from TweetDeck
  • Had a wonderful BOF talk with Tim, Trevor, Andrew, Steven, & JR. #sqlpassabout 20 hours ago from TweetDeck
  • heading to the Birds-of-a-Feather luncheon; hosting the IT Consulting table. If you’ve ever thought about IT consulting, join me #sqlpassabout 22 hours ago from TweetDeck
  • OH “Professional organization membership and volunteer activities adds a lot of value when you’re interviewing.” @sqlboywonder at #sqlpassabout 22 hours ago from TweetDeck
  • @kbriankelley LOL! Yeah, maybe…about 22 hours ago from TweetDeck in reply to kbriankelley
  • there are 150 copies of the SQL Server MVP Deep Dives book for sale at the #sqlpass conference bookstore. We’re having a book signing Wed.about 22 hours ago from TweetDeck
  • OH “We have a guy in my office. We’re lucky if he wears pants in the winter…..he wears short.” ~ @sqlboywonder. #sqlpassabout 22 hours ago from TweetDeck
  • @onpnt “Tell me about a time when you worked on a project that didn’t go as planned and how you handled it.” Role playing as a demo #sqlpassabout 22 hours ago from TweetDeck in reply to onpnt
  • just asked an interview question to @sqlboywonder in his soft skills session at #sqlpass.about 22 hours ago from TweetDeck
  • sitting in @sqlboywonder’s session on soft skills at #sqlpass.about 22 hours ago from TweetDeck
  • sitting in @sqlboywonder’s session on soft skills.about 22 hours ago from TweetDeck
  • Was sitting beside @sqlboywonder in the #sqlpass keynote. He’s leaving to get ready for his soft skills presentation at 1015am pst.about 23 hours ago from TweetDeck
  • RT @unclebiguns: RT @kekline: Will entity framework futures bring DBAs and devs closer together or drive them further apart? #sqlpassabout 23 hours ago from TweetDeck
  • People are getting a bit antsy. This is a long keynote at #sqlpass. We’re at nearly 2 hours already. People starting to trickle out.about 23 hours ago from TweetDeck
  • tweeting drains my laptop’s battery quickly; about to failover to my iPhone for tweets. #sqlpassabout 24 hours ago from TweetDeck
  • RT @buckwoody: #sqlpass Good recovery. Note to self: don’t hit “help” in CTP1…about 24 hours ago from TweetDeck
  • uh-oh, Step 1 of a simple 5 step process just produced an error. Nice recovery though. #sqlpass.about 24 hours ago from TweetDeck
  • if the #sqlpass Keynote goes much longer, Ted Kummert will glow in the dark. He’s standing way too close to the humming 192 CPU box.about 24 hours ago from TweetDeck
  • RT @AndyLeonard: I’m so jealous @way0utwest – I haven’t received a @SqlRockStar sticker… :{< <– barter for bacon.about 24 hours ago from TweetDeck
  • RT @way0utwest: I got a SQL Bits mug at #sqlpass, along with a sqlrockstar sticker. Another reason to come to the Summit.about 24 hours ago from TweetDeck
  • RT @SQLChicken: RT @blythemorrow: everyone at #sqlpass can come meet PASS Director @douglasmcdowell from 10-11 today at the PASS Boothabout 24 hours ago from TweetDeck
  • When the fans for a192 CPU server all kick on at one time, it sounds like an Apache helicopter is buzzing by. #sqlpassabout 24 hours ago from TweetDeck
  • @SQLSarg Thanks for the RT with the #sqlpass hash tag. Too much good stuff to remember everything.about 24 hours ago from TweetDeck in reply to SQLSarg
  • Note to self: practice typing while listening to important stuff before #sqlpass next year.about 24 hours ago from TweetDeck
  • got a demo from @AndyLeonard last night of his AndyWeather setup: weather station, twitter api & SSIS to tweet weather in Farmville #sqlpassabout 24 hours ago from TweetDeck
  • just blogged Day Zero of PASS (Pre-conference Seminar with Kim Tripp) – http://bit.ly/49960habout 24 hours ago from TweetDeck
  • RT @buckwoody: #sqlpass SQL Server ships more units than Oracle and DB2 combined <– WOW!!1 day ago from TweetDeck
  • photos of Rushabh standing in for Donald Farmer. He’s wearing a long haired wig. Very funny. Hope the photos are available later #sqlpass9:00 AM Nov 3rd from TweetDeck
  • Ted is sharing photos of Wayne Snyder from last year when he was on stage on a Harley Davidson #sqlpass.8:59 AM Nov 3rd from TweetDeck
  • Ted Kummert is sharing his Top 5 reasons it’s great to be at PASS. #sqlpass.8:56 AM Nov 3rd from TweetDeck
  • SQL Server 2008 R2 is coming in the first half of next year according to Ted Kummert. Should be an exciting year for SQL Server. #sqlpass8:55 AM Nov 3rd from TweetDeck
  • Ted Kummet, Senior VP of a bunch of stuff at Microsoft is taking the stage to Sharp Dressed Man at #sqlpass The room is packed.8:53 AM Nov 3rd from TweetDeck
  • OH “The cloud is about providing IT as a service to businesses” ~ Bob Muglia at #sqlpass8:43 AM Nov 3rd from TweetDeck
  • OH “We’re on a journey to Virtualization and that should help…..” ~ Bob Muglia at #sqlpass8:38 AM Nov 3rd from TweetDeck
  • just saw a 192 processor box running Microsoft SQL Server. Going to CDW.com now to see if I can order one. hahahaha #sqlpass8:28 AM Nov 3rd from TweetDeck
  • Bob Muglia, President of Server and Tools Business for Microsoft is taking the stage at #sqlpass to the tune of Back in Black by AC/DC.8:19 AM Nov 3rd from TweetDeck
  • Q&A with the PASS Board on Wednesday afternoon 430pm in room 6E at #sqlpass.8:15 AM Nov 3rd from TweetDeck
  • Is sittting in the opening keynote of #sqlpass listening to Wayne Snyder talk about the SQL community.8:11 AM Nov 3rd from TweetDeck
  • @mike_walsh still in the Sheraton lobby? Looked around but haven’t been able to connect with you.5:51 AM Nov 3rd from TweetDeck in reply to mike_walsh
  • Heading over to the Sheraton lobby for some early morning fellowship at #sqlpass.5:39 AM Nov 3rd from TweetDeck
  • @MladenPrajdic will do as soon as I I boot up my laptop. I’m tweeting from my iPhone currently.5:35 AM Nov 3rd from TweetDeck in reply to MladenPrajdic
  • @MladenPrajdic on the #sqlpass web site for the summit, there’s a downloadable xls sheet of the agenda. If you can’t find it, I’ll email5:08 AM Nov 3rd from TweetDeck in reply to MladenPrajdic
  • @BrentO yep, it’s going to be a great, albeit, long day at #sqlpass.5:04 AM Nov 3rd from TweetDeck in reply to BrentO
  • As a square in the #sqlpass #sqlbingo game, I’ll be tweeting my schedule throughout the day. Looking forward to meeting folks!4:54 AM Nov 3rd from TweetDeck
  • Good morning SQL Tweeps! Welcome to Day 1 of #sqlpass. It’s going to be a fun day.4:46 AM Nov 3rd from TweetDeck

Day Zero of PASS (Pre-conference seminar with Kim Tripp)

This week, I’m blogging and tweeting from the PASS Community Summit in Seattle, Washington. The week of the Summit is always a great, exciting, and busy time for me. I absolutely love the technical eduction and networking opportunities afforded to the attendees.

This year, I’ve decided to tweet regularly throughout the week in an effort to 1) share with those following the #sqlpass hash tag over Twitter and 2) preserve my notes for me to review later on. You can follow my tweets directly via Twitter.

Here’s a list of yesterday’s tweets. Most of the day was spent in Kimberly L Tripp’s pre-conference seminar on Indexing. Excellent information and presentation!

And last night, I served as one of six contestants in the Quiz Bowl. Grant Fritchey and I were a team. Kevin Kline and Brent Ozar were a team. And Kimberly Tripp and Paul Randal teamed up as well.  Guess who won.

Yesterday’s tweets:

  • @sqlagentman from my perspective it was a blast! Would do gladly do it again.about 10 hours ago from TweetDeck in reply to sqlagentman
  • @sqlandy is giving the PASS log reader awards at # sqlpass welcome reception.about 13 hours ago from TweetDeck
  • Is at the #sqlpass welcome reception.about 14 hours ago from Ping.fm
  • SQL server MVP Deep Dives book http://twitpic.com/o2tek at #sqlpass. Book sighing later this week.about 14 hours ago from TweetDeck
  • @buckwoody lol! Now I understand why he asked me.about 14 hours ago from TweetDeck in reply to buckwoody
  • Saw the printed copy of the Sql Server MVP Deep Dives book at the #sqlpass book store. Proceeds go to War Child charity. Buy one today.about 14 hours ago from TweetDeck
  • Heading to the #sqlpass quiz bowl, filling in for @buckwoody on the condition that none of my answers need be right.about 14 hours ago from TweetDeck
  • Amazed to see this at the #sqlpass lunch today. http://twitpic.com/o2qnmabout 15 hours ago from TweetDeck
  • @drsql was @sqlagentman kidding me? Said it was like “Let’s make a deal”? I’ve already changed into a costume for the #sqlpass quiz bowl :) about 15 hours ago from TweetDeck in reply to drsql
  • RT @SQLRockstar: @peschkaj there are snacks at the welcome reception #sqlpassabout 15 hours ago from TweetDeck
  • Heard that over 700 abstracts were received by #sqlpass for a limited number of sessions. Can’t believe I got selected for 2. Humbled!about 15 hours ago from TweetDeck
  • Speakers at #sqlpass are being recorded (audio & screen). Session recordings will be available for sell 125USD.about 15 hours ago from TweetDeck
  • RT @BrentO: #SQLPASS speakers need to check into room 605 (the ready room) one hour before each presentation.about 15 hours ago from TweetDeck
  • Douglas McDowell is doing a good job subbing for Linda Rab in the speaker orientation.about 15 hours ago from TweetDeck
  • Is sitting in the Speaker Orientation meeting at #sqlpass. I’m surrounded by the who’s who of the SQL world.about 15 hours ago from TweetDeck
  • If @brento gets any more stickers, he’ll need to buy a bigger laptop; do they make 27 inch macs?about 15 hours ago from TweetDeck
  • @t_burger I agree! Having @paulrandal monitoring email/tweets during @KimberlyLTripp’s session was a great value add! #ktprecon #sqlpassabout 16 hours ago from TweetDeck in reply to t_burger
  • Search for “Bart Duncan missing” to see his queries for missing indexes. #ktprecon #sqlpassabout 16 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass Craig Freedman’s blog on index_operational_stats http://bit.ly/BVcIVabout 16 hours ago from TweetDeck
  • @marcbeacom great to meet you earlier today! Hope we get a chance to catch up more.about 16 hours ago from TweetDeck in reply to marcbeacom
  • Note to self: any plan that includes do something and wait to see if anyone complains is probably not good. #sqlpass #ktpreconabout 16 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass Whitepaper comparing heaps and clustered indexes http://bit.ly/HPonNabout 16 hours ago from TweetDeck
  • OH “SQL Server will let you create as many useless indexes as you like” #ktprecon #sqlpassabout 16 hours ago from TweetDeck
  • @mrdenny I don’t see anyone in here with blue hair. Are you in the room?about 16 hours ago from TweetDeck in reply to mrdenny
  • OH “Check out SQLSkills site for White Papers on Indexed Views. They should be one of your top 3-4 favorite features.” #ktprecon # sqlpassabout 16 hours ago from TweetDeck
  • For inner joins there is no benefit to putting search criteria in the join/from clause, so keep it in where clause. #ktprecon #sqlpassabout 16 hours ago from TweetDeck
  • Got back to #ktprecon just in time to realize that I missed some great stuff. She talking join strategies now. #sqlpass.about 16 hours ago from TweetDeck
  • OH “set, set, squish is way better than set, set, squish, sort” ~ @kimberlyLTripp in #ktprecon at #sqlpass.about 16 hours ago from TweetDeck
  • RT @bradmcgehee: #SQLPASS Speakers: Don’t forget to attend speaker’s meeting at 5PM in room 606-607.about 16 hours ago from TweetDeck
  • Spent some time with Christoph & Jeremiah this afternoon. I love the sidebar conversations at #sqlpass. It’s all about people.about 16 hours ago from TweetDeck
  • @t_burger thanks Teresa! I can’t believe I missed the entire afternoon of @Kimberlyltripp’s session! Have to review @paulrandal’s tweets.about 16 hours ago from TweetDeck in reply to t_burger
  • Haven’t made it back to #ktprecon. Just had great conversation with @buckwoody. Now talking with another friend, Christoph. I love #sqlpassabout 18 hours ago from Ping.fm
  • @JohnZFields will let you know if I turn this into a blog post.about 20 hours ago from TweetDeck in reply to JohnZFields
  • @JohnZFields will also prevent covering nonclustered indexes forcing key lookups or table scans. #sqlpass #ktpreconabout 20 hours ago from TweetDeck in reply to JohnZFields
  • OH “if stats were perfectly accurate, they’d be as large as your data.” ~ @KimberlyLTripp in #sqlpass #ktpreconabout 20 hours ago from TweetDeck
  • @JohnZFields Bunch of reasons. More data returned than needed, esp in lots of joins. Can’t tune indexes #sqlpass #ktprecon. May blog moreabout 20 hours ago from TweetDeck in reply to JohnZFields
  • Isolate columns in your WHERE clause so that SQL server can seek rather than scan. I mention this too in my session. #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • Don’t use SELECT * in queries!!! #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • Got to watch out for DTA. It’ll tell you to create a bunch of new indexes rather than adjusting the current ones. #ktprecon #sqlpassabout 21 hours ago from TweetDeck
  • Index intersection will be discussed this afternoon in #ktprecon at #sqlpass. SQL server using > 1 index to cover a query.about 21 hours ago from TweetDeck
  • OH “clustered index scans are full table scans” ~ @kimberlyltripp #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • You really need to know where your IOs are coming from – leaf or root node – makes a big diiference. #ktprecon #sqlpassabout 21 hours ago from TweetDeck
  • @bradmcgehee it was a tough call for me this morning choosing between Insiders session and #ktprecon. Happy to be here. #sqlpassabout 21 hours ago from TweetDeck in reply to bradmcgehee
  • @kimberlyltripp makes SQL server internals understandable. Mark of someone who knows her stuff. #sqlpass #ktpreconabout 21 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass Demo scripts (and companion content for the internals book chapter) are at http://bit.ly/42zJ4cabout 21 hours ago from TweetDeck
  • @mdefehr by the end of #sqlpass, you’ll wish there were about 16 of you so you could see it all, plus get a little sleep at some point.about 21 hours ago from TweetDeck in reply to mdefehr
  • @mike_walsh I know the feeling. Been self employed for 15 yrs and try very hard to keep it local or rdp to clients. Some travel required thoabout 21 hours ago from TweetDeck in reply to mike_walsh
  • RT @PaulRandal: #ktprecon #sqlpass Do page splits ever roll back? No: script to prove it: http://bit.ly/2IgMM3about 21 hours ago from TweetDeck
  • Live from #ktprecon at #sqlpass. http://twitpic.com/o13umabout 21 hours ago from TweetDeck
  • RT @paulrandal: #ktprecon #sqlpass How expensive are page splits in terms of transaction log? http://bit.ly/MqUgUabout 21 hours ago from TweetDeck
  • @paulrandal has a blog post on just how expensive page splits are search the SQLSkills site for it. #sqlpassabout 21 hours ago from TweetDeck
  • Loves that the #sqlpass booth has a running Twitter search on #sqlpass hash tag.about 21 hours ago from TweetDeck
  • @paulrandal I think it’s a city ordinance in Seattle that coffee decanters should never be empty for more than 5 minutes. #sqlpassabout 22 hours ago from TweetDeck in reply to PaulRandal
  • @kimberlyltripp is explaining b-tree structures and indexes at #sqlpass #ktpreconabout 22 hours ago from TweetDeck
  • RT @DamonRipper: Just got to meet and chat with@joewebb during break time #sqlpass. <– pleasure was all mine.about 22 hours ago from TweetDeck
  • RT @ManningBooks: Are you at #SQLPASS? Pick up a copy of SQL Server MVP Deep Dives and get it signed at the launch http://bit.ly/30QWor #sqlabout 22 hours ago from TweetDeck
  • Stomach is growling. Looking at the guy beside me and shaking my head; hopefully he’ll think it’s his stomach. Learned that from Bro Jon.about 22 hours ago from TweetDeck
  • Note to self: be early to breakfast & snacks; they go fast at #sqlpass.about 22 hours ago from TweetDeck
  • OH “the more narrow your queries are, the more you can tune them and the better they are.” ~ @kimberlyltripp at #sqlpass #ktpreconabout 22 hours ago from TweetDeck
  • Want to follow what’s going on at #sqlpass? Do a search and follow the #sqlpass hash tag. Lots of good info there.about 22 hours ago from TweetDeck
  • @buckwoody is back in #ktprecon at #sqlpassabout 22 hours ago from TweetDeck in reply to buckwoody
  • RT @PaulRandal: #ktprecon #sqlpass Ola Hallengren’s *wonderful* db maintenance script: http://bit.ly/3R5OUvabout 23 hours ago from TweetDeck
  • Go to @paulrandal’s blog, go to example scripts, and follow the link to Ola’s maintenance scripts. #sqlpass #ktprecon <- excellent stuff!about 23 hours ago from TweetDeck
  • @kimberlyltripp just answered a question with “it depends” hahahahaha! #sqlpass #ktpreconabout 23 hours ago from TweetDeck
  • @SQLChicken @paulrandal is monitoring the #sqlpass and #ktprecon hash tags.about 23 hours ago from TweetDeck in reply to SQLChicken
  • @SQLChicken here’s a link thatat help http://bit.ly/2CkTY7about 23 hours ago from TweetDeck in reply to SQLChicken
  • Wonder where the in-room coffee is in the precons?!? I need some but don’t want to leave to find it. Definition of quandry. #sqlpassabout 23 hours ago from TweetDeck
  • Wonder where the in-room coffee is in the precons?!? I need some but don’t want to leave to find it. Definition of quandry.about 23 hours ago from TweetDeck
  • Thinks Kimberly Tripp’s indexing session is should be “required reading” for DBAs. #sqlpass #ktpreconabout 23 hours ago from TweetDeck
  • @paulrandal is there a hash tag for this session? #sqlpassabout 23 hours ago from TweetDeck
  • @buckwoody just walked into Kim Tripp’s session grinning. Wonder what he’s up to. #sqlpassabout 23 hours ago from TweetDeck
  • OH You can all name your monsters ~ Kimberly Tripp #sqlpass.about 24 hours ago from TweetDeck
  • Wishes that every table in the room had a power strip. #sqlpass.about 24 hours ago from TweetDeck
  • @PaulRandal is tweeting while Kimberly is speaking. Cool.about 24 hours ago from TweetDeck in reply to PaulRandal
  • Is sitting in Kimberly Tripp & Paul Randal’s session on indexing. #sqlpass. Preparing my brain to drink from a firehose.about 24 hours ago from TweetDeck

Follow

Get every new post delivered to your Inbox.