Tabular query modes: DirectQuery vs In-Memory

When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with...

The Side Effect of NOLOCK

Have you ever been told that you should use NOLOCK?  I have, and its usually been with OLTP systems where...

Washington DC in the Summertime

As I mentioned in my post last week I was fortunate enough to visit Washington DC a week or so...

Shrink transaction log file

Sometimes the shrink transaction log file doesn't work.

Before we troubleshoot it, we need to know how the log file works:
Transaction...

Simple batch script to generate XMLA and deploy SSAS DB

Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized...

Storage options available in Windows for SQL Server

There are several options available for configuring your storage media in Windows Server 2003 and Windows Server 2008. By understanding...

Connection Pooling :At a Glance

What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...

Find unused indexes using sys.dm_db_index_usage_stats

The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...

Interview questions

Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...

One week after #sqlsat132

It has been nearly one week since SQL Saturday 132 in Pensacola Florida.  I was chosen to give my talk...