.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

process Data VS Process Full

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
HI ALL, I have a cube now i want to process the whole cube in SSAS 2008, tell me is there is any difference in data if i processed the cube in Process Full mode or Process Data mode,if schema is still the same.   Regards Amit

View Complete Post

More Related Resource Links

Data Deployment: Streamline Your Database Setup Process with a Custom Installer


Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.

Alek Davis

MSDN Magazine September 2004

How to process data AFTER page is completely loaded for the user?


I have some logging that has to be done, which are some database update or inserts.

However this logging is of no importance to the user, so I only want to process the data/logs after the page is completed for the user.
As of now, if I process the data while the page is loading, I go from 1.4 to 2.0 speed (server side time processing of code), which is quite a bit comparing it is of no use to the user.

So I want this code only executed after that the page is complete.

I've been checking out Ajax, async pages etc, but the problem is it still gets executed before the page is rendered to the client, which means the client will have to wait longer then it is not being processed.

I've been checking out Threadpool.queueBackgroundWorker, however if I get it correct, this will still be executed before the page is shown to the user, as it has to complete before the prerender.

Then I thought about creating a new thread, and do the processing there, which would not have my page waiting to complete the data/logging.
However when I have 100 or 200 users loading pages at the same time, then that would mean I would be creating 200 threads on those loads, which I doubt will be good for performance. So if I want to solve this, I would have to create my own threadpool and only assign for example a max of 40 threads to it which can pr

IS There is any way out to process only one partition of cube and data of other partition remain ava

HI ALL. Please let me know is there is any way out to process one partition only,while data of other partition remain available in the cube with the help of SSIS

Process Data VS Incremental Process

HI All. what is the difference between Process Data VS Incremental Process.   Regards Amit

How to process two month data only from 10 month data and 8 month data still available to the cube.

HI ALL, I have created cube in SSAS 2008 and created 10 partition on one of the measure which contains 30 day data per partition i.e 10 month data which is filtered on the basis of getdate() -30 to getdate() ,only date part included. Now i want to refresh data only for the last two partition i.e getdate()-60 to gedate() and also to sustain rest of the data i. e.-from getdate()_61 onwards. I have tried full process mode but in that case i have lost one day data. Please suggest whether it can be possible with the process data mode.if not kindly suggest the way how to perform the same.     Regards Amit   Regards Amit

MOSS 2007 : Data store missing in the middle of process

Dear Expert, My user always report that some data that have been key-in by them (sharepoint web form) was missing during the WF is routing to (verifier & approval). FYI the verifier & approval only have a permission as a "View" anybody here have a same experience with me?? Isit the issue is because of sharepoint itself or human (i've try to create dummy record but work fine) ??

is possible to pass some data to a wpf started with Process.start?

is possible to pass some data to a wpf application started with     Process.start?

How to use Named Pipes for Inter Process Communication and transfer of lots of data?


I guess I have posted my question at the wrong place before:

So hopefully somebody in this forum can advise me on how to make my code work properly. Here's what I did:

I created a Windows service that opens a named pipe to receive data from an external application. Latter one connects and transfers up to 250 MB of data via a named pipe after it serialized a LIST of objects.

My windows service deserializes the data back into a LIST of objects, processes them and outputs the entire list into a file.

My issues are:

1.The data transfer is extremely slow! 200 MB take about 7 minutes via named pipe vs. 20 seconds if a file is used.
QUESTION: is it possible to speed up the data transfer somehow?

2.After my Windows service based processing is done I dispose the named pipe, clear the list and even call GC.Collect() but still my service is not releasing the memory.

3.Also I continue to have very high CPU load (98%) on all cores (2xQuad-core) although the service is not doing anything.
 It would be great if somebody could advise me on some of the p

SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider



I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

Process Full - Dimension


I had a problem  with my cube update in SSIS, i processed my dimension and cube in full in one SSIS SSAS object, the cube process failed because there was no relationship between a key in the fact and dim, the fulll process of the dim didn't seem to be picking up the new row in the dim.


the both process in one SSAS object in SSIS, any ideas as to what the problem can be, this is SQL 2005.



Deadlock: System.Data.SqlClient.SqlException: Transaction (Process ID 51) was deadlocked on lock res




I have a deadlock problem that occurs every 5 minutes on SQL update. I get the following error randomly - means qurey failed one time every 200 calls. I'm using transaction scope to manage transaction.




using(TransactionScope scope = new TransactionScope())




     UPDATE TABLE1 SET [F1] = @F1, [F2] = @F2, [F3] = @F3, [F4] = @F4, [F5] = @F5 WHERE UId = @UId








System.Data.SqlClient.SqlException: Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction


stack tr

How to move the SQL Server SQLFT log files created by the full text catalog process.


I need to move the location of the SQLFT text log files from it's current location %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG folder to another larger drive to accomodate the log file growth.  I cannot find anything on how to make this change.  Does anyone have an answer?  I have found this is a default at install - but during install did not find how to change this. 

Thank you.



Not able to fetch data for Application Domains related to .NET Framework 4.0 Process


We want to enumerate all .NET Framework 4.0 Processes on a particular machine. And then want to enumerate Application Domains for those processes.

After enumerating Application Domains, we want to fetch data about each Application Domain using following APIs.




We tried this using ICorPublishAppDomain Interface as well as following code :

ICLRMetaHost *meta; 

4 step process off of data sets - using Oracle 10g / 11g


I'm building what will either be a desktop or web app which has to run 4 SQL queries in sequence. I have worked out the first one which takes 3 parameters and am getting it to return results the way I expect. However, the next three build off of the one before. Can I pass the DataSet from one query to the next and how do I reference it properly in the subsequent queries so I can get them all to run correctly?


Curiosity here because I keep thinking I'm going to crack this soon.

How to serialize the data from hooked process for injector in C# and C++/CLI?



I am facing a strange problem while serializing the data from hooked process for injector (which injected the spy dll into some other process). I am successfully landing spy dll into other managed process. But when there I want to serialize custom objects from that spyDll (which actually landed inside other managed process which was hooked) , here problem occurs. Here I want to serialize the data and Lists or .NET dictionaries e.g say Dictionary>. Sometime it throughs exception such as "cannot serialize Dictionary>.....", some time it says that mark all classes and types inside hooked process as serializeable. I also tried Json to do that but I failed somehow to use it properly.

Can any body having experience to get the data from spy dll to injector Successfully, which then can be transmitted to the module which is using injector to get some data from remote processes via hooking and injection then after.Serialization works perfectly fine in simple console bases applications, but the way I want to get the data is totally different , as there's one MessageHookProc function , whic

ASP.NET Architecture - ASP.NET Worker Process - HTTP Pipleline - Http Modules and Handlers

"ASP.NET is a powerful platform for building Web applications, that provides a tremendous amount of flexibility and power for building just about any kind of Web application. Most people are familiar only with the high level frameworks like WebForms and WebServices which sit at the very top level of the ASP.NET hierarchy. In this article I'll describe the lower level aspects of ASP.NET and explain how requests move from Web Server to the ASP.NET runtime and then through the ASP.NET Http Pipeline to process requests.

For Multi-Language website which process is better in asp.net


 I want to build multi-language website in asp.net 2008 and asp.net 2010. So, which process is better for building application? Using either Local and Global Resource or New Folder to make separate according to language?


Application performance should be good and also easy manageable.


Please suggest me in which way I will build the application either using resource or folder. If there is any other better solution then please share.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend