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...
2012-05-24 (first published: 2012-05-21)
3,781 reads
Blog Posts
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...
2012-05-23
2,143 reads
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...
2012-05-23 (first published: 2012-05-22)
21,030 reads
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...
2012-05-23
1,459 reads
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...
2012-05-23
1,461 reads
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...
2012-05-23
41 reads
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...
2012-05-23
1,024 reads
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...
2012-05-23
726 reads
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...
2012-05-23
1,169 reads
Watson Plays Jeopardy
I watched the documentary on Nova about the IBM project to build Watson, a computer that could play Jeopardy. The...
2012-05-23
842 reads
Blogs
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers