Monthly Archives: June 2016

What’s Your Area of Expertise?

Posted on June 16, 2016 by way0utwest

I ran across a great quote that made me laugh, but also struck me as being quite true. The quote is from Scott Curie’s post on the PASS Summit Speaker’s Contract and goes like this: “You would laugh at a … Continue reading →

Posted in Editorial | Tagged | Comments Off on What’s Your Area of Expertise?

When were statistics updated?–#SQLNewBlogger

Posted on June 16, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the STATS_DATE function recently, and it’s one that I hadn’t used in production code. I’m not … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Stretch Pricing

Posted on June 15, 2016 by way0utwest

I have to admit that I was really excited about the Stretch Database feature in SQL Server 2016. This will automatically archive older data away from your database, but let the query optimizer go get the data if needed. That’s … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

A Better (Free) Search in SSMS

Posted on June 15, 2016 by way0utwest

A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we released. Free as in beer, so go get it. Why use SQL Search? There are a number of good reasons, … Continue reading →

Posted in Blog | Tagged , , | Comments Off on A Better (Free) Search in SSMS