SSAS security roles are additive – that is, a user gets permission to access data allowed in any role to which the user belongs, even if another role membership for the same user does not allow access to the same data. This can cause confusion in some ...read more

Each and every day I use XEvent more and more as I uncover the powerful feature set.   I am finding it helpful to understand some of the input and output capabilities in order to leverage the power of XEvent. Server File Output When setting ...read more

SQL Server online documentation makes very clear that you need to 'drain' your replicated transactions before doing any upgrade if you have replicated databases. Below are requirements for transactional replication: Make sure that the Log ...read more

Sometimes we see the below error in SQL Server 2008 R2 SP1 when executing a query in SQL Server Management Studio: -------------------------------------------------------------- Error: 8624, Severity: 16, State: 116. Internal Query Processor Error: The ...read more

Recently we worked with a customer who reported a query that used to run a few seconds in SQL Server 2000 but it never finishes in SQL Server 2008 R2 following upgrade. We went around and tried quite a few things but couldn't get SQL Server 2008 ...read more