How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...

SQL Server – Cannot resolve collation conflict

A friend of mine contacted me through email today having a very common problem with a query he had written....

The Done Stamp

I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...

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...

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...

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...

SQLServerCentral.com Track Offered at 2012 SQL Server Connections in Las Vegas this Fall

As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...

What happens when a SSAS Tabular model exceeds memory?

If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...

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...

Basic SSIS Equivalents to T-SQL's LIKE

There are some things that we do in one SQL Server tool, but can't seem to figure out how to...