MAXDOP and Cost Threshold for Parallelism – an example for a parallel query

The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...

Monday Morning Mistakes: Connecting to Wrong Environments

Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got...

Simply NomCom

So there seems to be some confusion as to what the NomCom’s job is.  I have to admit I was...

SQL Server : Moving System, resource and User Databases to New SAN disk

In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive...

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