SQLServerCentral.com Content tagged Performance

Automating SQL Traces

Thu, 23 May 2013 06:00:00 UT

Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.

Object Qualification

Wed, 22 May 2013 06:00:00 UT

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...

Better Coding, More Savings

Mon, 13 May 2013 06:00:00 UT

The way we write code impacts our users, but it can also impact our wallet, especially in cloud computing. Steve Jones wonders how many people bother to profile and test their code.

Staggering SQLIO Sessions Across Multiple Volumes

Mon, 22 Apr 2013 06:00:00 UT

In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able...

Is BETWEEN faster than GTE and LTE?

Thu, 04 Apr 2013 06:00:00 UT

I know I have been light on blog posting this year. They always say that life tends to get in...