Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

MDS and Best Practice Analyzer new features were introduced in sql...

Recently Used Tables and Databases

Recently developed these queries to assist with the evaluation of development or sandbox environments.  Sometimes disk space demands that old...

It’s OK To Eat Alone

There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Denali – Day 24: True Black Box Recorder – sp_server_diagnostics

Earlier sql server was having diagnoses tool.

Default trace.

SQLDiag

And other tools but could not...

Always restore with NORECOVERY

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.
It’s trivial to switch the database online.
Not...

SSRS Performance in SharePoint Integrated Mode

I’m working with a client to help them move all reports in their company from native mode (Reporting Services not...

Lifehacking – Not such a good idea?

I read the confessions of a recovering Lifehacker and thought it was an interesting read. It seems that the author...

Analyzing TPC-E Benchmark Performance by Physical Processor Core

The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in May, 2007. The TPC-E benchmark is...

Columnstore indexes and memory

Columnstore indexes are built and processed completely in memory.  You will receive an out-of-memory error if you do not have enough memory...

Watson Plays Jeopardy

I watched the documentary on Nova about the IBM project to build Watson, a computer that could play Jeopardy. The...