-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2015

Advice to New Bloggers

PREAMBLE

If you’ve been reading my blog for a while, you know that I travel and speak quite a lot. A frequent question I’m asked at these events is “I want to start blogging, but don’t know where to start. What do you recommend?” This is a such a common… Read more

5 comments, 895 reads

Posted in Kevin E. Kline on 31 March 2015

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 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… Read more

0 comments, 786 reads

Posted in Kevin E. Kline on 30 March 2015

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

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… Read more

0 comments, 503 reads

Posted in Kevin E. Kline on 23 March 2015

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

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… Read more

2 comments, 518 reads

Posted in Kevin E. Kline on 16 March 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 eyes

Aaron Bertrand (b | t) hit some obstacles recently when configuring an Availability… Read more

2 comments, 336 reads

Posted in Kevin E. Kline on 9 March 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/O

Erin Stellato (b | t) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of running DBCC CHECKCONSTRAINTS, including explaining why some check methods… Read more

2 comments, 432 reads

Posted in Kevin E. Kline on 2 March 2015