THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Best Practices   (RSS)
Showing page 2 of 3 (22 total posts)
  • New on SQLMag.Com: Update to SP_WHOISACTIVE

    I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time.  Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
    Posted to Kevin Kline (Weblog) by KKline on April 21, 2011
  • Reminder: Totally Awesome and Totally Free Training SQL Server Training

    One of the things that I enjoy about working for Quest Software is that we give back copiously to the community.  From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world), Don't forget that free DVDs of our virtual conferences ...
    Posted to Kevin Kline (Weblog) by KKline on February 21, 2011
  • Database Maintenance Scripting Done Right

    I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2011
  • Have You Heard About Project Lucy?

    Lucy, You Got Some 'Splainin to Do!' Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia ...
    Posted to Kevin Kline (Weblog) by KKline on February 16, 2011
  • Disk I/O: Microsoft SQL Server on SAN Best Practices from SQL CAT's Mike Ruthruff (& Prem Mehra)

    While at the PASS Community Summit in November 2008, I had the pleasure of attending a handful of excellent presentations.  One of the best was delivered by Mike Ruthruff (& not just because he shilled for my presentation on disk partition alignment later that day—though I suspect he contributed to my session being SRO). Mike is a ...
    Posted to Jimmy May (Weblog) by aspiringgeek on March 1, 2009
  • MIRRORING THROTTLES BACKLOG

    For some reason, the title of this blog post makes me grin because it evokes a mental image of one guy trying to comically strangle another guy.  But I digress…   Speaking at a user group meeting recently, an attendee asked whether the mirroring process had any capability to speed up or slow down its workload according to the amount of ...
    Posted to Kevin Kline (Weblog) by KKline on May 2, 2008
  • The Most Important Performance Monitor Counters for SQL Server

    If you're well-versed in using PerfMon, I'd like to hear about the counters that you use regularly and what constitutes a good or bad value.  However, it's a rare individual who knows their way around PerfMon and its multitude of performance objects and counters.  Which ones should you track?  And even if you know the ...
    Posted to Kevin Kline (Weblog) by KKline on March 28, 2008
  • Let's deprecate UPDATE FROM!

    I guess that many people using UPDATE … FROM on a daily basis do so without being aware that they are violating all SQL standards.   All versions of the ANSI SQL standard that I checked agree that an UPDATE statement has three clauses – the UPDATE clause, naming the table to be updated; the SET clause, specifying the columns to change and ...
  • How NOT to pass a lot of parameters

    Did you know that SQL Server allows stored procedures to have up to 2100 parameters? And more important: do you care? Well, some people do care, and Joe Celko seems to be one of them.   If you are a regular reader of SQL Server newsgroups, you probably know Joe Celko from his always unfriendly and often incorrect replies. Here is a typical ...
  • Webcasts on-line

    As I've been traveling around speaking at various SQL Server user groups, I get requests for my slide decks.  Of course, I'm happy to share those, but I've got one better for you.  As it turns out, you can find five of my most recent webcasts here.  These are recorded webcasts that you can listen to any time.  I believe that ...
    Posted to Kevin Kline (Weblog) by KKline on February 8, 2007
Privacy Statement