https://weblogs.sqlteam.com/tarad/ Recent content on Tara Kizer Blog Hugo -- gohugo.io nospam@nospam.xyzasdf (Tara Kizer) nospam@nospam.xyzasdf (Tara Kizer) Copyright © 2018 - Tara Kizer Tue, 07 Oct 2014 11:48:28 -0500 https://weblogs.sqlteam.com/tarad/2014/10/07/refactoring-for-performance/ Tue, 07 Oct 2014 11:48:28 -0500 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2014/10/07/refactoring-for-performance/ For the past few days, I've been working on a stored procedure that was the top offender for CPU usage. I tried various index changes, played around with index hints, etc. https://weblogs.sqlteam.com/tarad/2011/11/11/pass-summit-2011-ndash-part-iv/ Fri, 11 Nov 2011 14:04:26 -0600 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/11/11/pass-summit-2011-ndash-part-iv/ This is the final blog for my PASS Summit 2011 series. Well okay, a mini-series, I guess. On the last day of the conference, I attended Keith Elmore’ and Boris Baryshnikov’s (both from Microsoft) “Introducing the Microsoft SQL Server Code Named “Denali” Performance Dashboard Reports, Jeremiah Peschka’s (blog|twitter) “Rewrite your T-SQL for Great Good! https://weblogs.sqlteam.com/tarad/2011/11/11/pass-summit-2011-ndash-part-iii/ Fri, 11 Nov 2011 12:22:14 -0600 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/11/11/pass-summit-2011-ndash-part-iii/ Well we’re about a month past PASS Summit 2011, and yet I haven’t finished blogging my notes! Between work and home life, I haven’t been able to come up for air in a bit. https://weblogs.sqlteam.com/tarad/2011/10/18/pass-summit-2011-ndash-part-ii/ Tue, 18 Oct 2011 20:54:38 -0500 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/10/18/pass-summit-2011-ndash-part-ii/ I arrived in Seattle last Monday afternoon to attend PASS Summit 2011. I had really wanted to attend Gail Shaw’s (blog|twitter) and Grant Fritchey’s (blog|twitter) pre-conference seminar “All About Execution Plans” on Monday, but that would have meant flying out on Sunday which I couldn’t do. https://weblogs.sqlteam.com/tarad/2011/10/18/pass-summit-2011-ndash-part-i/ Tue, 18 Oct 2011 10:34:53 -0500 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/10/18/pass-summit-2011-ndash-part-i/ What an amazing week I had at PASS Summit 2011 in Seattle, WA! I hadn’t attended a PASS conference since September of 2005 when it was in Grapevine, Texas. It has grown so much since then. https://weblogs.sqlteam.com/tarad/2011/08/24/renaming-the-sa-account/ Wed, 24 Aug 2011 14:16:41 -0500 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/08/24/renaming-the-sa-account/ Today I renamed the sa account on 23 SQL Server 2005/2008 instances. I used the CMS to assist with this task. Later we realized all of the SQL Agent jobs were failing on these instances with the following error: “The job failed. https://weblogs.sqlteam.com/tarad/2011/08/17/intermittent-copypaste-problem-in-rdp/ Wed, 17 Aug 2011 11:36:56 -0500 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/08/17/intermittent-copypaste-problem-in-rdp/ If you use RDP to remotely connect to your servers, you've probably encountered a clipboard issue where copy/paste stops working. A quick Google search on the problem indicates you can easily fix the problem by logging out/logging back in or killing/restarting rdpclip. https://weblogs.sqlteam.com/tarad/2011/06/17/fixing-ssms-tabs/ Fri, 17 Jun 2011 11:55:34 -0500 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/06/17/fixing-ssms-tabs/ It never occurred to me that the way SSMS handles tabs could be changed, and it’s just that the default settings suck. In this blog post, Brent Ozar shows us how to fix SSMS so that the tabs are actually usable and not annoying anymore. https://weblogs.sqlteam.com/tarad/2011/03/07/65536-autogrowth/ Mon, 07 Mar 2011 11:19:08 -0600 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/03/07/65536-autogrowth/ Twice a year, we move our production systems to our disaster recovery site. Last Saturday night was one of those days. There are about 50 SQL Server databases to be moved to the DR site, which is done via database mirroring. https://weblogs.sqlteam.com/tarad/2011/03/01/presentation-ideas/ Tue, 01 Mar 2011 09:57:07 -0600 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/03/01/presentation-ideas/ I've been thinking about submitting my "Performance Tuning With Traces" topic for SQL Saturday #73, but I think I’m burnt out on that topic. I’ve only presented it twice (#55|#47), and I am passionate about that subject, however I need something new. https://weblogs.sqlteam.com/tarad/2011/02/24/performance-tuning-with-traces-again/ Thu, 24 Feb 2011 10:50:32 -0600 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2011/02/24/performance-tuning-with-traces-again/ This past Saturday, I presented "Performance Tuning with Traces" at SQL Saturday #47 in Phoenix, Arizona. You can download my slide deck and supporting files here. This is the same presentation that I did in September at SQL Saturday #55 in San Diego, however I focused less on my custom server-side trace tool and more on the steps that I take to troubleshoot a production performance problem which often includes server-side tracing. https://weblogs.sqlteam.com/tarad/2010/12/15/missing-indexes-dmv-report-3-billion-impact/ Wed, 15 Dec 2010 11:12:51 -0600 nospam@nospam.xyzasdf (Tara Kizer) https://weblogs.sqlteam.com/tarad/2010/12/15/missing-indexes-dmv-report-3-billion-impact/ We’ve been having some major performance issues with one of the applications that I support. The database is on SQL Server 2005 and is about 150GB in size. We’ve identified a couple of issues already on the database side.