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 » Transact-SQL Pr... » DBA   (RSS)
  • ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

    Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White ...
    Posted to Kevin Kline (Weblog) by KKline on March 30, 2015
  • ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo - SQL Server Performance

    Aaron Bertrand (b | t) is on a roll this month's SQL Server performance highlights with more great articles from SQLPerformance.com. Troubleshooting AlwaysOn – Sometimes it takes many sets of eyesAaron Bertrand (b | t) hit some obstacles recently when configuring an Availability Groups lab environment. This post ...
    Posted to Kevin Kline (Weblog) by KKline on March 9, 2015
  • ICYMI: the Halloween Problem and DBCC CheckConstraints - SQL Server Performance

    Don't miss these great articles on SQLPerformance.com from the industry’s top experts:A Look At DBCC CHECKCONSTRAINTS and I/OErin Stellato (b | t) of SQLskills takes a deep look into the I/O impact of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others.The ...
    Posted to Kevin Kline (Weblog) by KKline on March 2, 2015
  • ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

    One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What'dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody who writes SQL code on SQL Server should watch.If you know anything about the staff ...
    Posted to Kevin Kline (Weblog) by KKline on February 27, 2015
  • ICYMI: Sequences, CPUs, and Trimming T-Logs

    Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info comes from the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013: Generate a set or sequence without loopsAaron Bertrand (b|t) provides detailed performance information ...
    Posted to Kevin Kline (Weblog) by KKline on February 23, 2015
  • Amazingly Useful SQL Server Articles on SQLPerformance.com

    Me and Aaron Bertrand, SQL Sentry flagbearers.One of the things we've been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we're doing that on-line:Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP Aaron Bertrand ...
    Posted to Kevin Kline (Weblog) by KKline on March 3, 2014
  • Learn More About SQL Server IO and Query Tuning in These Webcasts

    I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...
    Posted to Kevin Kline (Weblog) by KKline on December 14, 2012
  • Everybody Needs a Test Harness

    When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
    Posted to Kevin Kline (Weblog) by KKline on October 31, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement