11/28/13
Problem
I seem that, you cannot display the table header in an every page of a SSRS report, even if you check the Repeat header columns on each page option in the Tablix properties (to open the table properties in Report Builder, right click on that sp… more » 12/11/13
Considering the following tables (table_1 with IDENTITY column):
IF (object_id('table_1') IS NOT Null)
drop table table_1
CREATE TABLE table_1
(
Id bigint IDENTITY(1,1) NOT NULL,
Col1 nvarchar(4000) NOT NULL
Col2 nvarchar(400… more » 02/01/13
Problem
When trying to select data from a view through a linked server the following error can appear:
SELECT * FROM [SERVER_NAME].DATABASE_NAME.DBO.VIEW_NAME
OLE DB provider "SQLNCLI" for linked server "SERVER_NAME" returned message "Binding inf… more » 04/11/12
Below it?s a simple schema to easy understand the difference between the Clustered and Non-Clustered Indexes:
Indexes can be created:
-Automatically
When you create a PRIMARY KEY constraint, a Unique Clustered Index on the column or columns… more » 12/19/13
Problem
When trying to restore a SSAS database cube from a backup file, the following error appears:
The following system error occurred: The file exists. (Microsoft SQL Server 2005 Analysis Services)
Solution
I encountered this error in two diff… more » Tags: ssas, the file exists
|
|