ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior – SQL Server Performance

March 30, 2015 by Leave a Comment

Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most 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 (b | t). The Price of Not Purging Holding on to data long after its useful lifespan contributes to bloat and added preventative maintenance headaches. Read this informative post from Erin Stellato (b | t), of SQLSkills.com, where you’ll find a lot of useful … [Read more...]

Filed Under: Architecture, IO, Performance, SQL Server, SQLMag, Transact-SQL Programming Tagged With: , ,

ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance

March 23, 2015 by Leave a Comment

Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice! Optimization Phases and Missed Opportunities and Working Around Missed Optimizations Paul White (b | t) writes two fascinating blog posts that go hand-in-hand concerning query optimization.  He goes into some deep details about how the query optimizer works, comparing various versions of SQL Server, and shows you several useful ways to assess query performance. Plus, there’s one handy trace flag too! Observer Overhead and Wait Type Symptoms Joe Sack (b | t) does a deep dive on … [Read more...]

Filed Under: Presentations, SQL Server, SQLMag, Tips & Tricks, Transact-SQL Programming Tagged With: , ,

ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

March 16, 2015 by 2 Comments

Great Articles at SQLPerformance.com There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back: Troubleshooting SQL Server CPU Performance Issues This outstanding article from Joe Sack (b | t) of SQLSkills steps you through a methodical and insightful series of DMVs and queries that can pinpoint CPU issues on your SQL Server instances. Don’t just blindly create those “missing” indexes! Aaron Bertrand (b | … [Read more...]

Filed Under: Architecture, Coding, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Transact-SQL Programming Tagged With: , , ,

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

February 26, 2015 by 4 Comments

Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube. 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 here at SQL Sentry, then you’re probably expecting me and my colleague Microsoft MVP Aaron Bertrand (b | t) to be … [Read more...]

Filed Under: Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , ,

The SQL Sentry forum for SQL Statement Tuning

February 25, 2015 by Leave a Comment

The SQL Sentry forum for SQL Statement Tuning Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com? You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol' SQL Server Management Studio to the discussion forum.  Once uploaded, our internal team and forum members will provide plenty of tips and input on how to improve the plan and/or explain what the plan is actually doing.  The renown SQL execution plan expert, Paul White (b|t), is the moderator of the site. But … [Read more...]

Filed Under: On-Line Resources, Performance, SQL Server, SQLMag, Tips & Tricks, Transact-SQL Programming Tagged With: , ,

ICYMI: Sequences, CPUs, and Trimming T-Logs – SQL Server Performance Topics

February 23, 2015 by 2 Comments

Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info about SQL Server performance issues authored by 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 loops Aaron Bertrand (b|t) provides detailed performance information about a variety of methods used to generate sets and sequences in this first in a three part series. Selecting a Processor for SQL Server 2012 Glenn Berry (b|t) of SQLskills.com sheds light on the best CPU to select … [Read more...]

Filed Under: Hardware, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , , , ,

DBTA – 6 Reasons to Think About Upgrading to SQL Server 2014

January 26, 2015 by 1 Comment

  If you’re an IT manager, the first thing I’d like to tell you is how invested Microsoft is in SQL Server. While earlier incarnations of executive leadership focused in other areas (anyone remember “Developers! Developers! Developers!”?), Microsoft’s new leadership is very bullish on SQL Server. And, why not? After Microsoft Office and Windows Server, SQL Server is Microsoft’s third biggest money-making product line. Check out the recording of the “Accelerate your insights” webcast, about SQL Server 2014, featuring appearances by CEO Satya Nadella, COO Kevin Turner and CVP Quentin … [Read more...]

Filed Under: Administration, DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: , ,

SQL Injection – Why the Heck Does this Keep Happening?!

January 19, 2015 by 2 Comments

  I'm decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I'll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them off to school. Next, I make a bowl of oatmeal (a great choice for diabetics like me), pour a second cup of coffee, and browse the local paper, The Tennessean, while I have breakfast. On the morning of August 5, I had the added pleasure of spewing said coffee and oatmeal all over my morning paper when I read the … [Read more...]

Filed Under: Cloud, Coding, Databases, DBTA, IT Horror Stories, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: , , , ,

IT Pro Events & Free Stuff for the Central USA – Jan 2015

January 8, 2015 by 2 Comments

Central USA IT Pro Community News – Jan 2015 There are lots of free, in-person and virtual events happening in the central USA over the next few weeks. Don't miss out on training, ebooks, and other goodies! Upcoming Events Jan 10th – Kansas City – SharePoint Saturday Jan 14th – Online – A lap around Azure Websites Jan 15th – Detroit – BDPA Tech Meetup Jan 17th - Nashville - SQLSaturday #363 I'll be presenting two sessions at this event, along with many of the industry's leading experts. Come join us! Jan 19 – Detroit – Microsoft Web Camp Jan 19 – Chicago – Microsoft … [Read more...]

Filed Under: Conferences, On-Line Resources, PASS, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: , , , ,

DBTA – SQL Server 2014 Overview

November 17, 2014 by 1 Comment

  Perhaps this is your first time reading my column or you don’t know much about SQL Server. If either of those are true, then it might be a surprise to you that Microsoft has accelerated the release cadence for SQL Server to around one new release every 18 to 24 months. Add in the fact that Microsoft goes to market with their beta releases, better known as Community Technology Preview (CTPs), several months before the official release of the product. That means we could be in for a rush of new features and upgrades every year or so. Wow. Read the rest of my article … [Read more...]

Filed Under: DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: , ,
« Previous Page
Next Page »