-
05 maj 2013 i Håkan Winther, sv
If you work with PowerPivot in Excel, you probably are familiar with DAX. To make your work with DAX easier, you should download the DAX studio from...
-
26 april 2013 i SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Håkan Winther, sv, en
Well, at least the end of mainstream support for Microsoft SQL Server 2008 and 2008R2 is near. The mainstream support ends 7/8/2014 and you should
-
15 april 2013 i T-SQL, Level 400, Håkan Winther, sv, en
First of all, I am not a fan of triggers because of a number of reasons, but i will not go into those in this blog. Anyway, triggers can be useful
-
11 april 2013 i Trace flags, Level 300, SQL Server performance, Håkan Winther, sv, en
Sometimes you may stumble upon a slow running query in SQL server and when you look at the code you find an index hint. In normal cases the query runs...
-
26 mars 2013 i SQL Server 2008R2, SQL Server 2012, Level 400, SQL Server performance, Håkan Winther, Trace flags, Statistik, SQL Server 2008, sv, en
A common problem with statistics is when it's based on an index with an incrementing column, like an IDENTITY column or a DATETIME column that is
-
11 mars 2013 i SSAS, Level 200, Håkan Winther, Utbildning, sv, en
Recently I found a nice learning resource for Microsoft BI tools : http://msbiacademy.com Here you will find a lot of videos that will cover how to do...
-
08 mars 2013 i SSAS, SSIS, SSRS, SQL Server 2012, Level 200, Håkan Winther, Verktyg, sv, en
In the 5th of March 2013, Microsoft released Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012. Download it from : http...
-
27 februari 2013 i Level 200, Håkan Winther, sv, en
If you are using the Enterprise Edition of SQL server 2008 or later, you have the option to use Data compression and it can be used to improve
-
27 februari 2013 i Håkan Winther, SQL Server, connect, sv
Om du hittar en bugg eller kommer på en ide på hur SQL server kan bli ännu bättre så kan du logga in på http://connect.microsoft.com/ och registerara...
-
24 februari 2013 i Level 200, SQL Server konsolidering, SQL Server performance, Håkan Winther, sv
If you plan to run multiple instances of SQL server on the same server, you should plan on how you are going to share the memory between the instances...