Join The SQL Crazy Train

One of the best lines I heard in the past few weeks was “That train has sailed.”  Combine that with a crazy schedule and we now have a SQL...

Join The SQL Crazy Train

One of the best lines I heard in the past few weeks was “That train has sailed.”  Combine that with...

Are Foreign Keys Better Than Indexes?

When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes,...

Q&A From “5 Ways to Improve Performance through Indexing”

A few weeks back spoke at a Pragmatic WorksTraining on the T’s on indexing that was titled 5 Ways to Improve Performance through...

PASS Summit agenda now published and I’m speaking!

For those of you who may have been living under a rock for the last few years every year PASS...

Improved Customer Support

In the last couple of months SQLTreeo has improved her customer contact skills. Before it was just an email to...

Connection Pool limit exceeds Error

Sometimes below error occurs on our web applications hosted on IIS connected with SQL Server.

Timeout expired.  The timeout period elapsed...

Colorado SQL Events : September 2013

 
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

SQL Server – Find all the LOB Data Type Columns in a Database Using T-SQL Script

Today morning when I was working on a huge database containing lots of LOB data, I was required to know...

TPC-E Benchmark Results for Intel Xeon E5-2697 v2

Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697...