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...]
ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance
March 23, 2015 by Leave a Comment
ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples
March 16, 2015 by Leave a Comment
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 we 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 … [Read more...]
IT Employers Must Adapt to the Looming DBA Shortage
March 12, 2015 by Leave a Comment
In the first column in this three-part series, available here, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. (Details here.) In that article, I covered the macroeconomic and general trends that pointed to a looming shortage of DBA talent. In part 2 of the series, I described some of the issues and opportunities these trends offer to current and up-and-coming DBAs. Today, let’s talk about what this trend means from perspective of IT employers. IT ORGANIZATIONS UNDER PRESSURE If you lead a team of … [Read more...]
ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo – SQL Server Performance
March 9, 2015 by Leave a Comment
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 eyes Aaron Bertrand (b | t) hit some obstacles recently when configuring an Availability Groups lab environment. This post shows how some assistance from the community helped him isolate and solve the issues. Another argument for stored procedures Learn the subtle ways that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really … [Read more...]
ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance
March 2, 2015 by Leave a Comment
Don't miss these great articles on SQLPerformance.com from the industry’s top experts: A Look At DBCC CHECKCONSTRAINTS and I/O Erin 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 Halloween Problem, Part 1 of a 4-Part Series Paul White (b| t) provides unique insight into a long-standing data modification issue, the infamous Halloween Problem. Much has been written over the years about understanding and optimizing SELECT queries, but … [Read more...]
Testosterone Undecanoate Soft Gelantin Capsules
March 2, 2015 by Leave a Comment
Information about Generic Andriol: Testosterone Undecanoate Soft Gelantin Capsules, helps in the development and functioning of male genitals and typical secondary sexual characteristics. We sale generic Andriol under brand name Cernos Caps works by providing synthetic testosterone to replace the testosterone that is normally produced in the body. Used in many cases as an alternative to testosterone replacement therapy (TRT), Andriol is especially appreciated by bodybuilders who do not want to use injections. Click HERE to read more … [Read more...]
ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)
February 27, 2015 by Leave a Comment
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...]
