Stores data in columns instead of storing in rows
Enables accessing data in easy and fast manner.
Improves processing time of Data Warehouse (DW) queries by hundreds to thousands times
To improve query performance, you need to build a column store index on the fact tables in a DW.
CREATE COLUMNSTORE INDEX [Index_Name] on [table_name] (Column_Name)
When I query the table via a Linked server, I get the following error.
Inconsistent Metadata
The workaround for this is to use OPENQUERY.
SELECT * FROM OPENQUERY(LinkedServerName, 'SELECT * FROM DBName.Schema.Table')
Analysis Services Project - A connection cannot be made. Ensure the server is running.
Right click on the project in solution explorer and click on properties and select deployment on the left hand side and change the server name to the Analysis server name. (default server name is localhost)
Have been working on a project where I needed to download some files from a website which uses forms authentication.
I created a console application using VS 2010 targeting .NET framework 4.0 and used the Cookie Aware version of WebClient class.
The authentication cookie is stored and the files were downloaded successfully.
Unfortunately the code doesn't work once I started targeting .NET framework 3.5
To make the authentication cookie to be stored, the authentication need to be performed twice to make it to work in .NET framework 3.5
Recently I have passed my Profession Scrum Developer Assessment and attained the PSD 1 certification
I attended the PSD Course but you get only 2 attempts to pass the assessment
I took the open assessments few times and also read the material provided with my course
Need to focus on the Professional Scrum Master Assessment but really need some break before the new certification