.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

how to implement real time olap

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :



We are trying to implement real time olap need help on how & where to start?


View Complete Post

More Related Resource Links

Timers: Implement a Continuously Updating, High-Resolution Time Provider for Windows


The timestamps that you can obtain from Windows NT are limited to a maximum resolution of 10 or 15 milliseconds, depending on the underlying hardware. At times, such as when you need to timetag frequent events, it is desirable to achieve a higher resolution. For example, what if you want to be able to contact a thread or perform some other task at intervals more frequent than 10 milliseconds? Suggested ways of achieving better resolution include using performance counters in conjunction with the sytem time to calculate smaller time increments. But using performance counters is a technique that presents its own problems. This article shows one possible way of overcoming limitations inherent in this approach.

Johan Nilsson

MSDN Magazine March 2004

SQL Server: Build Apps that Provide Real-Time Information and Customized Content Using SQL Server No


The adoption of wireless devices continues to spread unabated, and organizations are looking for new ways to get in touch with customers through these new mobile devices. In the past, unsuccessful ideas such as push technology were used to send targeted information to customers. Now, SQL Server Notification Services uses the SQL Server 2000 database engine and the .NET Framework to promote a new breed of notification applications that will allow relevant, consensual communications to be sent to any subscriber device.Here the author provides an architectural overview of the core features that make up SQL Server Notification Services. Along the way he discusses how they can be used for pushing Web content.

Mark Brown

MSDN Magazine November 2002

DirectX 8.0: Enhancing Real-Time Character Animation with Matrix Palette Skinning and Vertex Shaders


DirectX 8.0 allows the creation of smooth and realistic character movements that are more life-like than simple articulated structure animations. This is made possible by its improved support for vertex tweening and blended vertex deformations, also known as soft-skinning. After a brief history of the use of these techniques in DirectX, soft-skinning using the fixed function pipeline is discussed. This is followed by the use of matrix palettes from within vertex shaders to create a customized soft-skinning solution that takes advantage of the benefits of vertex shaders, such as hardware acceleration and custom lighting algorithms without the limitations of fixed-function solutions.

Benjamin Freidlin

MSDN Magazine June 2001

Windows CE 3.0: Enhanced Real-Time Features Provide Sophisticated Thread Handling


Windows CE is a small, configurable, feature-rich, real-time operating system. In Windows CE 3.0, the real-time support has been improved. This article looks at specific support for the creation of real-time systems and how it compares to the support in Windows for the desktop. The way interrupt handlers, processes, memory management, and synchronization work in Windows CE 3.0 is discussed. An extensive look at threads and thread priority, misconceptions surrounding them, and their impact on performance is included. Refinements to the Windows CE scheduler and support for nestable interrupts are also covered.

Paul Yao

MSDN Magazine November 2000

Real-time data replication

Are there any ways to replicate sql server production database to a standby database? I notice that there is a feature called 'continuous replication', does it do in real-time? what is the time-lag? Are there any potential data loss (i.e., production transaction committed but production db corrupted before the transaction is sent to standby)? Is the standby database available for read access during the replication?

how implement run time search

here I have 2 sample table and their data, CREATE TABLE TempData(Employee_ID INT, Timesheet_ID INT, Employee_Name VARCHAR(50)) INSERT INTO TempData VALUES(1, 20, 'YAZD') --SELECT * FROM TempData CREATE TABLE ColData(ColName VARCHAR(50)) INSERT INTO ColData VALUES('Employee_ID') INSERT INTO ColData VALUES('Timesheet_ID') --SELECT * FROM ColData below "SELECT" returns from below query, --SELECT * FROM TempData WHERE Employee_ID = 1 AND Timesheet_ID = 20 DECLARE @Employee_ID INT DECLARE @Timesheet_ID INT SELECT @Employee_ID = Employee_ID, @Timesheet_ID = Timesheet_ID FROM TempData DECLARE @STRSQL NVARCHAR(MAX) SET @STRSQL = N'SELECT * FROM TempData WHERE Employee_ID = ' + CAST (@Employee_ID AS VARCHAR) + ' AND Timesheet_ID = ' + CAST (@Timesheet_ID AS VARCHAR) + ' ' PRINT @STRSQL now I prepare dynamic search creteria from table "coldata" and now "SELECT" is below, --SELECT * FROM TempData WHERE [Employee_ID] = CAST (@Employee_ID AS VARCHAR) AND [Timesheet_ID] = CAST (@Timesheet_ID AS VARCHAR) DECLARE @ColName NVARCHAR(MAX) SET @ColName = STUFF( (SELECT ' AND [' + ColName + '] = CAST (@' + ColName + ' AS VARCHAR)' FROM ColData FOR XML PATH('')),1,4,'') DECLARE @Employee_ID INT DECLARE @Timesheet_ID INT SELECT @Employee_ID = Employee_ID, @Timesheet_ID = Timesheet_I

