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

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

Denali – Day 23: Data Quality Services (DQS)

Denali – Day 23: Data Quality Services(DQS)

Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data...

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server?

One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is...

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

Marketing Ideas for Chapters & SQLSaturday

I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...

Plan cache in SQL Server 2008R2

I was curious to look at the effect of database options, on the SQL server plan cache.
I have restored the...

Watson Plays Jeopardy

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