Perhaps a bit of an esoteric problem but... I have a SQL Server 2008 instance on EC2 (running on 2008 R2) under heavy load. I'm trying to optimize I/O performance and after a couple iterations I'm ...

There is no set of rules for writing code that will take the best advantage of every query optimizer on every SQL product. The query optimizers depend on the underlying architecture and are simply too ...

I need to create a summary of the sum of the activity in each of three 'buckets' for a list of accounts in a table. (As a SQL statement) The table I am querying from is similar to the following sample ...

CHARLOTTE, N.C.--(BUSINESS WIRE)--SentryOne announced the general availability of SQL Sentry Premium, a new edition of its flagship database performance monitoring solution. With the introduction of ...

CHARLOTTE, N.C.--(BUSINESS WIRE)--SentryOne announced the general availability of SQL Sentry Premium, a new edition of its flagship database performance monitoring solution. With the introduction of ...

As any database admin knows, mastering the subtler nuances of SQL can be likened to the black arts. For me, tuning the efficiency of SQL queries on large, heavily used databases is a perfect example.

SQL Sentry, a provider of tools for monitoring, diagnosing, and optimizing SQL Server environments, has announced it is combining its tools into one platform and changing its name to SentryOne. With ...