In real time how Sharepoint site is deployed from Development to Production?

in our company we are directly working on Production site so we never got scenario to deploy Site to Production Server , so i want to know the procedure to deploy SP site to production Server. in real time do they use any tool to deploy? kindly provide information on this.

How to implement Design-Time drag & drop from Custom Visual Studio Tool Window to WPF Designer

Hi, Could someone tell me if it is possible to intercept a design time drop event coming from a custom Visual Studio tool window onto the cider design surface? I am hoping to use the same API's as those used by the Visual Studio 2010 'Data Sources' tool window, which provides drag & drop data-binding between classes and WPF/Silverlight controls. My requirement is to pass a DataObject (used with the WPF DragDrop API) from my custom Visual Studio WPF tool window treeview to my custom WPF control at design time, read the data and do some binding/XAML manipulation of my own. The drag aspect is simple enough but I can't work out how to accept a drop event from anything other than the toolbox. At the moment, when I drag my treenode over the design surface it shows the 'cannot drop here' cursor. If someone could give me some insight into how the 'Data Sources' tool window allows dragging of treenodes to controls I would really appreciate it. It is obviously possible but which API's are used and are they public? Thanks in advance, Paul  

Real Time Stored Procedures and Triggers..

hi ..I am learning  Dot Net and i am looking for a job  in it these days... Every Company looked   if am mainly good in Writing Real Time Stored Procedures and Triggers... I am able to grab the basic concepts , but am not able  to write real time examples.... Kindly let me know some Websites or source  where i can find some real Times examples for  Stored Procedures and Triggers, coz  am interested in  practicing it ... Thanks in Advance...

real time reporting options

We have a client with real time reporting requirement. Up to 1 hour lag   time is allowed. Is log shipping an option? Please advise.

Real time face comparison


Hi, Recently i faced a reqirement, for comparison of face i have my webcam and i need to compare the current image with already stored image. this is very urgent please someone help me.

Display Real Time data in Graph


I want to display real time data in graph , the data is coming from database every 5 sec.

Please Can anyone help me?

Real time progress bar with dynamic task state


I'm trying to create custom control which displays real-time state (progress bar, or percent value) during time-consuming task (no animated GIF, or static text message).

This scenarion can't be done with standard UpdateProgress control, because it displays only static progress information.

This custom control can be then used as follows:

  1. Aspx page should contain this custom progress control and a button.
  2. When user clicks button, page executes postback to the server.
  3. Server in button click handler starts performing some time-consuming task.
  4. Client installs timer with interval is set to 2000 ms.
  5. In client timer event handler should be request to the server for progress refresh.
  6. If server receives request from progress control, it checks actual task progress state, and performs client control refresh.
  7. When server terminates executing the task, it hides progress control on the client.

How can be this scenarion accomplished? How can I create such custom control?

thanks in advance

procedure of doing project in real time environment



i am new to .net, i know fundamentals/basics only, i am using vs2008,sqlserver2005

i want to do a project with asp.net(using c#), SQlServer, Ajax, etc.

but i dont know how to start a project in real time scenario.

please guide me in detail. .

plz z z z z

thanks in advance 

sapi real time audio streams for telephone



I have a voip sdk that returns raw bytes and I wanted to send that to sapi Microsoft SDK to

Recognition the words someone said.  I am using the text to speech sample listbox as my base.

I think I need to pass it like this but have no clue.



SpCustomStream cusstream = new

Real Time graph with Ms Chart



I have requirement to build a real-time graph. Although if we use Ajax real time feature in MSChart it refresh the graph image after specified [provided by us] time period. This will tell users that the graph is refreshing every (say) 10 second.

Is it possible that user will never know the graph is refreshing with instantaneous data update? 



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