Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Reducing Tables Associations by Using Web Services23 Nov 2006 09:37 GMT1
Hi folks,
    First,let me use a busniness and solution model - car insurance to
present the issue
* There are 3 web services - policy, claim, pay.  Each services access
SQL Server - Informatica - Sudden ETL slow down21 Nov 2006 14:56 GMT2
We have been facing a problem for almost two months. All of a sudden,
we got a 300% performance degradation in our ETL for some tables.
Here's the setup on the production server:
- We have a server running Microsoft SQL 2000 SP4 with SAN disks, 4
RenDER Reports17 Nov 2006 22:22 GMT1
Can multiple parameterised reports be combined(or rendered) into one
PDF or MHTML format? How is it done?
Note: The reports generated have same structure but the values in the
fields as the input parameter changes.
Good websites for Custom Components17 Nov 2006 07:20 GMT8
I am pretty new to SSIS, so I really appreciate the help!
I have been building a few packages for the ETL in a mini data warehouse and
I have come across a few tasks that are very common. These include things
that, ensuring the business/natural key(s) are unique, or ensuring
Analysis services connection14 Nov 2006 10:14 GMT3
Hi!!
1. I am working with Analysis services 2005 and I would want to know
if, Is it recommendable to separate the DB server from of server AS?,
Since when I consult the cubes diminishes the performance the server of
error deploying analysis server cube14 Nov 2006 10:14 GMT1
Has anyone ever received this message before?
"The Description element at line 3123, column 29 (namespace
http://schemas.microsoft.com/analysisservices/2003/engine) cannot appear
under
How to improve the performance of server13 Nov 2006 15:42 GMT1
How I can improve particions on Analysis services?
Somebody can recommend me a link on this...?
Thanks,
Cecilia
dwh problem11 Nov 2006 09:47 GMT2
I have to choose between
a) using one single fact table
b) using one fact table and several dimension tables
I know that if you have no dimension tables (i.e. you store all the
Convert integer to date10 Nov 2006 16:15 GMT1
I have a couple of csv files with a date column like '20061231' or
'20050521'. What is the easiest way to convert this column into a date in the
SSIS pipeline?
The connection manager doesn't accept just defining the column as a date.
Connection to Analysis Services 2005 using .NET 2.009 Nov 2006 02:39 GMT1
I'm trying to use ASP.NET 2.0 to connect to a 2005 Analysis services database.
My script run on a IIS 6 web site under MS Server 2003 SP1.
For my test, the Analysis services database and the web site are on the same
server. My web site is configured as "Allowed anymous access" with ...
Capture delta or SQL DML02 Nov 2006 14:23 GMT7
Is it possible to capture delta for a specific table or capture DML statement
executed against a specific table?
thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.