Building High Performance Stored Procedures

[NOTE: Update 12 Nov 2014. The most recent bug (KB article KB2965069) is THANKFULLY very unlikely for most environments (mentioned below). As a result, I’m glad to say that we can use OPTION (RECOMPILE) as a much easier (and safer) solution. So, while I’ll still leave solution 3 as an option if you run into troubles with […]

(OLD): sp_helpindex rewrites

I realize that I’ve created quite a few posts (and rewrites) around sp_helpindex and recently I’ve been recommending that most folks use my latest version (jokingly, this is sp_helpindex9) but it’s not so obvious where to get it and/or what to do to install it. To make it easier… I’m just going to do a […]

(OLD): A new and improved sp_helpindex (jokingly sp_helpindex8)

NOTE: I’ve released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! OK, I first blogged about re-writing sp_helpindex here as sp_helpindex2 (April 2008). Shortly thereafter (Aug 2008), a reader found a bug and when I went digging, so did I (a couple of others). I did […]

Clearing the cache – are there other options?

OK, I've had a bit of a tangent going on optimizing stored procedures and its all revolved around adhoc plan caching and potentially wasted cache due to the single-use plans created (see the most recent posts titled:Plan cache and optimizing for adhoc workloads and Plan cache, adhoc workloads and clearing the single-use plan cache bloat). To […]

Plan cache, adhoc workloads and clearing the single-use plan cache bloat

In my post describing the new SQL Server 2008 configuration option [optimize for adhoc workloads] titled: Plan cache and optimizing for adhoc workloads, I asked for you to send me your plan cache numbers. In addition to the comments on the post, I received a lot of feedback in email (and lots of comments – […]

SQL Connections Fall 2010 – Call for Abstracts

Last week we completed another SQL Server Magazine/SQLConnections conference and already, it's time to start planning for the Fall show. Once again, Paul and I will be managing the SQL side of the conference and we'd like to invite you to submit abstracts for sessions at the conference. The Fall 2010 SQL Connections conference will […]

Column order doesn’t matter… generally, but – IT DEPENDS!

OK, for years I've been saying that SQL Server doesn't care about the order in which you define the columns of your table because internally SQL Server will re-arrange your columns to store all of the fixed width columns first and the variable columns last. In both the fixed-width portion of the row as well […]

Looking for security vulnerabilities in database code

I've always been concerned with security and I've always stressed the importance of auditing the REAL user context not just the current user (see this post on EXECUTE AS and auditing). So, I generally try to avoid using dynamic string execution and if necessary create well tested/protected parameters (fyi – using QUOTENAME can be a […]

The Tipping Point Query Answers

OK, I'll definitely take a beating from all of you for having gone so long between my survey posts and now. I won't even go into the details but between some crazy work schedules, multiple sinus problems and even migraines… well, I've been a bit behind. Let's just say that April/May were rough at best. […]

RunAsRadio Interview about Developers and DBAs – whose job is it?

A couple of weeks ago I wrote a blog post titled Whose job is it anyway? It's an interesting debate and something I've been hearing more and more – that SQL Server is a "set it and forget it" technology – a black box where you just don't need to know how it works to do […]

Spring cleaning your indexes – Part II

I started the series here: and I want to continue with Part II today by clarifying some great questions/comments that have come up on the series. In Part III, I'll give you a few more ways to get rid of (or consolidate) indexes. And, I think there's still a bit more that Paul and I […]

Spring cleaning your indexes – Part I

First and foremost, happy spring! I truly hope we’re on the path to summer (although who would know it here – we’re in Florida for SQL Connections and the weather is a bit chilly and it’s been raining off/on today – I hope this is short term (no, I don’t want to look at the […]

Database Maintenance Best Practices Part III – Transaction Log Maintenance

This is a tough topic. It's a big topic and more than any other – I think there are a lot of misunderstandings about what the log is for, why it's so critical and ESPECIALLY when/why it gets extrememly large. Simply put, it gets large when it's not managed correctly. OK, there are times when […]

Database Maintenance Best Practices Part I – clarifying ambiguous recommendations for Sharepoint

OK, it seems as though there's A LOT of confusion about what steps are required for proper database maintenance. And, it seems as though some recommendations are being given as "quick fixes" without any real recommendation for root cause analysis. I'm not saying that the generalizations are horribly wrong but in many cases they're just […]

Tipping Point Queries – More Questions To Really Test You!

OK, so this is interesting. I've got a few answers to my last survey (Tipping Point Query #1) and well, there's a good mix of answers (and, yes, some are correct! ;)). Be sure to go back and review that last post so that you can evaluate it and these two tipping point questions completely. […]

Why aren’t those nonclustered indexes being used?

Along the same lines of improving database design and getting better performance on SQL Server (which [IMO] DOES take an experienced SQL Server database developer – but, we'll talk more about "whose job this really is" in many more posts and probably even a RunAs – which Richard and I just setup to record on […]

Connections is 3 weeks away and counting!

It's an exciting year for us for DevConnections! SQL Server 2008 has now been out for a few months and an SP is coming up soon. This is the sign that some customers wait for to migrate over to the new release feeling that an SP indicates a higher level of stability. But, this is […]

Foreign Keys can reference UNIQUE indexes (without constraints)

Something I learned while the SQL Server 2008 Internals book was in tech edit (thanks to our *awesome* tech editor Ben Nevarez – who, unfortunately, does not have a blog or anything…yet! (well, I'm hopeful)), was that you can use a FOREIGN KEY constraint to reference a UNIQUE index – one without a PRIMARY KEY or […]

Getting the most from the system you have now!

Given the general state of the economy…many companies are looking to cut back. Going back over what we've done and "optimizing" things -> budgets, expenses, etc. is the norm right now. And, scaling back is not always a bad thing – unless the wrong things are cut. Unless the wrong things are used to motivate […]

Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008

Paul and I started discussing a comment that came up regarding the many issues surrounding logging & recovery. It's one of our favorite topics and in fact was the title to an article that Paul recently wrote for TechNet here: And, as a sidenote, depending on how much you already know about the transaction […]

Transaction Log VLFs – too many or too few?

(Be sure to join our community to get our monthly newsletter with exclusive content, advance notice of classes with discount codes, and other SQL Server goodies!) Way back in June 2005, I blogged about ‘8 Steps to better transaction log throughput‘. I did this blog post after seeing (again and again) overly fragmented transaction logs… Transaction […]

RunAs Radio Interview Posted – “Kim Tripp Indexes Everything”

Well… I think I had had too much tea that morning ;-). But, as always, chatting with Richard and Greg was great. Here’s the specific show link: Oh, and just for the record, I didn’t come up with that title. But, I do hope that all your [high-priority and important] queries are indexed! Enjoy!kt

(OLD): Updates (fixes) to sp_helpindex2

NOTE: I’ve released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! I first posted an update to sp_helpindex here. My version of sp_helpindex was solely to expand what sp_helpindex showed and adds 1 or 2 things based on version: for SQL2005+ it adds included columns and […]

Auto update statistics and auto create statistics – should you leave them on and/or turn them on??

YES!!! OK, well, I guess I should be more specific because as in most things in SQL Server, the real answer is “it depends”. And for these two options, it depends mostly on your SQL Server version. Since SQL Server 7.0, the way that auto update works, has changed (much so for the better!!). So, […]

Indexes in SQL Server 2005/2008 – Part 2 – Internals

OK, I first posted on some of the limitations to indexes in SQL Server 2005 and 2008 in part one here. Now, I want to dive into index internals for a post (or two). And, I often get the question “who is the best audience for your blog – or, for this post” and well, […]

Time for TechEd ITPro and, it’s hot as hell here in Orlando………

Memorial Day weekend we were in Chicago to celebrate my Father’s life. We did a “Celebration of Life” memorial and we had a few drinks (celebratory Meyers, Tonic and lime – which was my Father’s favorite drink), we (7 of us) gave a few heartfelt speeches, and a few friends wrote a song (and passed […]

Catching up on resources – the Accidental DBA workshops!

OK, we were in Iceland and then Florida for our Accidental DBA workshops and both went really well. People agree that there are quite a few involuntary/accidental DBAs out there and overall, we helped quite a few to see a lot of options for better performance, availability, recovery, and/or just manageability. So, this is our […]

Indexes in SQL Server 2005/2008 – Best Practices, Part 1

In my blog post on my new sp_helpindex proc (sp_helpindex2), I mentioned that the indexes in my sample were not necessarily a recommended set of indexes – just a test set of indexes. So… in this post, I thought I'd start a series on indexes, limitations and best practices/uses… Especially, why/how to best choose when […]

(OLD): sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex

  IMPORTANT NOTE: Always check the sp_helpindex rewrites category for the USE THIS post! OK – so this has been frustrating me for many months… when you create indexes with included columns (which was a new feature of SQL Server 2005), they’re not shown by sp_helpindex or by DBCC SHOW_STATISTICS. I understand this not showing for […]

SQL Server 2005 and 2008 – Compression

OK, I still have a way to go in learning about data compression in SQL Server 2008 but one thing that I do know is that nothing is free. So, the trade-off will be performance (i.e. CPU) v. space. And, that’s not really a new trade-off wrt to compression. Sometimes that trade-off has other benefits […]

Follow on post to “The perils of case-insensitive data (and our life in tangent-land)”

OK, so thought I’d do a follow up to the post I did a couple of days ago titled: The perils of case-insensitive data (and our life in tangent-land). The reason I’d like to followup on it is that I received some excellent comments and I want to make sure that you’re all aware of the […]

November in Spain -> TechEd ITForum 2007

      OK, so after SQL Connections in Las Vegas, Paul and I head off to Barcelona for the second week of TechEd’s two week event (week one for developers and week two for IT professionals). November’s definitely a busy month. So, if you’re in the US – we hope to see you at […]

November in Las Vegas -> SQL Server Magazine Connections Fall Show

    OK, it’s about that time again – the Fall conference season – is here! Building on our co-presented Database Maintenance workshop at SQL Connections in Orlando, Paul and I are doing a *ton* of stuff at SQL Connections this Fall. The conference is back at the Mandalay Bay hotel and officially runs from […]

SQL Server 2008 offers partition-level lock escalation excellent, but…

OK, let me start by saying that I absolutely love when a feature improves in granularity options. Better granularity in locks means that contention is reduced and concurrency improved. And even though the overhead to manage smaller locks (and typically more of them) is usually higher – the improved concurrency benefits often significantly outweight the […]

The perils of case-insensitive data (and our life in tangent-land)

OK, have you ever been working on one thing…that led you to another (and another and another) and then you seem to have lost hours? OK, I know. That’s our life [in the computer industry and I’m sure others!] – putting out fires and chasing strange behaviors that we eventually call “gremlins” when we really […]

“EXECUTE AS” and an important update your DDL Triggers (for auditing or prevention)

DDL Triggers were a new feature of SQL Server 2005 and while seemingly simple, they are very powerful. DDL Triggers allow you to trap an attempted DDL operation to audit it, prevent it, or do anything you want to validate/verify/”authorize”/etc – you write the code. And, since a trigger fires as part of the transaction, […]

SP2, VLDB Maintenance and TechEd

OK…SP2, the SP2 refresh and then the parallel/subsequent GDRs has seemingly (and rightly so) confused some of us… However, thanks to the PSS Engineers blog (and specifically Bob Ward – Senior Escalation Engineer, Microsoft PSS), this blog entry clears up a lot of that confusion. The end result is that you should be at 9.00.3054 […]

We got our mugs on SSWUG TV!

While at SQL Server Connections in Orlando, Stephen Wynkoop of SSWUG stole some morning time for an interview (morning time is not my best but we did get a lovely “I got my mug on SSWUG tv” mug so that made it OK :) :). We (Paul and I) had a great time chatting about […]

SQL Server 2005 Books Online Scoped Search

In the quest for more (and more and more ;) information, I’ve been told about a new link – from the SQL Server Books Online team… it’s call the “SQL Server 2005 Books Online Scoped Search” and it allows you a “live” search format for accessing content in the SQL Server books online. And – […]

Whitepapers, whitepapers and more whitepapers – where the heck are they???

OK, I’ve been complaining about finding resources – for a long time… AND, I’ve been complaining about how I can never tell if a whitepaper is on MSDN or on TechNet or on or on x, y, or z. Well…….. finally, I’ve done something about it. I’ve *started* to put together (and verify) a […]

Next Generation User Group podcast ready for download

Last week while Paul and I were in the UK delivering a one day seminar on Crucial Database Maintenance Techniques, we met David McMahon from the Next Generation User Group. They’re doing some exciting things in the UK and even for the wider community – for example – podcasts. Paul and I were interviewed for […]

I was ambushed…

Another great DotNetRocks interview has been completed. It’s Paul Randal‘s session on Disaster Recovery, DBCC, Index fragmentation (and defrag) and [unfortunately for me] a lot more. All I can say is that I was ambushed… thanks Richard   thanks Carl… Enjoy:

Moving databases around – what are your options and across what versions?

I had a discussion earlier today (with Paul Randal) about many misconceptions that exist about upgrading databases and more importantly, about “downgrading” databases. Really, the issue is that I’ve heard people get frustrated when they find that things like backup/restore works FROM SQL 7.0/2000 TO SQL Server 2005 but not the other way around – […]

Instant Initialization – What, Why and How?

Instant Initialization is a new feature of SQL Server 2005 that is based on an NTFS feature that was added to Windows XP (and therefore is also available in Windows 2003 Server). It's a feature that's seemingly simple; it allows file allocation requests to skip zero initialization on creation. As a result, file allocation requests […]

SP2 was released today… and, did you know about the Feature Pack?

OK – I feel like I know a fair amount about SQL Server but sometimes I also feel like I don’t :) :) I’m continuously amazed at how big a product SQL Server is… today was one of those days when I felt “I don’t”! I’ve been wanting to know more and more about the […]

Upcoming Events and Instant Initialization is not………….

Enterprise only. OK – I really need to blog more and well – I’m starting today by blogging a “quickie” blog entry on something that I just learned recently and that most of us (who speak/write/whatever on SQL Server) have been saying incorrectly…even marketing :). What’s been said is that the new SQL Server 2005 feature […]

The Clustered Index Debate Continues…

Well, I've promised to blog more and I'm really going to try to do so. This morning I got the perfect question/comment (in email) to respond to and after working through a response that was taking me upwards of 3 hours (you'll learn later why I have 3 "spare" hours :)……… I figured that it was […]

Time to make the doughnuts!

Ok – a strange title indeed but it’s been a strange couple of months. It all started with a “much needed” vacation and I thought that would get me through the persistent “cold” that I was having all through my travels. Anyway, vacation didn’t help and I came back to find that what I had […]

Way, way, way overdue

OK, it’s been a heck of a long time since I blogged… and for that I apologize. I’m also WAY overdue in my posting my demo scripts from a TON of conferences BUT… now everything has been posted. Check out the past events page on SQLskills and you can find the demo scripts that you’re […]

Is it really September? Here are some resources to check out!

Hey there everyone – Been a LONG time since I last blogged (sorry!)… key reason (fyi) is that I’m trying to find the ever-challenging work/life balance during the best months of the year (here in Seattle July/Aug are GREAT! months – September is almost always good too). Anyway, it’s been a few weeks and I […]

Designing for Performance – opinions, tips, tricks, techniques?!

Been thinking a lot about something that was mentioned in a few of my most recent posts… Especially when I get comments like “that’s another item to add to our checklist” or “that’s a good trick to add to our arsenal” and well, I thought in this blog entry I’d ask for your tricks that fall […]

Welcome to Blogging Liz!

Hey there everyone – If you’re into Analysis Services, Integration Services, Reporting Services and BI in general – you’ll want to check out Elizabeth Vitt’s new blog. Liz has been specializing in BI since SQL Server started adding BI-centric components. She’s got a wealth of information to share and many great insights into performance tuning […]

SQL 2000 v. 2005 – Using Top 100 Percent in a View

Well, it’s been a GREAT week here in Switzerland while working with my partner Trivadis. Today, we wrapped up a two-day course on Designing for Performance (in Geneva) while on Monday/Tuesday we did a two-day course on Indexing for Performance in Zurich. The food, the wine, the cheese, the butter, yum! Oh… and the questions/comments/technical […]

Geeking out at 36,000 feet

So, I’ve now spent the last couple of hours playing with Database Mail and HTML formatted messages being sent to the SQLskills subscribers. It’s been a fun learning experience as I think I’ve found a bug with the email account name length…let’s just put it this way – don’t be too descriptive with your account […]

Events, Events and more Events

I’ve posted all of my demo content from TechEd 2006 and wow – it was a lot of fun! I created many new and fun demos as I tried to keep everyone awake through the sessions (cause it seems like there were way too many evening events – didn’t it? ;-)). All of the content […]

Getting ready for TechEd – it’s amazing what goes on behind the scenes!

Well, if you’re wondering why I’ve been so quiet this week… it’s a myriad of events all coming together and/or being finalized right in time for TechEd. In working really hard (especially crazy was today) for some final TechEd content, I realized that a lot of people don’t really know what goes on behind the […]

DBAs definitely should NOT read this blog entry…

Ha… did that get your attention? Well, what I really hope to do is make everyone aware of what’s made the Developer Community rounds this week. On Wednesday, Microsoft announced “Data Dude” (aka the Visual Studio sku for Database Developers). This was an announcement that may be glanced over by many DBAs thinking it’s just […]

DotNetRocks got me again!

But – it was a lot more laid back this time… Once again, it was fun! Thanks Carl. Thanks Richard. Here the link for the show: and of course, the general link to DNR is Enjoy,kt

SQL Server Migration Assistants

In part 11 of the TechNet webcast series for the ITPro, I spoke briefly about the Oracle Migration Assistant and the recent release of the Community Tech Preview versions of both the Access and Sybase Migration Assistants… A few of you asked for their download location and there were even a few replies that folks […]

Changing Database Collation and dealing with TempDB Objects

OK, so… I don't know how many of you use different collations but if you do then you know that there are two truths: 1) They're very flexible 2) They can cause you a bit of grief (changing collations and tempdb) Flexibility As of SQL Server 2000 (or heck, maybe it was 7.0?), database collations […]

SQL Server Team Blogs – a new one and some existing ones!

The SQL Server team has a few *very* interesting blogs and the Engine Team just started blogging – check it out here: (thanks for the heads up Sunil). For completeness, here are the bulk of the other SQL team blogs – which I leveraged (aka stole – thanks Euan!) from Euan Garden’s EXCELLENT list (his […]

TechNet Webcast Series for the ITPro – Series Links

Hey there everyone – The series has completed and I know that many of you struggled to get access to the surveys… Microsoft has asked me to post links to the surveys…so, for completeness, I decided to create this blog entry to have links for every session, every blog link (resources, demo scripts, etc.) and […]

TechNet Webcast Series for the ITPro – Part 11 of 11

Well… 11 of 11 has completed. Friday was our last chat – until next time ;). It was a summary event where I took a slightly different spin on things focusing on grouping technologies by the amount of effort that’s needed to implement them. Simply put, we looked at the technologies in order of what […]

TechNet Webcast Series for the ITPro – Part 9 of 11

In part 9 of our webcast series titled: Implementing Database Mirroring, we covered the steps from setup to failover to monitoring. There were lots of great questions and I think we could easily go back and do a couple more hours on database mirroring, failover combinations – including manual failover and client application questions. Having said […]

TechNet Webcast Series for the ITPro – Part 10 of 11 – errata

In the last few minutes of the webcast (part 10), I goofed up one line of code and didn’t realize it until today. As my very last demo (and there were at least 10 different scenarios/concepts/demos yesterday) in my webcast, I decided to show a Database Snapshot on a Mirror database. It was the second […]

TechNet Webcast Series for the ITPro – Part 10 of 11

OK – today's session was quite fun… lots of demos and quite a few "tie-ins" where I tried to bring together many things that we've touched on in our series. And – that's really the point of the series – creating a reliable, robust, scalable and available environment takes MANY different features. You really need […]

Sun caused brain damage (not really) but…

I completely spaced in blogging about a recent interview I did…poolside, in Orlando, FL when I was at SQL Connections back in April. I had the pleasure of meeting Chuck Boyce (a DBA from Philly, PA) who feverishly works in his spare time to spread the word about technology and specifically about all things SQL. […]

TechNet Webcast Series for the ITPro – Part 8 of 11

Last week Mark Wistrom (Program Manager in the SQL Server Team at Microsoft), delivered part 8 of our TechNet webcast series. Most of the resources needed to prepare for this session – as well as learn more about Database Mirroring – have already been posted in the blog entry for part 7 (as homework!). However, […]

TechNet Webcast Series for the ITPro – Part 7 of 11

Well, Part 7 has completed and we're on the home stretch… focusing on part of the new Always On technologies of SQL Server 2005. We've made our way through quite a few discussions and my main point for the sequence – as defined – was to make clear that keeping a system available takes a […]

What, am I crazy??? 11 features/topics for this Friday’s TechNet webcast!

In doing my final preparations for part 7 of my TechNet webcast series on Building Robust, Reliable and Recoverable Systems, I decided to (once again) review my abstract. I do this as a last step to make sure I cover everything I said I would cover. Here’s the abstract: TechNet Webcast: SQL Server 2005 for […]

TechNet Webcast Series for the ITPro – Part 5 of 11

Well, Friday brought another flood of great questions from everyone as we moved our way through many of the new 2005 tools. The one thing that I really wanted to stress was that *many* SQL Server 2005 tools (SQLCMD, SSMS and SQL Profiler) offer important features that can be leveraged today, even if your primary […]

TechNet Webcast Series for the ITPro – Part 4 of 11

And another one bites the dust! Wow – what a great group today… soooooo many questions! For those of you that weren’t there – the lecture was 80 minutes and the additional Q&A went on for another 45 minutes. So – as a result, there were *a lot* of additional resources needed. Let me get started […]

TechNet Webcast Series for the ITPro – Part 3 of 11

OK – so Bob Beachemin delivered Part 2 and I was back for Part 3. We had lots of folks on board with this session (more than 400) and as a result, I had a lot of questions. More than anything it seems like a lot of you wanted to know which versions of which […]

TechNet Webcast Series for the ITPro – Part 1 of 11

Hey there everyone – Well there was lots of excitement around our first session…so much so that apparently a Live Meeting server went down and caused MANY of you to get booted-out or even blocked-from attending (figures, right!)…. Ugh (talk about the irony here – a series on high availability that isn’t available because a […]

Long time since I last blogged – wow…too much going on!

Hey there everyone – Sorry for the delay in blogging. Lots of great stuff to chat about but right now I’m in the throws of a lot of event planning! I hope that some of you will be able to attend one or more of these GREAT upcoming events: Webcasts A TechNet, 11-part Series starts […]

The impact of logging – terms and confusion!

First – for what is logging needed? This seems like an easy question – with possibly an easy answer… it’s to aid in transaction durability and help in recovery – when the system loses power. Simply put, the transaction log is a way for SQL Server to ensure that a transaction “survives” a power failure. […]

Scalable Share Databases are supported by SQL Server 2005 RTM

If you’re interested in scale-out improvements for reporting and read-only scenarios…check this out: KB 910378. This KB is actually a feature release KB and describes a new feature of SQL Server 2005 which allows multiple servers to simultaneously share the same database files on a SAN. This is NOT possible for read/write databases, only read-only […]

SQL Server 2005 Books Online Refresh

Many of you have probably already downloaded the refreshed Books Online but if not – you should! LOTS AND LOTS of updates/good stuff in there. Check it out: That should keep you busy for a bit! ;-) Happy New Year!kt

SQL Server 2005 Launches TOMORROW in San Francisco – Watch a LIVE Broadcast

If you’re reading *my* blog then you’re probably just as interested in the upcoming SQL Server 2005 launch as I am. There are many launch events scheduled around the world and I hope you’ll find time to attend one – even if remotely. IT’s ShowTime – from TechNet – will be broadcasting Steve Ballmer’s Launch […]

MSDN Webcast Series Wrap-up Resources

Hey there everyone! I know I still owe you a few Q&A entries (for sessions 7, 8 and 9) but I wanted to get this blog entry out there so that you can play a bit with some of the resources. This series was targeted at developers but really helps to "bridge the gap" between […]

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10

Effectively Designing a Scalable and Reliable Database A Primer to Proper SQL Server Development SQL Server Mixed Workloads, Secondary Databases, Locking and Isolation, Part 6 of 10 Presented by Kimberly L. Tripp, Q: Can I view a recording of this webcast?Part 6 can be replayed by clicking here. Q: Where can we get the demo scripts […]

PDC Pre-conference Workshop Resources…and what a list it is!

Brian A. Randell’s Blog: Website: Kimberly L. Tripp’s Blog: Website: Presentation ResourcesPresentation in PDF formKimberly’s Demo ScriptsBrian’s Demo Scripts and Code Running SQL Server 2000 tools and SQL Server 2005 tools side-by-sideWe talked about re-registering all of your COM components and I didn’t have a slide for this. So, if SQL […]

Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB

This is a much needed and much overdue blog entry… In 8 Steps to Better Transaction Log throughput, I mentioned a customer that was helped by TWO typical optimization problems I see. In that blog entry, I said I would write two blog entries – that one on transaction log optimization and another on common […]

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10

Effectively Designing a Scalable and Reliable Database A Primer to Proper SQL Server Development New Features in Indexing and Index Maintenance Best Practices, Part 5 of 10 Presented by Kimberly L. Tripp, Q: Can I view a recording of this webcast? Part 5 can be replayed by clicking here. Q: Where can we get the demo […]

Another Immersion Event ends…

Well…another custom Immersion Event ends…….. four days, 12 modules, nothing but SQL Server 2005: internals, availability and tuning. This week I delivered a four-day course titled: Building Highly Scalable, Available and Reliable Systems with SQL Server 2005. The course was delivered for the SQL Server customer team – to a few of their top TAP […]

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10

Effectively Designing a Scalable and Reliable Database A Primer to Proper SQL Server Development Indexing Best Practices, Part 4 of 10Presented by Kimberly L. Tripp, For a list of the non-technical Resources related to this webcast, please review the following blog entry:MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10  Technical Questions […]

MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10

Effectively Designing a Scalable and Reliable Database A Primer to Proper SQL Server Development Indexing Best Practices, Part 4 of 10 Presented by Kimberly L. Tripp, Q: Can I view a recording of this webcast? The webcast will be available for viewing within 24 hours. All “on-demand” webcasts can be found here. Q: Where […]

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10

MSDN Webcast: A Primer to Proper SQL Server Development Designing Tables that Scale, Best Practices in Data Types and Initial Table Structures, Part 3 of 10 Presented by Kimberly L. Tripp, Q: Can I view a recording of this webcast? Here’s the specific replay link. Q: Where can we get the demo scripts? The […]

Getting ready for Part 4, “Best Practices in Indexing” in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database

Two days isn't enough time! In fact, that's really true. There are so many interesting (well, I think they're interesting) aspects to Indexing that we could in fact do a whole 10-part Series on Indexing and it's likely that we'd still have other things to look at and talk about. So, in preparation for part […]

Congratulations to Bob, Niels and Dan!

This text is STRAIGHT from SQL Server Magazine’s September 2005 Issue: Reader’s Choice Awards  A First Look at SQL Server 2005 for Developers by Bob Beauchemin, Niels Berglund, and Dan Sullivan claimed best-book honors in a highly competitive Readers’ Choice category. The book shows working developers how to take full advantage of SQL Server 2005’s […]

The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment

OK, you’ve clicked through… Here’s the link: The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10

MSDN Webcast Q&A: A Primer to Proper SQL Server Development Creating a Reliable and Automated Backup Strategy, Part 2 of 10 Presented by Kimberly L. Tripp, Q: Can I view a recording of this webcast? Here’s the specific replay link. Q: Where can we get the demo scripts? The demo scripts are in this zip […]

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10

MSDN Webcast Q&A: A Primer to Proper SQL Server Development Creating a Recoverable Database, Part 1 of 10 Presented by Kimberly L. Tripp, Q: Can I view a recording of this webcast? Here’s the specific Replay Link: Q: Where can we get the demo scripts? The demo scripts are in this zip (20050805 […]

MSDN Webcast Series to start tomorrow!

Wow, I've been horribly bad at blogging these days and I owe you a few entries as well… But, good news, I have a new MSDN Webcast series that will help to answer a lot of best practices in database design strategies that can help you achieve better scalability, availability and reliability. All of my […]

SQLskills welcomes Bob Beauchemin

Today, SQLskills proudly annouces an exciting addition to our company… Bob Beauchemin – a database developer and SQL Server 2005 expert in the developer space – joins SQLskills as the Director of Developer Skills. Bob brings a tremendous amount of expertise with him in having worked with computers since 1977 and a variety of databases […]

Two contests…GREAT prizes… Good luck!

If you’re not aware, there are two SQL Server 2005 contests running: Connected Systems Developer Competition, Prize $50,000 USDClick on the graphic for the link to the competition site:   Best Migration from Oracle to SQL Server, Prize – Custom Chopper (approx. $50,000 USD)Click on the graphic for the link to the competition site: GOOD […]

GrokTalks have been posted!

Scott Stanfield, a Microsoft Regional Director, had a great idea for Tech*Ed US (well, it was a great idea before he knew exactly how much work was involved :)… He decided that he would get other Microsoft Regional Directors together to discuss (and record) interesting topics for just 10 minutes (of course, some of us […]

8 Steps to better Transaction Log throughput

(Be sure to join our community to get our monthly newsletter with exclusive content, advance notice of classes with discount codes, and other SQL Server goodies!) [Edit 2019 by Paul: Although this is an old post, it’s still relevant. I’ve updated the post to reflect current numbers and guidance. Also check out these more recent […]

An interview with has been posted!

Many of you in the .NET Community are already familar with theServerSide.NET but many of you in the SQL Server community are not…well, here’s your chance to bridge the gap over to .NET and hear a bunch of great .NET interviews! My interview is more SQL-centric but there are lots of great ones on Development […]

SQL Server 2005 Tools – Resources to effectively use SQLCMD

On Tuesday, June 21, I had the pleasure of assisting on a TechNet webcast delivered by Michiel Wories – a Program Manager from the SQL Server Development Team at Microsoft. My assistance was limited as I really just listened and helped answer some of the questions that came up during the session. In fact, there […]

Ever-increasing clustering key – the Clustered Index Debate……….again!

As I'm preparing for my Tech*Ed session on Indexing Best Practices in SQL Server 2005, I'm reminded that there are a ton of best practices that really apply to both SQL Server 2000 as well as SQL Server 2005. When it comes to indexing, there are many dependencies on the storage structures. These dependencies are […]

You learn something new everyday!

I think there are numerous reasons for why I love technology but at the top of the list: learning. It’s amazing to me that not a day goes by where I don’t dig deeper into something or clarify it further. Even learning something trivial, like a new keystroke, can make our work easier to do […]

Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005

NOTE: Generally, I recommend RIGHT-based partition function so that you don't have to deal with datetime timetick issues at all. However, this post can really help you if you still want to use LEFT-based partition functions. Enjoy!!!  When creating partitioned tables in SQL Server 2005, a partition function requires a LEFT or RIGHT designation. In general, […]

So many ways to get your hands on SQL Server 2005

For the past couple of years, the early betas of SQL Server 2005 were very limited and even the events were somewhat limited – limited primarily to large customers under NDA, MVPs, RDs, and very dedicated SQL Server specialists. So far, only the SQL Express 2005 Edition made it on for download (click here […]

SQLCLR: A DBA’s friend or foe?

When I first heard about “stored procedures being written in C#, VB.Net, … etc.” I remember thinking; Is Transact-SQL dead? Am I out of a job? What does this mean for me and for DBAs in general? Luckily, I learned quickly that not only is Transact-SQL not dead but it’s got some significant improvements that […]

Exciting Events Ahead…

OK, so I’ve been bad (at best) at blogging this year… but I’ll blame some of that on the fact that I’ve done more travel in these first three months of the year then I’ve ever done. Yes, I’ve been to Charlotte, NC (for a SQL Server 2005 Ascend Workshop) then Dallas, TX (for yet […]

SQL Server 2005 Developer Webcast Series Coming Soon to MSDN

Starting the week of December 6th, Microsoft will launch a series of webcasts focused on SQL Server 2005 Development. During the week of December 6th, Microsoft/MSDN will host 15 webcasts introducing all the new features of SQL Server 2005 for Developers. Then, starting in January, there will be at least one webcast per week focused […]

SQL Server 2005 Partitioned Tables and Indexes

While getting ready for the PASS Community Summit in Orlando this week (where I plan to talk about SQL Server 2005 Partitioned Tables/Indexes), I realized we were close but not quite ready to release the post-beta II whitepaper on MSDN. So, in preparation for PASS we decided to post a pre-release of the partitioning paper […]

SQL Server 2005 – Profiler with Performance Monitor Integration and a bit more with Management Studio

I began setting up for Profiler and Performance Monitor by first launching Profiler and then launching Performance Monitor within it (there’s an icon for PerfMon second from the Right or you can select Performance Monitor from the Tools Menu). I had already created a Performance Monitor Counter Log so all I needed to do was […]

SQL Server 2005 – Management Studio Scripting Option and SQLCMD (loving it!)

One of my favorite features of Management Studio is the ability to “script” a step rather than execute it. Within SQL Management Studio, each dialog has 4 different options from which to choose (these are including the typical OK/Cancel) but also add a couple more at the top of the dialog:   At the top […]