Topic profile page for Transactional.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Transactional.
Topic "Transactional" was discussed 0 times on 0 sites in last 3 months
Started 1 week, 2 days ago (2009-12-17 17:11:00)
by krish.j
Hi, We need to enlist several thousand calls to a service that results in millions of records to be inserted/updated in a single transaction. I would like to know how to design such a high volume transactional system. We are using NHibernate and sql 2008. Regards, Krish
Started 1 week, 2 days ago (2009-12-17 05:39:00)
by JoelH
If I'm not using a transactional database, and deferred write is set to false, at what points will bdb elect to synch the db? Is it done on a periodic basis, or when memory needs freeing up?
Started 2 weeks, 2 days ago (2009-12-10 16:51:00)
by Tha_Tyrant
I've heard from some sources that you can save time and effort by just building your cube from (staged versions of) transactional tables, rather than building an olap-style database and building the cube from it. Does anyone have any pointers on where this approach fails or is it really a way to speed up development?
Started 2 weeks, 2 days ago (2009-12-10 11:55:00)
by mdrewes
I am looking for a SQL script to remove all transactional data in a database. I am going to be copying a database and need to remove all GL and sub ledger transaction data, but leave all accounts, vendors, customers, etc. intact. I suppose I can go through Maintenance > Clear Data > Series… etc. however this seems like a lengthy ...
Started 2 weeks, 4 days ago (2009-12-08 05:00:00)
by Dr. Payal Sharma (R.M.P, C. Ht)
( NLP Hypnotherapy Center India, Presents Transactional Analysis for Personal Growth & Professional Success Faciliated By - Dr. Somesh Chadda Certified trainer of NLP, Hypnosis and Time Line Therapy, Certified Transactional Analyst and Applied Behavioral Scientist. Date - 24th & 25th Dec 2009 Timings - 9:00 am - 6:00 pm Venue - Hall D, USO House, New Delhi. For More Details - http://www....
Started 2 weeks, 5 days ago (2009-12-07 15:09:00)
by jmw207
( How do I download transactional information from a credit card account into quickbooks? , class="post_actions inline_edm"> Type of Abuse Abusive behavior ...
Started 1 week, 1 day ago (2009-12-18 02:15:00)
by jrJetLane
Is it a good practice to build a cube from operational tables or it is better to have at least denormalised tables ready for reporting and create cubes from this tables? BTW I am new on SSAS world. Thanks in advance!
Started 1 week, 1 day ago (2009-12-18 09:51:00)
by BFHelpdesk
> Hi, here is my problem: I got a store procedure that use Linked Server from a local SQL2000 server to a SQL2005 server. The store pocedure is getting data from the SQL2005 Linked server to update local SQL2000 tables. This store proc run in an average of 40seconds. If I put it TRANsactional (with a BEGIN / COMMIT-ROLLBACK TRAN), it takes an average of 1h30min to ...
Started 1 week, 1 day ago (2009-12-17 22:35:00)
by Rob
Hello: I'd like to validate a vendor supplied procedure that supposedly deletes rows in batches because a single transactional run causes the log file to fill up and thereby rolls the transaction back when there isn't any more disk space for the transaction log file to grow. So, my suggestion to the vendor was to rescript the procedure by deleting the tables in smaller transactions. An ...
Started 6 days, 6 hours ago (2009-12-20 13:50:00)
by Roy Goldhammer
hello there I have a transactional replication which transfare data from two different serves on different location. The last data on publisher were nvarchar of 36K. when i enter the data i got an error: Length of LOB data (68836) to be replicated exceeds configured maximum 65536. The statement has been terminated. is there a way to solve it? any help would be useful.
Started 6 days, 9 hours ago (2009-12-20 10:31:00)
by bg1987
I have a replication setup of several severs and with transactional pull subscription between them. server A pulls data from server B and C, and vice versa. (C from A and B, and B from A and C) I need to script all the tables each server is publishing, and whos subscribed to them. so for instance if server A publishes 2 tables Sales and Products, and server B and C pull from him I need to...
Started 1 week, 1 day ago (2009-12-18 10:18:00)
by Ramakrishnan.lh
Hi All, We have built our application on top of a transactional database. There are no primary key or foriegn key relationship at the database level. Everything is handled at the cube level. Now the records are increasing day by day and hence we are finding it difficult to run the queries. Now we have decided to create indexes . 1) Can i create a clustered index without a primary key in a ...
Started 2 days, 1 hour ago (2009-12-24 18:54:00)
by chapman85
Hello, My goal is to have two separate geographical locations for two web and database farms. Each farm will have two NLB servers and two SQL Servers (Active/Passive cluster). Both farms will be serving the same transactional website(s). So the database needs to be the same on both farms. What is the best way to replicate databases between the two SQL clusters on the fly? I need to ensure ...
Started 6 days, 13 hours ago (2009-12-20 06:26:00)
by Roy Goldhammer
hello there I have a transactional replication which transfare data from two different serves on different location. The last data on publisher were nvarchar of 36K. when i enter the data i got an error: Length of LOB data (68836) to be replicated exceeds configured maximum 65536. The statement has been terminated....
Started 4 days, 10 hours ago (2009-12-22 09:38:00)
by SM_NM
Name of Company: Agensi Pekerjaan Seri Mahligai Sdn.Bhd Role: 1. Provide timely, accurate and relevant information to customers, i.e. accurate product and pricing information, based on customer needs. 2. Proactively assist on client payment tracking system. 3. Administer transactional information and ensure system entries are completed in an accurate and timely manner Remuneration: ...
Started 1 week, 1 day ago (2009-12-17 21:12:00)
by burkeden
I have a Visual Studio Tools for Office (VSTO) application which uses Excel for the UI and Access for the database. I have approx 10 look up tables, in addition to the transactional tables. To date, the look up tables have been managed simply by opening the Access DB. Now however we are going to have a number of new users of the system who would strongly prefer to modify the lookup tables in ...
