Search results matching tags 'Internals' and 'People'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Internals,People&orTags=0Search results matching tags 'Internals' and 'People'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Understanding Execution Planshttp://sqlblog.com/blogs/hugo_kornelis/archive/2013/12/12/understanding-execution-plans.aspxThu, 12 Dec 2013 21:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:52126Hugo Kornelis<p>To me, it feels as if 2014 is a long time away. But it isn’t. <a href="http://en.wikipedia.org/wiki/Sinterklaas" mce_href="http://en.wikipedia.org/wiki/Sinterklaas">Sinterklaas</a> has already dropped off his presents and is probably already back in his castle in Spain. Christmas is almost upon us. And before we know it, we’ll be washing <a href="http://en.wikipedia.org/wiki/Oliebol" mce_href="http://en.wikipedia.org/wiki/Oliebol">oliebollen</a> down with <a href="http://en.wikipedia.org/wiki/Champagne" mce_href="http://en.wikipedia.org/wiki/Champagne">Champagne</a>.</p> <p>That also means that I need to get cracking on preparing my precon seminar on execution plans. What precon seminar you say? Oh right – I didn’t tell you yet. The good folks organizing <a href="http://www.sqlsaturday.com/269/eventhome.aspx" mce_href="http://www.sqlsaturday.com/269/eventhome.aspx">SQL Saturday #269 in Exeter (UK)</a> (on March 22) have decided to extend the event with a full training day on Friday March 21. For that purpose, they invited eight of the best SQL Server speakers in the world, and me, to spend a whole day pouring our knowledge into other people’s heads.</p> <p>The full program for this excellent day can be found <a href="http://sqlsouthwest.co.uk/sql-saturday-269-precon-training-day-details/" mce_href="http://sqlsouthwest.co.uk/sql-saturday-269-precon-training-day-details/">here</a> – and believe me, if I was not speaking that day, I would be trying to clone myself and visit at least four of them!</p> <p><a href="http://sqlsouthwest.co.uk/hugo-kornelis-profile-and-session-details/" mce_href="http://sqlsouthwest.co.uk/hugo-kornelis-profile-and-session-details/">My session</a> on that day, as you can see, focuses on execution plans. So what can you expect if you sign up? Here is a short overview.</p> <p>I will start with the bare basics. What is an execution plan, what is its role in a SQL Server database, and most of all – how can you get to see it, how do you start reading it (Left to right? Right to left?), and how do you get to those extremely interesting details that Microsoft has carefully hidden from view? Why is an estimated plan not estimated, why is an actual plan actually mostly an estimated plan? What is an iterator, what does it do, and how does it interact with other operators?</p> <p>After that, we’ll dive into the details. What is a seek, what is a scan? How do you notice when a seek secretly scans, and why should you care? Why do people say scans are bad, and why are they wrong? (Or, maybe even more important, <b>WHEN</b> are they wrong, and when not?)</p> <p>Next up are the joins. Inner, outer, loop, merge, hash – but also semi, and anti semi. Yes, those are all join types, and we will explore them all. How do they work, what are the benefits and what are the costs of all of them? How can you influence the type of join chosen, and why would you want to?</p> <p>All that, and much more, will be included in my seminar. And that’s just what I have planned for <i>before</i> lunch. At the end of the day, you can expect to have a good working knowledge of almost every iterator that you can encounter in an execution plan. I will also explain what has changed in execution plans in SQL Server 2012 and SQL Server 2014. And to ensure that nobody falls asleep from my constant talking, I will give you all some exercises in between, challenging you to immediately apply what you just learned. These exercises may not be the kind of exercises you expect - but trust me, you will find them to be fun and refreshing, and they will also learn you how to apply your knowledge to all kinds of problems.<br></p> <p>Does this sounds interesting or useful at all to you? I hope so – why else are you on a SQL Server blog site? So get cracking – <a href="https://sqlsouthwest.sharepoint.com/_layouts/15/WopiFrame.aspx?guestaccesstoken=Svcf%2b1fS2UNWvqmIo%2b4QMHnQwC3HwFFQumUI8pM%2fpAw%3d&amp;docid=1_1f6ec6454084e4707babeb1ef68201aee&amp;wdFormId=%7b392D80F9-4C85-47F2-B457-D262E005B152%7d&amp;action=formsubmit" mce_href="https://sqlsouthwest.sharepoint.com/_layouts/15/WopiFrame.aspx?guestaccesstoken=Svcf%2b1fS2UNWvqmIo%2b4QMHnQwC3HwFFQumUI8pM%2fpAw%3d&amp;docid=1_1f6ec6454084e4707babeb1ef68201aee&amp;wdFormId=%7b392D80F9-4C85-47F2-B457-D262E005B152%7d&amp;action=formsubmit">click this link</a> and sign up for my precon right now. (Or for one of the other precons – they are all great!) If you do so soon enough, you can still apply for the special “Early Bird” rate of only £150 – which is valid until December 15. But don’t despair if you see this post later – from December 16 until February 28, you still only pay £185 – still a steal for a whole day of training! (Even the £200 last minute rate that applies from March 1<sup>st</sup> is great value – but honestly, why wait?)</p> <p>I am looking forward to visiting Exeter this March. I hope to see all of you there. Either in my precon – or if you choose to attend one of the other precons, then maybe in one of the many sessions that will take place the next day.</p>Bleeding Edge 2012 – session materialhttp://sqlblog.com/blogs/hugo_kornelis/archive/2012/10/27/bleeding-edge-2012-session-material.aspxSat, 27 Oct 2012 10:46:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:45812Hugo Kornelis<p>As promised, here are the slide deck and demo code I used for my presentation at the <a href="http://www.bleedingedge.si/Conference">Bleeding Edge 2012 conference</a> in Laško, Slovenia. Okay, I promised to have them up by Tuesday or Wednesday at worst, and it is now Saturday – my apologies for the delay.</p> <p>Thanks again to all the attendees of my session. I hope you enjoyed it, and if you have any question then please don’t hesitate to get in touch with me.</p> <p>I had a great time in Slovenia, both during the event and in the after hours. Even if everything the tour guide said during the tour of the Laško brewery was lost on me (in his defense, he <i>did</i> offer to translate the Slovenian explanations to Russian), I still liked it – especially the part where we got to sample some of the produce!</p> <p>I truly hope that there will be another Bleeding Edge conference next year. And if there is, I definitely want to speak there again!</p>Back in Atlanta! Wed, Feb 9 2011http://sqlblog.com/blogs/kevin_kline/archive/2011/02/07/back-in-atlanta-wed-feb-9-2011.aspxMon, 07 Feb 2011 17:04:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33270KKline<br><div id="refHTML"></div><p>
<a href="http://kevinekline.com/wp-content/uploads/2011/02/Chicago-SQL-Saturday-31.jpg"><img src="http://kevinekline.com/wp-content/uploads/2011/02/Chicago-SQL-Saturday-31-300x275.jpg" class="size-medium wp-image-1525" title="Chicago SQL Saturday 31" alt="" height="275" width="300"></a>
</p><p>
I always enjoy spending time with my friends from Atlanta, as well as meeting folks and making new friends. If you live in the Atlanta area, I hope you'll join me on the evening of Wednesday, February 9th, 2011. Details are at the <a href="http://www.atlantamdf.com" title="What's with the &quot;MDF&quot;?" target="_blank">Atlanta SQL Server user group website</a>.
</p><p>
It's common knowledge that I have a terrible memory for many things. However, one of the few things that my memory is usually really good at is remember names &amp; faces (and remembering stories, but that is another story as well).
</p><p>It's only in the last couple years that I've gotten to know Atlanta-area folks like Aaron Nelson (<a href="http://sqlvariant.com" title="Better than &quot;sqldeviant&quot;" target="_blank">blog</a> | <a href="http://twitter.com/sqlvariant" title="Better than &quot;sqldeviant&quot;" target="_blank">twitter</a>), at left. Aaron likes to tease me because the first time or two we talked after our initial introduction, I kept getting his name wrong. That's uncharacteristic of me. But, hey, I was distracted because Aaron had brought his 12 year old daughter along and I kept wishing that I'd brought mine! </p><p>Aaron has really good content on SQL Server and PowerShell on his blog and in his presentations. Don't miss out!&nbsp;
</p><p><a href="http://kevinekline.com/wp-content/uploads/2011/02/Kevin-and-Stuart-2.jpg"><img src="http://kevinekline.com/wp-content/uploads/2011/02/Kevin-and-Stuart-2-300x224.jpg" class="size-medium wp-image-1526" title="Kevin and Stuart 2" alt="" height="224" width="300"></a></p><p>Another person in the Atlanta area I've enjoyed getting to know better is Stuart Ainsworth (<a href="http://codegumbo.com" title="A delicious gumbo of, um, code" target="_blank">blog </a>| <a href="http://twitter.com/stuarta" title="He's got a picture of a gator on his website" target="_blank">twitter</a>). Stuart has really stepped up to the plate these last couple years as a leader and a volunteer. I'm really impressed with his efforts, especially because they're in very important but rather invisible and thankless tasks. One example is his work in succession governance for <a href="http://www.sqlpass.org" title="The Professional Assocation for SQL Server" target="_blank">PASS</a>. Stuart, I salute you and thank you for your efforts.
I hope to see y'all there! And if I don't, y'all come up and visit us in Nashville some time.
</p><p>Cheers,
</p><p>-Kev
</p><p>&nbsp;
</p><div><span style="border-collapse:separate;font-family:Tahoma;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;font-size:medium;"><font face="Arial">&nbsp;<a href="http://twitter.com/kekline" target="_blank" title="C'mon. You know you want to!">Twitter at kekline</a></font></span></div><div><span style="border-collapse:separate;font-family:Tahoma;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;font-size:medium;"><font face="Arial">&nbsp;More content at<span>&nbsp;</span><a href="http://kevinekline.com/">http://KevinEKline.com</a>&nbsp;&nbsp;</font></span></div>
<p>&nbsp;</p><br>New on KEK.com - Presentation: SQL Server for Oracle DBAshttp://sqlblog.com/blogs/kevin_kline/archive/2010/08/02/new-on-kek-com-presentation-sql-server-for-oracle-dbas.aspxMon, 02 Aug 2010 12:23:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:27492KKline<p>Back in late May, my pal Buck Woody (<a href="http://blogs.msdn.com/b/buckwoody/" title="His name is Buck Woody, but his police rap sheet says 'Buck &quot;Stabhappy&quot; Woody'" target="_blank">blog </a>| <a href="http://twitter.com/buckwoody" title="If you like SQL Server, follow his tweets!" target="_blank">twitter</a>) and I presented <i>SQL Server for the Oracle DBA</i>.&nbsp; Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin.&nbsp; You can see the recording and slide deck <a href="http://www.quest.com/events/listdetails.aspx?contentid=11608&amp;technology=34&amp;prod=&amp;prodfamily=&amp;loc=">here</a>.&nbsp; Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had pretty good legs to stand on doing this presentation.&nbsp; Here's the abstract:</p>
<p style="padding-left:30px;"><i><span><span>In
enterprise IT, database professionals face a mixed-bag of platforms
within their environments -- and the overlapping duties that go along
with them. Whether you like it or not, you get asked to support Microsoft SQL Server operations even though you're an Oracle DBA.</span></span></i></p>
<p style="padding-left:30px;"><i>In this instructive webcast, experts from Microsoft and Quest with years of experience in both platforms will discuss the biggest issues and areas of interest for Oracle DBAs who need to work on Microsoft
SQL Server. You'll learn their tips and tricks for efficiency and gain
a deeper understanding of SQL Server to help you add more value than
ever to your organization. </i></p>
Of course, there are always questions and we aim to please.&nbsp; Here are
the transcripts of the Q&amp;A chat session (below) that accompanies
the presentation.&nbsp; The only editing I did was ... [<a href="http://kevinekline.com/?p=570" title="Recent Presentation on SQL Server for Oracle DBAs" target="_blank">READ MORE</a>]<div id="refHTML"></div>Two Free Training Webcasts Open for Registrationhttp://sqlblog.com/blogs/kevin_kline/archive/2010/05/24/two-free-training-webcasts-open-for-registration.aspxMon, 24 May 2010 20:59:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:25482KKline<p><a class="" name="11473"></a>We've got two sessions that you need to sign up
for right away.&nbsp; The upcoming webcast for Oracle-oriented folks has huge
registration numbers.&nbsp; So get in while you still can before we hit the
limit of what LiveMeeting can handle.</p><p><br></p>
<h2><a href="http://www.quest.com/events/listdetails.aspx?contentid=11473&amp;technology=&amp;prod=&amp;prodfamily=&amp;loc=" target="_blank" title="Those late to the session will be force to
count to 100 in octal in front of the entire class.">Pain
of the Week: SQL Server for the Oracle DBA</a><br></h2>
<p><b>Webcast:</b> <font color="#323232"><font color="#323232"><font color="#323232">SQL Server for the Oracle DBA</font><br></font></font><b><b>Date:</b></b>
<b><span>Thursday,
May 27, 2010</span></b> <span>(Just a couple days hence!)</span><br><b>Time:</b> 8
a.m. Pacific / 11 a.m. Eastern /&nbsp;4 p.m. United Kingdom / 5 p.m. Central
Europe<br><b>Duration:</b> 45-60 minutes<br><b>Cost:</b> <i>FREE</i><br><br>In
enterprise IT, database professionals face a mixed-bag of platforms
within their environments -- and the overlapping duties that go along
with them. Whether you like it or not, you get asked to support
Microsoft SQL Server operations even though you're an Oracle DBA. <br><br>In
this instructive webcast, experts from Microsoft and Quest with years
of experience in both platforms will discuss the biggest issues and
areas of interest for Oracle DBAs who need to work on Microsoft SQL
Server. You'll learn their tips and tricks for efficiency and gain a
deeper understanding of SQL Server to help you add more value than ever
to your organization. <br><br><b>Presenters:&nbsp;<br></b>Kevin Kline, SQL
Server MVP, Quest Software<br><a href="http://blogs.msdn.com/buckwoody/" target="_blank" title="He's strangely
magnetic to Road Island Red hens.">Buck Woody</a>,&nbsp;Senior
Technology Specialist, SQL Server, Microsoft<b> </b><br><br></p><p><font color="#323232"><br></font></p>
<h2><a href="http://www.quest.com/events/listdetails.aspx?contentid=11479&amp;technology=34&amp;prod=&amp;prodfamily=&amp;loc=" target="_blank" title="Sign up soon or else you won't get a seat!
... Just kiddin', it's virtual!">Pain
of the Week: Easy Ways to Fix Hard SQL Server Problems - Without a
Guru</a><br></h2>
<p><b>Webcast:</b> <font color="#323232"><font color="#323232"><font color="#323232">Easy Ways to Fix Hard SQL Server Problems – Without a
Guru<br></font></font></font><b><b>Date:</b></b> Thursday, June 17, 2010<br><b>Time:</b>
8 a.m. Pacific / 11 a.m. Eastern /&nbsp;4 p.m. United Kingdom / 5 p.m.
Central Europe<br><b>Duration:</b> 45-60 minutes<br><b>Cost:</b> <i>FREE</i></p><p><br>In
this instructive webcast, you’ll learn straightforward methods for
troubleshooting and resolving common poorly performing stored procedures
and queries in SQL Server 2008. The presenters will show you how to
easily:</p><ul><li>Read query execution plans and identify bottlenecks
in performance</li><li>Record system performance metrics for trend
analysis</li><li>Design databases and write Transact–SQL code to avoid
common problems</li><li>Understand what an index is, what it does, and
how to build one</li><li>Use industry-accepted best practices and
develop your own to arrive at optimal database performance</li></ul><p>Much
of the webcast is based on Grant’s book, "<a href="http://www.amazon.com/gp/product/1430219025?ie=UTF8&amp;tag=chaosinmoti00-20&amp;linkCode=as2&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1430219025&amp;gt;SQLServer2008QueryPerformanceTuningDistilled&amp;lt;/a&amp;gt;&amp;lt;imgsrc=http://www.asso" target="_blank" title="An
excellent book that I highly recommend.">SQL
Server 2008 Query Performance Tuning Distilled.</a>"</p><p>Don’t miss
this chance to get practical advice from working experts instead of
just theories from academics!</p><p><br><b>Presenters:&nbsp;<br></b>Kevin
Kline, SQL Server MVP, Quest Software<font color="#323232"> <br><span><a href="http://scarydba.wordpress.com/about/" target="_blank" title="He's been known to wear a kilt - of his own free
will even!">Grant Fritchey</a>, “Scary”
DBA from FM Global</span> <br></font></p>Join Me May 19th for 24 Hours of PASShttp://sqlblog.com/blogs/kevin_kline/archive/2010/04/26/join-me-may-19th-for-24-hours-of-pass.aspxMon, 26 Apr 2010 14:16:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:24579KKline<p><a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUsjFujLwMmO4PXzbygaF5fdku5SaYPWbUZFYdvFwOOVeDMn2MXVUPhUdDXvrGrKN5lWICmQo4aFkmwkh8PZytaUrVzvHHz7RySzSepLlGuiT6YwgI4KHag4I8HOpslFpBI=" target="_blank" title="Register Now!"><img src="http://kevinekline.com/wp-content/uploads/2010/04/24HOP.jpg" alt="" title="24HOP" class="aligncenter size-full wp-image-517" width="601" height="151"></a><br></p>
<p><b>Join Us for 24 Hours of SQL Server Training</b></p>
<p><i>(with a special focus on SQL Server 2008 R2)</i></p><p style="text-align:center;"><i>Did I mention that your Cohorts in Crime
(that be <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUuOZjF-KrHxujYlsOQMesC-mjFLtFzLOWgl_FT1teNLftVY1iE8GydpQ1TGM9SLvJmNqxuu6UxYOAt5v1VqsjIFkexYTKE2pHD4rFc6-WLwjibWnqbvYhawz06OkxRZq6UwkwpcGq2lyhRfYCNqMpq0hlTqEy8k1LSsnHc1v0kUtKSWyPtJoRER" target="_blank" title="Take That, Access Programmer, erm,
Evil-Doer!">me</a>
and <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvBoTeroUXVe1dwpHetEIajlBdTK-g57SuIoCeuKCsh-N8Er7lNvCsXBK01xw7I7dLzSuI7e9Y-8YPHXCJxS2arZoRPGc3wd9t_S5TbyWQAYP-qzOKpnSzqeToRSz4OY19b7-KG-Bx3X31e3QqWtYUXGZHsyKnQC7x8JqCbtA3WaSbmgl-xKuQD" target="_blank" title="My Fist Will Defragment the Face of
Criminals Everywhere!">Brent
Ozar</a>) are presenting?!?<br></i></p>
<p>The FREE <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUsjFujLwMmO4PXzbygaF5fdku5SaYPWbUZFYdvFwOOVeDMn2MXVUPhUdDXvrGrKN5lWICmQo4aFkmwkh8PZytaUrVzvHHz7RySzSepLlGuiT6YwgI4KHag4I8HOpslFpBI=" target="_blank">24 Hours of PASS</a> event is bringing an exceptional
lineup of SQL Server and BI experts to your computer&nbsp;starting at
12:00 GMT (UTC) on <b>May 19</b>.</p>
<p><a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUv9BzshqvEpgwFz2XgXW8b50msy2KWLG6SUXomR2ueFSBBlGRE8t0T3Gm8TFRUuAju_JJAJTk4sfASGuUxhKeZ_DnvhS8B1U3pNX_z7UuaJTzTpPFS_Jeffu-MFCaaZ-vodt5ipVGLca8kUGDZO0qkz" target="_blank">Get an in-depth look at the hottest SQL Server and
BI topics</a>, including (but not limited to!) - the new <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUucFSQNQD9KQ4Ntv3s9hlw6Q-cJKsl3izrdqF1yFPMNJOgl89Oz2Oxbw4e9-tx93DriP9fRXDPbHc4k3JOMfoOL0zRptrY-Az6_iobSekFy_wlyU7flegXgvCU_FWWd5weQJdIG1bUc_RAvtRW0dSuG" target="_blank">SQL Server 2008 R2</a>, with its business
intelligence and data management&nbsp;innovations, and much more.</p>
<p style="padding-left:30px;"><b>When does it start? 12:00 GMT (UTC):</b></p>
<p style="padding-left:30px;"><b>New York:</b> 08:00<br>
<b>Chicago:</b> 07:00<br>
<b>San Francisco:</b> 05:00<br>
<b>London:</b> 13:00<br>
<b>Paris:</b> 14:00<br>
<b>Moscow:</b> 16:00<br>
<b>Mumbai:</b> 17:30<br>
<b>Singapore:</b> 20:00<br>
<b>Sydney: </b>22:00</p>
<p><b> </b></p>
<p>The roster of phenomenal speakers features many MVPs and top-rated
presenters, including <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvRttnKUIPgEfTwaZKi_dXRCm0ovRW61__s3U7eGggyi29sZlGbafhj1SG2mGAaJrtYaKN3pppoQkwoUVglQ0NNt9PML74oermOhrP3pnkU_s-D5oI8H-2koge2DYhQpFYO0KOXAqCE6WbYb52FnS10YDWdXr2oD9L_vSdZKCgcAdTJmLrHpEiNFo6fTZwgzEU=" target="_blank">Adam Machanic</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUsRaxJ-QQCeYZucHSYDtsC3_l0d7zxFi0lAlAzS7a3AtrUnxJhfZu53TduvDTatyis5p_rmCC4zme5dDD7RsI1rA2TtnTg8o9M2x62WSbClCdcg7YB3Ky8BQCcLU7OvwLtDuSCJW2zj4M3fd08RypckBHINg1AnrCaTNzFvtursClTGPUB_O_OX" target="_blank">Andy Leonard</a>, <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUtk-d8XeuFcUzbuJ93heeDU3L7AodjJcYHIYRS5miiYyFKGkxiw6tD1ovm0CHNI7qs8_sinbPz5GCpKIlLIVwKRZNn5fYqjJ1K1MrUXs2cgmb0DHedjPK3Zd12MuppYDN0xRd6OGcpH9XY4kW_Ks5jjgrVRQ6baCs2liRiqcSgtgwSlNqG0QFKsIVsiRr6wckVPNPjmsRXEsg==" target="_blank">Brad McGehee</a>, <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvBoTeroUXVe1dwpHetEIajlBdTK-g57SuIoCeuKCsh-N8Er7lNvCsXBK01xw7I7dLzSuI7e9Y-8YPHXCJxS2arZoRPGc3wd9t_S5TbyWQAYP-qzOKpnSzqeToRSz4OY19b7-KG-Bx3X31e3QqWtYUXGZHsyKnQC7x8JqCbtA3WaSbmgl-xKuQD" target="_blank">Brent Ozar</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUv759uUGW0Z9kO0wSn-AhOGr6kyD__KRrZyZNtq9jUPojFIgXmC0jMKpKMapT2zpVzcynWQ-dXXyQdPT2NStMz85l3ACdj5QqJml11NrL09sEA4_1k-KdbaSh6zE63qaBFLRM3FYzq7TzlZXEzjp2XCir4W2JWRhwh-dnqHCKhkZWECX09gDD7X" target="_blank">Brian Knight</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvPZpqX_VoYtK9mvoNAFEcaaKwxUGUEXfsCaDkFkeF4ywTuXIFTNZ58dybX-GOah7QtZippU9LoSx2nLoQMtN6VJjYQZPFFJPsqY8Gw42bGkveXAK_5af5kOMih2T3qaAnfXxpJod12KXfYovXZfyRwZkYTX4UzoRHMjvvPEehZkBvuMtm2lljwYZrvW95S1Pw8_NNjngU_9w==" target="_blank">Chuck Heinzelman</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvTsIn8-QLqkXdl4TUlAkrSwlzwo951WIxpdvrUoHCWXnH_8b0yNohWDPSVfHnpU6Xg0GMjIBpYDNkba_uyUgcrQ6GgN9GIv6IVqPYNhTCKxyWTkrfcUzJ835uFb8qS5yfdXKrihHQkyPZM7suYxDeQAIVUbi8PVu38ZfMXYYNkjtRTF14d3y5KtSVu-B3XjiQ=" target="_blank">Dean Richards</a>, <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvrDILg7v9w8Ml-qJDVtbyZCOoLSmbQ3VIQ0yxSeOW6V6ymnNcxUM1njL3B2PPXhy2E3lPDDqykyxJdorGzhwp2NC5E1PSqbCBWFJWcJfInd-eytt4fOhGWEUvM2wTvbjUGH9ZXB-I0PNCaCCwNr_9f2E_x5gHLhCzdUedqaEQFMsMdKOqFhnK-cXVIZ6CHc94z2CWcagTyxg==" target="_blank">Don Kiely</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUt8cKaJG-xGr7eRaLE-aBuMofXRyMc_rs5HGZ-rInl4bCT0XuO0xsoBr55n9T8hqhUB_tMDzphgjhZ49uL_vis3-w04R3SJpGTgW1H16twj9nOIcA-97xFYXrGcjCEQo-mKYhJD5Cx_RPvog8ffrSmlG9j0tT4q4Md41-d9YPTEO8-afoaCvpHC" target="_blank">Don Vilen</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUsb0V0NrWcKVmZPC8ArhHlfJEil9C_Uqgi1sBCbCFDu_TZ5jXslmymf2YLEyKi-SjQSXa6AM5UoXSYZIXUELCmoUzTVk4QZDoJFKIwLX-4zzKkKHEZxbp0hzxqKyQxA6o2o2ryv8hsx1il_9XF_spp36xgALxqERtJajS3hYoFXvZmPy8IxmRiHwEMsHevSp40wARy018XNuw==" target="_blank">Donald Farmer</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUv9V-QhuKbDXajC6kkRkHF5ZPn-mQrAaoRvOpBkOLIQkk-N2EyUIp2-ix4kUvts7xQ-fH_cdzFCg9Q_69WPSYBR6AFl9mBOK7dlIN_iJwffAQzTMKJtdHoN-qbA0FD-qJq7gK-jchd7Fex1PD_FvvxtV_b8GJq52u99Mj_qd0qRtdMg034WzCZp7qcwa2rN75I8Vott98Y1_w==" target="_blank">Glenn Berry</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvYa5FkvZ5tRxOc1zGqx2wqOsTpP0QbXPZPFm9521D_qlnQR6D5ACuGozNXTXffrHIfxe7LoxY2ALQHElm-KugmxaWoPT0yi1VHBDshWOUHNH6zfNkJJn0UXw77LJUXzaIlscW21Y9rfpr0EgURQ_6s34c2pI3WAds9K_FNer6uHxvedkTuhYiyenrCCr6LFvjPRBZW53i_nA==" target="_blank">Greg Low</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUtsxBZq1jw_KH-qLD2DI52_Y3XyYzbSHSb6yM-rQWl-OfC4LOVHZlklIV77Wh99pJE9CVxGuWvWTstzEUpluDUVujDZ9ASuzhnpz4LzLoe3GXpaoLFd8lz3ovujAMpLpXjRguXfZg2vTPQhUPAjh4cxvrM1pPx8qPK9lSNc6v-BcQ==" target="_blank">Jacob Sebastian</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUt3xSciFZoYQXjH0eDBFccjTzucFLHn-0Lf7CYyUhzIZ4Uia63EprDWmgE_oQPb7YBfEggx6pabfUWDIRugLaWapJndFesNODqZl7oqtIKkx-INEkfhIZ1u3_eCXmtUJJxPPKRsfu8FOMnOqpDHagdCC3BtQxy6PpvgcLMKh-3yLpkBxIQVAOJM_dMd1ViuKl9qITtmaeDQuA==" target="_blank">Jessica Moss</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUsUzI5ItTP5FTNthnveT4hXmo1Uvr338NTJPBJh8E-9XopMNGPO5F5moLusnJltz_g7CPq9EYUP8u3ikHsq6xpZSQY0zCkgiBBgo06vZhShT0sHA8YaKNx12jOCe9m11yE3HTdV2KixPB6R88Py1Fu4bO-umonCYvtC7yHxCntDv8bpr4u9Z_22UQije_-Gj54=" target="_blank">Kevin Cox</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUuOZjF-KrHxujYlsOQMesC-mjFLtFzLOWgl_FT1teNLftVY1iE8GydpQ1TGM9SLvJmNqxuu6UxYOAt5v1VqsjIFkexYTKE2pHD4rFc6-WLwjibWnqbvYhawz06OkxRZq6UwkwpcGq2lyhRfYCNqMpq0hlTqEy8k1LSsnHc1v0kUtKSWyPtJoRER" target="_blank">Kevin Kline</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvzkUExcYeTUjo01daTWZysvyT0Xl2lZD01dcgBM-F_1-zVrXx0pJjT5lea8BKg0GXEeO_Hi8BXJUHhMMqNVWvCD9RewkREnogAYUBysea-saeu0Tzgyt2qNXKKRm1TLrlpu6PwEL5Cj1VgaWeAl2Y0jnAd9U51R4zbH-SpNbRKm8TTAV3b5YOA" target="_blank">Louis Davidson</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvbuhRENF0zC3pBuIU8Q3c0puWIlJI3RAfNuy9o0ZgswbEdzXbb9rOm6ye-AEkikcRyqOQNnCgmorga_YcqJE6YFUW1PiFjBYxUhJDfxdBixJF4LYe5gd6Xo9Fx4c4zEGk92d92kc1zJHcPOIQrdaIwluo5yFF25_6JqSEmiJeWDr9jCA--66D_el0eFxfLdxfoGL0NyDpLuw==" target="_blank">Maciej Pilecki</a>, <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUsEEk6IDxtt9nT6LonA4DZMTHGhX1DviG10I83vsVLhTBKQvlchQqJKa84nZ9lnccfPlcbApb_R6JdFHroZXF_ppwtqOm1y62h3OqjHOG93QiXb1XdM1P1he6QG1H0swrxCVuq3ZZWo2t83SSYiAeD-pEoVXSDP5JSwAv7kknZlgNpHEbnq8DA3aGJj5IEhzRF-w2u2TVpZAWzReeX48B7d" target="_blank">Peter Myers</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUs86mRTX-_nLk8gehGTsYzAVDOaSQKMH09ibFQKQ58TWVmmzIaB4_8G3roFb9C5iwGbvBqvGuf4vVrkq2WgFc517HHwWlLz-2Hey-B1vIZoLa_ijX2HwEHy_QZskeM87IOrFMTU0x3K_jzp_KLYsp1aBlqovKuRZ_n4RSOVJ7cP2WQk0dlGvb_obKmsuhP9RLg=" target="_blank">Peter Ward</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUsiHcxJKKv-htoBbEWbpPoiPAt8U3y38VLn2HJSoEsMZvHSdwcFmsxpVB2osQKfl1fF2nxojcHR7aIqYyTsewdIaO5_RaWc__btcWDJEWv9HCNuMhi0Ovwn4bO_ggahrW0JW7paP6CKDiefxB5BT3u1jEUuQYd865VMGpeBwUjrpcp77JCqt5KXZnYzFbTNMUrB6ZIiJeTnuw==" target="_blank">Rushabh Mehta</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUvaOlOWHhuddpbCUBj46nDISE8cADHje4X07zaJlwKF8Lyc1fLEDCoKDGS57P3gHu8A7OjnurtxvToyamHijnfKBCJeY4tEqcN-0zxjKOIUMVtHs1zA0fPjNM5NwPSeAOs2xrygq6i5oyI5akHmD9ko1pe2qaFU3Auoy3pjT1dhjG5ueAEOr3wHnoU3Nbnc4gzy5LvCbBpKSw==" target="_blank">Sean McCown</a>, <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUuBBIB0j-f-_qw_941E_ejf46YJYRRORUoxg96203opjnxuS-DJzcCWrU87L9gMsJSTn9mTbCGxXKdAkhAQPoOgQxgOi-urQyt_mVYZCPjOYSo7BnQt0KGY_kYPiSxxfF6r4IFNgs3KnwBUt8zhQyzMMF7wYu22iLFmvy2TECtPPqEyzOZWK_Yj" target="_blank">Simon Sabin</a>,&nbsp;<a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUtKRe3ZF5buPuLCr4qosGxeyUxrn2t8Tz4avfnvgMFrdmWfn6B8pldAThHkMNnUVW9k2H6KlX_jUfUsO7b8xJxmOVwkxefotak3nF-7XNopaS1_bq6L5VKLaq9PhkXEhFS6pyfQGNFbiSAacXzks3bKc_DpL3GKUqXOa0rPCAviwwsTNcn-3HP4tuD4C6-zR6poTORcsXVNcQ==" target="_blank">Thomas Grosher</a>.</p>
<p>Check out <a href="http://r20.rs6.net/tn.jsp?et=1103309079192&amp;s=12702&amp;e=001gzGzoQWNOUucFSQNQD9KQ4Ntv3s9hlw6Q-cJKsl3izrdqF1yFPMNJOgl89Oz2Oxbw4e9-tx93DriP9fRXDPbHc4k3JOMfoOL0zRptrY-Az6_iobSekFy_wlyU7flegXgvCU_FWWd5weQJdIG1bUc_RAvtRW0dSuG" target="_blank">all the great SQL Server sessions</a> you can
attend for FREE. Share this information with a friend or colleague.</p>
<p>PASS is looking forward to having you join us all for this
exceptional event. Please contact us at <a href="mailto:24hrs@sqlpass.org" target="_blank">24hrs@sqlpass.org</a> with any questions.&nbsp; You can also find lots of general details at <a href="http://www.sqlpass.org/24hours/2010/">http://www.sqlpass.org/24hours/2010/</a>.</p>Corrections on Trace Flag Entryhttp://sqlblog.com/blogs/kevin_kline/archive/2007/07/04/corrections-on-trace-flag-entry.aspxWed, 04 Jul 2007 07:15:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1739KKline<P>Kalen Delaney and I were chatting via email about a past blog entry I'd written about trace flags.&nbsp; <BR><BR><A title=http://www.sqlmag.com/Article/ArticleID/92774/Trace_Flag_Changes_in_SQL_Server_2005.html href="http://www.sqlmag.com/Article/ArticleID/92774/Trace_Flag_Changes_in_SQL_Server_2005.html">http://www.sqlmag.com/Article/ArticleID/92774/Trace_Flag_Changes_in_SQL_Server_2005.html</A> <o:p></o:p></P>
<P class=MsoNormal><o:p>The blog entry was based on some discussions I'd&nbsp;listened in on between a few other SQL Server MVPs.&nbsp; </o:p>In it, I said:<o:p>&nbsp;</o:p></P>
<P class=MsoNormal style="MARGIN-LEFT:0.5in;"><SPAN style="FONT-SIZE:8.5pt;FONT-FAMILY:'Arial','sans-serif';">Oh, and there is one more change for trace flags in SQL Server 2005.&nbsp; They can be specified as either local (new in SQL Server 2005) or global (as in&nbsp;SQL&nbsp;Server 2000) using an additional argument in <EM><B><SPAN style="FONT-FAMILY:'Arial','sans-serif';">dbcc traceon(...)</SPAN></B></EM>. If the second&nbsp;argument is not specified, the default value is local in SQL Server 2005,&nbsp;but&nbsp;is always global in SQL Server 2000.<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT:0.5in;"><SPAN style="FONT-SIZE:8.5pt;FONT-FAMILY:'Arial','sans-serif';"><o:p></o:p></SPAN></P>
<P class=MsoNormal>Kalen found a couple of problems with the paragraph which I'd like to share with you now.<o:p>&nbsp;</o:p></P>
<P class=MsoNormal>First of all, the parameter to make traceflags global was available in SQL Server 2000. Also, the default was NOT to make all traceflags global. It just frequently seemed like they were immediately set to global. But they weren’t guaranteed to be global unless you used the -1 second parameter.<o:p></o:p></P>
<P class=MsoNormal>If you turned on a traceflag for one session, without the global flag it would be available to all other sessions that had any traceflags of their own turned on, or if any traceflags had been set to explicitly be global.&nbsp; However, a session that had no flags set would not see any flags set as local in other connections. It was basically that each session either had traceflags enabled or it didn’t. &nbsp;Once a single traceflag was enabled for a session, then ALL flags enabled for ANY session would be available to that session. &nbsp;<o:p></o:p></P>
<P class=MsoNormal>Kalen actually&nbsp;wrote about it here, 5 years ago:<o:p></o:p></P>
<P class=MsoNormal><A title=http://www.sqlmag.com/Article/ArticleID/26406/Investigating_Trace_Flags.html href="http://www.sqlmag.com/Article/ArticleID/26406/Investigating_Trace_Flags.html">http://www.sqlmag.com/Article/ArticleID/26406/Investigating_Trace_Flags.html</A> <o:p></o:p></P>
<P class=MsoNormal>I agree with Kalen that&nbsp;it IS very confusing.&nbsp;&nbsp;<BR><o:p><BR>I hope this helps set the record straight.<BR><BR>Cheers,<BR><BR>-Kevin</o:p></P>