Sequential vs. Simultaneous processing
The only responsibility of the application/service will be to pick up the XML
file (plus some error, log & message handling) and send it to stored procedures
for processing. So the sprocs are responsible for the heavy load. Also, let me
roughly describe the process on the SQL server side. ...
22 Nov 2005 by Goran Djuranovic - 5 messages - 3 authors |
Transaction processing reading?
Also, it can be suitable if you understand database and transaction processing
very well from the application/IT perspective, have a systems programming
background, and now want to understand how TP/DB really works inside at the
systems level. I'd suggest "Principles of Transaction Processing" by Bernstein/
Newcomer ...
1 Dec 2002 by Hal Berenson - 3 messages - 3 authors |
Processing w/Multiple Processors
On a daily basis, there is a good deal of processing via SPs that I need to do.
I know that if the server running SS2K has multiple processors the processing
will finish quicker than with a single processor server, however I was wondering
how processing is distributed among the processors. ...
22 Oct 2001 by Ben Amada - 3 messages - 3 authors |
Scheduled Processing of OLAP Cubes
writes I cannot find anyway to setup my OLAP cubes to process themselves on a
timer. Does anyone know how to schedule the processing of a cube either by means
of ... Thanks, Ross Culver Q. How can I automate OLAP Cube and Dimension
processing? A. For SQL Server 7.0 there is an OLAP Services Processing Task for
DTS ...
8 May 2001 by Darren Green - 5 messages - 2 authors |
SSAS 2005 cube processing in legacy DTS package
Dejan Sarka dejan_please_reply_to_newsgroups.sa...@avtenta.si microsoft public
sqlserver olap microsoft public sqlserver programming after migration from SS
2000 to SS 2005 I have some legacy DTS packages which required SSAS 2005 cube
processing. Old OLAP 2000 cube processing task does not work with SSAS 2005
cubes ...
14 Nov 2006 by Dejan Sarka - 3 messages - 2 authors |
Batch processing of Stored Procedure
Hi, I am trying to batch processing stored procedures with SQL 2000, MDAC 2.8.
All settings are default. SQLSetStmtAttr is called with SQL_ATTR_PARAMSET_SIZE
set to the number array elements. I am using ODBC CALL escape sequence. I
noticed from SQL Profiler trace that the stored procedure is executed as many
times ...
12 Mar 2004 by oj - 4 messages - 2 authors |
parallel processing hangs with CXPACKET wait type
Steph slir...@bigfoot.com microsoft public sqlserver server microsoft public
sqlserver datawarehouse microsoft public sqlserver programming I am doing
performance tuning on a data warehouse load process that executes a series of
stored procedures to migrate data from one database to another. The processing
is an ...
23 Mar 2004 by Steph - 3 messages - 2 authors |
Datastream processing out of sync.
In the middle of the transfer, I get the bad token from SQL Server, datastream
processing out of sync. I'm working with tech support on the problem currently.
I'll let you know what develops. For the time being, you may want to check your
table to see if it has any test or image datatypes. ...
4 Feb 1998 by Melissa Noble - 3 messages - 2 authors |
SQL Server 7 and parallel query processing.
james conley cja...@flash.net microsoft public sqlserver misc microsoft public
sqlserver programming microsoft public sqlserver server I saw a blurb in the
latest "IT/IS BackOffice Magazine" about SQL Server 7.0 and its parallel query
processing architechture. They alleuded to the idea of verticle partitioning of
a ...
5 May 1998 by james conley - 2 messages - 2 authors |
Asynch Batch Processing Architecture
Net windows service that needs to do processing based on a stack of data. eg I'
ve used a Task table in sql server in the past with a IsProcessed column. Then
the windows service polls that table looking for new records to process. The
problem is that this causes cpu cycles to be wasted while there are no tasks to
...
1 Dec 2004 by Andrew J. Kelly - 2 messages - 2 authors |
|
|
|
