Loading Huge XML To SQL Server 2005

Jan 13, 2008

Hi,

 I am using VS2003 and SQL Server 2005. I will get the huge size xml from the web service. I need to load this xml to sql server 2005 table as records.

I got below solution from microsoft site. Load XML to Dataset and from Dataset to SQL Server 2005.

Note   If you call ReadXml to load a very large file, you may encounter slow performance. To ensure best performance for ReadXml, on a large file, call the DataTable.BeginLoadData method for each table in the DataSet, then call ReadXml. Finally, call DataTable.EndLoadData for each table in the DataSet.

Any other better solution is there to load huge XML to SQL server 2005?

View 1 Replies


ADVERTISEMENT

Loading Huge Volume Data

May 31, 2007

Hi Good morning to all,



My day started with loading huge volume of data and my data flow task failed to do so.



My data flow has a flat file connected to a OLEDB target. This is a one to one mapping. My source file contains 50 lac records and it is of 500 MB in size.



I'm processing the data with all the default buffer settings. I have 4 CPUs in my server.



the system process DTSDebug.exe is utilizing more than 2GB page size. My average CPU usage being 70% when one of those CPU s is hitting 100% utilization.



I'm very new to SSIS. So, please provide me some info how do i set my buffers and do we have any PDF for performance and tuning in SSIS ?



Do we have any bulk load transformation in SSIS to load into DB2UDB ?



If so how do i get it installed?





Thanks in advance,

Suresh N

View 2 Replies View Related

Huge Volume Of Data Loading Issue

Aug 21, 2007

Hi all,

I've faced a problem with the below error when I load 1.5m data into oracle database.


The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers.

Please help. Thanks

View 19 Replies View Related

Transaction Log Huge Loading SQL Profiler Trace Files In Simple Mode

Dec 8, 2007



Hi there - can anyone advise on the following issue. We have recently performed some server side tracing on a particular SQL instance over 24hr period. We are now attempting to load these into a database for analysis. Here lies the problem.

When we are loading the profiler trace files (one at a time) into the database the transaction log is growing at an excessive rate. Even though the database is in SIMPLE mode.

We are loading the traces using the command:

INSERT INTO sqlTableToLoad
SELECT * FROM ::fn_trace_gettable('MytraceFileName', DEFAULT)

Can anyone advise how we could possibly get round this issue as we're running out of space due to the transaction log.

Thanks

View 5 Replies View Related

Loading Data From Xml To Sql Server 2005

Aug 13, 2007

Please find the code below (which I am using).
1)
CREATE TABLE rssFeeds( feedXML XML)
SELECT * FROM RSSFEEDS
DECLARE @xmlDoc XML
SET @xmlDoc = ( SELECT * FROM OPENROWSET ( BULK 'C:Test.xml', SINGLE_CLOB ) AS xmlData)

2)
INSERT INTO rssFeeds (feedXML) VALUES (@xmlDoc)

I am able to get the contents of xml file into sql server in only one field of Table. Now I am asked to make one table with the schema same as xml file's. How to proceed? Pls let me know some URL for this.

Regards,
Ashish Johri

View 1 Replies View Related

Loading SAS Dataset Into Sql Server 2005

Apr 5, 2008



Hi,


This is an urgent task came up at our i.e. Loading SAS dataset files into Sql Server 2005.

We received the various files generated from SAS from other team. Now we have only .dat files and some .sas files.
Requirment is to load them into SQL server and generate some reports out of the database.
Does any one has done this task previously i.e. SAS dataset into SQL server?

There is any documentation or steps to be followed using SSIS, please adive.

Any help is great appericated.

Thank you
NMohan

View 9 Replies View Related

Loading Data From .mdb File Into Sql Server 2005

Aug 15, 2007

I am so new to SQL Server 2005 and just studying.  Saying that...
We use SQL Server 2005 Express edition.  Some one sent me a file (info.mdb) and asked me to load the data in this file in to a table called Products and also asked me to load in another table (ProdCat) where id = 'X05'.
So being not knowing anyting regarding data loading etc, how should I do this and proceed?  The .mdb means its a Access database file?  If that is the case, I dont have Access in my machine and what should I do?

View 5 Replies View Related

Backup Of SQL Server 2000 Loading To 2005

Jul 24, 2006

I want to restore a backup of a SQL Server 2000 database to SQL Server 2005. Would I need to do anything after running the restore to upgrade the database?

View 1 Replies View Related

SSIS Help Loading From Sql Server 2005 To Informix 7.3.1 SE

May 16, 2008

HI

I am transferring the data from sql server 2005 to Informix 7.3.1 SE using SSIS .

I am using the OLEDB data connection for both source as well as destination databases.

I am trying to mapping the source and destination tables .I am getting the following error.


TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [184]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Destination [184]]: Opening a rowset for ""srinivas"."company"" failed. Check that the object exists in the database.

------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------


I am using the following ODBC driver for the connecting INFORMIX 7.3.1 which is running on LINUX environment.
Openlink Generic ODBC Driver

It's creates the table in the informix 7.3.1 but it's not mapping the source and destination databases columns.

Please help me any one. it's urgent .


Thanks,
Srinivas Unnam

View 3 Replies View Related

Loading Images Into SQL Server Express 2005 Tables

Jul 19, 2006

Im new to SQL server express 2005 and im having issues loading images into my tables. can anyone show me how to achieve this?

Thanks

Matt

View 4 Replies View Related

Loading Data In SQL Mobile 2005 From The Server Side And Not On The Handheld

Mar 31, 2006

Hello,

We are in need of some help around the use of SQL Server 2005 Mobile Edition.

The problem comes in when we have to import a large list of equipment ID€™s into the database.

The way that things work today is that the database only runs on the handheld computer, so we are having to process a large amount of data on the handheld therefore taking a lot of time.

If there were a way to have a €œseed€? database on the server side (running on Windows Server 2003 or similar) and import all of this data on the server side it would be more efficient and require less time.

Once the data was imported on the server side we can simply transfer this seed database down to the handheld

Could you please throw some light on the above queries.

Thanks in advance.

Jeeves



View 1 Replies View Related

Loading SQL Server 2005 Standard On Windows Web Edition 2003

Jan 16, 2008

Has anyone done this? If so, how? I saw the systems requirement pages and web edition is not listed as as supported OS, but it's what we have. TIA.

View 1 Replies View Related

Huge SQL Queries In SQL 2005

Mar 20, 2008

Good evening:
 We're porting an old app written in ASP.NET  1.1433 and SQL 2000 to ASP.NET 2.0 and SQL 2005.  In the old app we have a few data grids that are populated from a dataset pulled from the database.  We use a SQL query that we build based on more than 10 different user inputs, the result of which is an enormously complicated SQL string.  We'd like to move this processing into a SPROC in the 2005 database.
Rather than writing stored procedures to create the SQL SELECT statement, is it possible to pass an entire select state ment to a SPROC and have it executed within?  We're trying to capitalize on paging in 2005 using ...ROW_NUMBER() OVER (ORDER BY PM ASC)... and building the string using IF ELSE statements is mind numbling complex and tedious.
And suggestions woudl be great.
Thanks,
Brad

View 4 Replies View Related

Huge Deletes In A Huge Table

Apr 3, 2000

SQL 7 SP1 NT4 SP5

I have a TRANSACTION table with 150 million rows.

I have a USER table.

Each user has about 600 records in the TRANSACTION table.

The TRANSACTION cluster index is on USERID + RECID . The second index is on USERID + Fieldx + Fieldy.

The TRANSACTION table gets about 1.4 million inserts in a normal day and about 40,000 updates.

I want to go through the USER table and delete all users who have not visited me in a while.

I want to do this without substantially hindering performance in a production environment. I can perform this over a week period or two if needed.

The best way I thought of doing this was to grab x amount of users in a cursor and loop through deleting their corresponding TRANSACTION records.

Does anyone have any ideas on a better way. What is going to happen to my indices during this time ?

Thanks !!!

View 3 Replies View Related

Data Missing When Loading Data Into Sql Server 2005

Jan 17, 2008



Hi, Experts

The project is a C/S data analysis system built with .Net 2.0 in windows environment, OS: Microsoft Windows 2003 R2 standard Edition Service Pack2, Database used in this project is: Sql server 2005. As a data analysis system, we need to load large amount of data from file to database, we do it by create a dts package and then do data loading by execute "m_Package.Execute(null, variables, m_PackageEvents, null, null)".

The problem is, we fount that DTS miss some data randomly sometimes, we can't find the rule till now. for example we've data as follows in data file, all data field splited by '|'
11234|26341|2007-09-03 00:00|0|0|0.0|0|0.011470833793282509|1|0.045497223734855652|0|0|1|0|3|2929|13130|43|0|2|0|0|40|1|0|0|0|0|0|1||0|0|3|0|0|0|0|0||0|3|0|0|43|43|0|41270|0|3|0|0|10|3|0|0|0|0|0||0|1912|0|0|3|0|0|0|0|0|0|0|3|0|0|5|0|40|0|9|0|0|0|0|0|0|0|0|29|1|1|24|24.0|16|16.0|0|0|0.0|0|0|24|23.980693817138672|0|0.0|0|0.0|0|0.0|0|0.0|11|2.0764460563659668|43|2|0|0|30|11|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|3|0|0|0|0|0|0|0|0|0|6|0|0|0|0|0|6|0|0|45|1|0|0|0|2|42|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|0|0|2|0|0|0|0|0|0|51|47|85|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||0|0|0|0|0|97.117401123046875|0|0|83|57|||0.011738888919353485|0|1|0.065955556929111481|0|4|||0.00026658669230528176|1|0.00014440112863667309|1|68|53|12|2|1|2.0562667846679688|10|94|2|0|0|30|11|47|4|13902|7024|6878|18|85|4.9072666168212891|5|0.0|0|0.0|0|0.0|0|0.0|0|358|6448|6324|0|0|0|0||0||462|967|0|41|39|2|0|0|0|1|0|0|0|0|0|0|0|0|3|0|0|3|0|0|0|0|0|0|0|0|0|3|0|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|46|0|1|0|1|37|0|0|46|0|1|0|1|37|0|0|0|0|0|0|0|0|0.0|0|0|6|4|2|0|0|2|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|1|0.012290795333683491|0|44|44.0|0|0.0|0|0|0|30|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|2|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|0|0|27|0|0|2112|411|411|45|437|2|0|2|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|4|0|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|6|6|0|3|2|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|600|600|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|6|0|0|0|0|0|0|6|0|9|1|2|2|3|0|1|0|0|0|0|0|0|0|0|0|0|0|13|3|2|5|1|1|1|0|0|0|102|0|1|1|0|0|0|3|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0||||||||||0|0|0|0|0|0|0||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|46.0|46|0.0|0|0.0|0|0.011469460092484951|1|0.0|0|0.0|0|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|100.0|100.0|0|1|0|1|0|0|0.02481505274772644|1|0.014951236546039581|1|0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|4695.5556640625|42260|7126.66650390625|62040|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||

11213|26341|2007-09-03 00:00|0|0|0.0|0|0.068584725260734558|2|0.14375555515289307|27|0|2|1|11|3966|13162|97|0|13|0|0|83|3|2|3|0|0|0|26||0|0|11|0|0|0|1|0||0|1|0|3|97|98|0|246795|0|11|1|0|3|14|0|0|0|0|0||0|1912|0|0|12|0|0|0|0|0|0|0|12|0|0|17|0|83|2|2|2|0|0|0|0|0|0|0|73|3|1|24|24.0|16|16.0|0|0|0.0|3|0|24|23.905364990234375|2|0.0040000001899898052|0|0.0|0|0.0|0|0.0|11|2.0772171020507812|97|7|0|0|80|10|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|12|12|0|0|0|0|0|0|0|0|0|41|0|0|0|0|0|41|0|0|99|25|0|0|0|0|74|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|2|0|0|0|0|0|0|0|0|0|0|177|158|332|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|3|||||||||||||0|0|0|0|0|0.0|0|0|321|198|||0.041950233280658722|0|2|0.1999288946390152|0|5|||0.00088306842371821404|1|0.00051651173271238804|1|529|113|4|8|2|2.0671226978302002|10|274|7|0|0|80|10|66|17|13934|7024|6910|31|332|4.7173333168029785|5|0.000033333333703922108|1|0.000033333333703922108|1|0.000033333333703922108|1|0.0|0|358|6448|6356|0|0|0|0||0||1609|3423|0|83|78|5|0|0|26|0|0|0|0|0|0|0|0|0|2|0|1|1|0|0|0|0|3|0|0|0|0|2|0|2|0|0|0|0|0|0|0|0|0|0|2|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|65|0|1|0|1|72|0|0|65|0|1|0|1|72|0|0|0|0|0|0|0|0|0.0|0|0|12|7|0|2|3|16|5|5|6|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|2|0.04131799191236496|0|48|48.0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|1|0|0|0|0|0|0|9|0|5|1|0|0|0|1|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|4|2|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|0|0|0|0|3|0|0|0|0|0|0|0|0|121|0|1410|6046|558|1400|192|2467|10|0|5|1|0|0|0|2|0|0|0|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|15|0|10|0|0|0|0|3|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|21|9|12|10|3|1|0|1|4|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|163|4|144|91|92|2|92|0|0|0|0|0|101|92|0|0|0|0|101|0|0|0|0|600|596|1|0|0|3|0|0|0|0|0|0|0|0|0|0|0|9|0|0|1|0|0|0|8|0|34|3|4|14|7|2|3|0|1|0|0|0|0|0|0|0|0|0|41|6|4|23|5|2|1|0|0|0|289|0|7|7|0|0|0|11|11|0|0|4|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|4|0|0|0|0|0|4||||||||||3|0|0|0|0|0|3||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|55.814689636230469|47.931411743164062|48|0.0|0|0.0|0|0.068584725260734558|2|0.0|0|0.0|0|14|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|1|0|0|1|0|0|0|0|0|||0|100.0|100.0|0|26|26|0|0|0|0.088263392448425293|2|0.056161552667617798|2|0|0|0|0|0|0|0|0|0|5|22|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|16308.888671875|146780|23162.22265625|184840|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||

11220|26341|2007-09-03 00:00|0|0|0.0|0|0.309184730052948|2|0.17757916450500488|0|0|7|4|18|3925|13682|172|0|19|0|0|164|10|5|4|0|0|0|2||0|0|20|0|0|1|4|0||0|5|0|4|172|172|0|1165085|0|20|4|0|20|8|0|0|0|0|0||0|1912|0|0|24|0|0|1|0|0|0|0|23|0|0|30|0|164|4|6|8|0|0|0|0|0|0|0|121|10|15|24|24.0|16|16.0|0|0|0.0|4|0|24|23.646148681640625|1|0.0040013887919485569|0|0.0|0|0.0|0|0.0|11|2.0849723815917969|172|5|0|0|123|44|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|26|24|0|0|0|2|0|0|0|0|0|192|1|0|0|0|0|191|0|0|190|12|0|0|0|0|178|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|0|0|0|0|0|1|0|0|0|0|1008|953|2758|0|5|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|4|||||||||||||0|0|0|0|0|84.418106079101562|0|0|2626|1420|||0.29022222757339478|0|5|1.5045944452285767|0|5|||0.0058597764000296593|2|0.0046600494533777237|2|1340|1114|80|119|27|2.2584490776062012|10|1180|5|0|0|123|44|953|55|14462|7024|7438|52|2758|3.0037333965301514|5|0.021266667172312737|1|0.00036666667438112199|1|0.0|0|0.0|0|362|6440|6880|0|0|0|0||0||13711|27667|0|159|149|10|0|0|1|1|0|0|0|0|0|0|0|0|7|0|0|7|0|0|0|0|4|0|0|0|0|7|0|7|0|0|0|0|0|0|0|0|0|2|3|0|0|0|0|0|0.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|842|0|111|0|102|1702|0|1|842|0|111|0|0|1703|0|0|0|0|0|0|0|0|0.0|0|0|47|26|11|3|7|37|1|20|16|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|4|0.24921548366546631|0|44|44.0|0|0.0|0|0|0|1003|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|10|0|8|2|0|0|0|0|0|0|0|0|0|0|81|1|60|10|10|0|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|25|16|4|2|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|53|27|17|4|5|0|0|0|0|0|0|0|0|0|421|0|8685|67179|2138|12104|80|26285|104|1|73|16|14|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|87|1|77|7|2|0|0|0|0|0|0|0|0|0|1|0|0|1|0|0|0|0|0|0|0|0|0|0|16|0|9|5|2|0|0|0|0|0|0|0|0|0|155|155|0|105|51|32|9|13|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|1|0|0|0|0|0|0|0|0|0|0|0|5|5.0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|102|0|0|0|0|0|600|445|4|20|32|63|16|15|4|1|0|0|0|0|0|0|0|37|0|0|5|0|0|0|32|0|230|7|10|99|68|22|21|0|3|0|0|0|0|0|0|0|0|0|286|18|10|182|53|17|6|0|0|0|2528|0|10|10|0|0|0|22|22|0|0|25|25|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||0|0|0|0|0|0|0|0|0|0|0||0|0|30|0|0|0|0|0|30||||||||||23|0|0|0|0|0|23||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0.0|45.998283386230469|46|0.0|0|0.0|0|0.30917638540267944|2|0.0|0|0.0|0|8|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|0|0.0|0|0|0|0|1|1|0|0|0|0|0|0|0|||0|100.0|100.0|0|2|1|0|0|1|0.73375397920608521|5|0.41600942611694336|6|0|0|0|0|0|0|0|0|0|0|0|0|0|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|||0|||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|98115.5546875|865520|176626.671875|1159360|||||||||||||||||||||||||||||||||||||||||||||||||||||||0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||||||||||0|0||||||||||

We found that some of the data field become 'null' after the load action finished, if we load the same data again, problem disappeared, we can't 100% reproduce this issue each time, we don't know why, Anybody here can help us to solve this issue or give us some clue?


View 3 Replies View Related

Xml To Sql 2005 Loading

Jun 19, 2007

Hi,

I'm dealing with loading xml data into sql 2005 relational tables

We are trying to do with C# class objects, what would be the better method to follow to load C# entity objects with xml data.



Xml has a complex 6 level heirarchy and with huge amounts of data.



please help.



-Thanks

Shiva

View 6 Replies View Related

Huge Log File On SQL Server 7

Feb 21, 2001

I have a huge log file (285M) on SQL Server 7.
The database itself is about 10M.
How can I reduce the log file ?
Is it possible to build it again from scratch ?

I tried the Truncate Transaction Log but it didn't help.

View 2 Replies View Related

SQL Server Huge Bug On Multiplication ?

Nov 28, 2007

When I run the following code :


DECLARE @var1 float,
@var2 int;
SET @var1 = 32.91 ;
SET @var2 = 100 ;
SELECT CAST(@var1 * @var2 AS int);

the result is ... 3290 (whereas it should be 3291 !)

Also works for @var1 set to 33.91 34.91 35.91 36.91 37.91 38.91 39.91 but not for other values > 40.

Is that a SQL Server bug ?

View 4 Replies View Related

Insert Huge Text File Into SQL Server

Dec 16, 2004

I am writing a .NET service, and I need to insert files in a SQL DB for temporary storage.

I have never inserted a file into a SQL database before. I am thinking about using the image field type. Has anyone done this before? How did you do it?

View 9 Replies View Related

SQL Server 2008 :: How To Migrate Huge Databases

Sep 27, 2015

I would like to migrate around 15 databases in production server to the new production server. The biggest database is 80 GB .

Wondering is there any fastest way to do that with very low downtime ?

What I can think about is shrink databases files and perform attach – detach .

View 8 Replies View Related

PULL Huge Table From SQL Server Problem

Jul 12, 2007



Hey Guys

I have meet the same problem, too.

I create a table with 1,380,000 rows data,

the db real size about 114 MB.

The primary key size is nchar(6).

When I use RDA pull, I found that the primary

key in the PDA disappear. So, It took a long time

to get query response.

But when I delete some rows to 680,000 rows of data.

After I pull, The primary key can pull from the SQL Server.

PS: I didn't change any code. Just delete some rows.

Is that SQL-Mobile's bug??



PS: 1.Database and Temp Database limitation both are 384MB

2.If I use query analyzer to add primary key it works! so strange!!

3.Pull process return "S_OK".

4.After Pull process finished, the db connection still alive. It seems not like

time out problem.

5.Local Connection String:"Data Source='%s\%s';SSCEatabase Password='%s';SSCE:Encrypt Database='true';SSCE:Max Database Size=384;SSCE:Temp File Max size=384;SSCE:Temp File Directory=%s"



View 1 Replies View Related

SQL 2005 Mobile Loading 2003 Cabs

Jun 14, 2006

I am moving a VS 2003 Pocket PC app to VS 2005 and when I deploy the app from Visuyal Studio 2005 two sqlce cabs are deployed (in addition to the sqlce30 ones) namely

sqlce20.dev.ppc.wce4.armv4.CAB

and

sqlce20.ppc.wce4.armv4.CAB.

Now as I have documented in another thread (SQL 2005 Mobile : The file is not a valid database file) this gives me problems when I want to access the database being produced by replication. So I'm trying to eliminate the need for these cab files.

My pocket PC application uses two of my DLLs the first of which is my Business Objects. When I deploy this to my PDA I get the following build output

------ Build started: Project: BO, Configuration: Release Any CPU ------
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Vbc.exe /noconfig

/imports:Microsoft.VisualBasic,System,System.Collections,System.Collections.Generic,System.Data,Sys

tem.Diagnostics /nowarn:42016,41999,42017,42018,42019,42032,42036,42020,42021,42022 /nostdlib

/rootnamespace:MVnet.VS2005CF.MobileSeller.BO /sdkpath:"C:Program FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCE" /netcf /doc:objReleaseBO.xml

/define:"CONFIG="Release",TRACE=-1,_MyType="Windows",PLATFORM="AnyCPU",PocketPC=TRUE"

/reference:"................Program FilesIn The Hand LtdADOCE In The Hand

v1.7RuntimeInTheHand.Data.Adoce.dll","................Program FilesIn The Hand LtdADOCE

In The Hand

v1.7RuntimeInTheHand.Interop.dll",..............VS2005CFReferences
eleaseMVnetApplicati

on.dll,"C:Program FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Data.dll","C:Program FilesMicrosoft

Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.dll","C:Program FilesMicrosoft

Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Drawing.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Web.Services.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Windows.Forms.dll","C:Program

FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Xml.dll" /debug:pdbonly

/filealign:512 /optimize+ /out:objReleaseBO.dll

/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.BO.frmError.resources

/resource:objReleaseMVnet.VS2005CF.MobileSeller.BO.Resources.resources /target:library

AmtechSynchroniser.vb AmtechAP_Board.vb AmtechAP_Circuit.vb AmtechAP_Completion.vb

AmtechAP_Domestic.vb AmtechAP_DomesticPeriodic.vb AmtechAP_DomesticSupplyCable.vb

AmtechAP_EmergencyLightingInspection.vb AmtechAP_FireDetectionCommissioning.vb

AmtechAP_FireDetectionInstallation.vb AmtechAP_FireDetectionServicing.vb

AmtechAP_FireDetectionSystemRevised.vb AmtechAP_FireDetectionVerification.vb AmtechAP_Job.vb

AmtechAP_MinorWorksNIC.vb AmtechAP_Periodic.vb AmtechAP_PeriodicBoardTest.vb

AmtechAP_PeriodicCircuitTest.vb AmtechAP_PeriodicRecommendations.vb AmtechAP_ProtectiveDevice.vb

AmtechAP_StandardRecommendations.vb AmtechAP_VersionInfo.vb AmtechICDBEntity.vb basMain.vb

basSQL.vb cAddress.vb cAnswer.vb cBlockAllocation.vb cBO.vb cCompany.vb cCustomer.vb cCustomerF.vb

cInvoice.vb cInvoiceLine.vb cJob.vb cNote.vb cOrder.vb cOrderF.vb cOrderLine.vb cPaymentLine.vb

cPaymentLineF.vb cPDA_Update.vb cProduct.vb cProductF.vb cProductStock.vb cProductStockF.vb

cQuestion.vb cQuestionAnswer.vb cReceipt.vb cRep.vb cRepF.vb cRepProductPrice.vb

cRepProductPriceF.vb cRepProductStock.vb cRepStockAdjustment.vb cRepStockOrder.vb

cRepStockOrderF.vb cSalesPosition.vb cSalesPositionF.vb cSupplier.vb cType.vb cTypeF.vb cVatCode.vb

cVisit.vb cVisitF.vb Database.vb EntityHelper.vb FleetMindercMakeModel.vb FleetMindercVehicle.vb

frmError.vb GradusGradusReport.vb IEntityForm.vb IManagedForm.vb ISQLInEntity.vb "My

ProjectAssemblyInfo.vb" "My ProjectResources.Designer.vb" PageSelection.vb PDAProduct.vb

Property.vb RDAControl.vb Synchroniser.vb "Web ReferencesFeedBackWSReference.vb" "Web

ReferencesWSPDADBReference.vb"
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(152) :

warning BC42104: Variable 'TableConfig' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(166) :

warning BC42104: Variable 'ATTable' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(292) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(350) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(400) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(458) :

warning BC42104: Variable 'rstab' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(557) :

warning BC42104: Variable 'rsTab' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(611) :

warning BC42104: Variable 'Table' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(812) :

warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(856) :

warning BC42025: Access of shared member, constant member, enum member or nested type through an

instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(952) :

warning BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1000) :

warning BC42025: Access of shared member, constant member, enum member or nested type through an

instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1004) :

warning BC42025: Access of shared member, constant member, enum member or nested type through an

instance; qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1009) :

warning BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1020) :

warning BC42104: Variable 'CDBSelectSQL' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechSynchroniser.vb(1078) :

warning BC42104: Variable 'oProp' is used before it has been assigned a value. A null reference

exception could result at runtime.
vbc : warning BC42206: Maximum number of warnings has been exceeded.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb(231) : warning

BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Circuit.vb(239) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Completion.vb(812) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Domestic.vb(543) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticPeriodic.vb(606

) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_DomesticSupplyCable.vb(

284) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_EmergencyLightingInspec

tion.vb(362) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionCommission

ing.vb(270) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionInstallati

on.vb(268) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionServicing.

vb(609) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionSystemRevi

sed.vb(293) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_FireDetectionVerificati

on.vb(277) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Job.vb(340) : warning

BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_MinorWorksNIC.vb(314) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Periodic.vb(619) :

warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicBoardTest.vb(22

7) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicCircuitTest.vb(

239) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_PeriodicRecommendations

.vb(181) : warning BC42107: Property 'CDBKeyProperty' doesn't return a value on all code paths. A

null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(113) : warning

BC42105: Function 'Version' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(176) : warning

BC42105: Function 'RepLogOn' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(443) : warning

BC42105: Function 'ExecuteSQL_ReturnIdentity' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(513) : warning

BC42105: Function 'InitialiseServiceOrderLines1' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(585) : warning

BC42105: Function 'GetVisit1' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(656) : warning

BC42105: Function 'GetCustomer1' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(728) : warning

BC42105: Function 'GetProduct1' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(798) : warning

BC42105: Function 'GetDataSet' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(868) : warning

BC42105: Function 'GetScalar' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1012) : warning

BC42025: Access of shared member, constant member, enum member or nested type through an instance;

qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1134) : warning

BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1176) : warning

BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBODatabase.vb(1217) : warning

BC42104: Variable 'oCMD' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(238) : warning

BC42105: Function 'SelectSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(342) : warning

BC42105: Function 'InsertSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(404) : warning

BC42105: Function 'UpdateSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(460) : warning

BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(522) : warning

BC42104: Variable 'Prop' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(634) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(847) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(959) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOEntityHelper.vb(1083) : warning

BC42104: Variable 'oReader' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :

warning BC42104: Variable 'CurrentMake' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercMakeModel.vb(116) :

warning BC42104: Variable 'NewMake' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOFleetMindercVehicle.vb(132) :

warning BC42104: Variable 'V' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(39) :

warning BC42105: Function 'DisplayName' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOGradusGradusReport.vb(64) :

warning BC42105: Function 'CurrentSection' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(341) : warning

BC42105: Function 'ProductTypeInList' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(419) : warning

BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'SelectSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'StockSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'CategoryValue2' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(550) : warning

BC42104: Variable 'ProductSupplierJoinSQL' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(748) : warning

BC42107: Property 'SelectSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(791) : warning

BC42107: Property 'CountSQL' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPDAProduct.vb(850) : warning

BC42107: Property 'Products' doesn't return a value on all code paths. A null reference exception

could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOPageSelection.vb(8) : warning

BC40055: Casing of namespace name 'bo' does not match casing of namespace name 'BO' in file

'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOAmtechAP_Board.vb'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOSynchroniser.vb(213) : warning

BC42104: Variable 'ErrorInfo' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(217) : warning BC42107:

Property 'AmtechDBPath' doesn't return a value on all code paths. A null reference exception could

occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcBO.vb(582) : warning BC42104:

Variable 'TableName' is used before it has been assigned a value. A null reference exception could

result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCompany.vb(848) : warning

BC42024: Unused local variable: 'Setting'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(924) : warning

BC42104: Variable 'SaveCurrentVisit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomer.vb(974) : warning

BC42105: Function 'GenerateInvoices' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcCustomerF.vb(419) : warning

BC42104: Variable 'WhereSQL' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(411) : warning BC42105:

Function 'InvoicedVisitWithNoPO' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcJob.vb(449) : warning BC42104:

Variable 'V' is used before it has been assigned a value. A null reference exception could result

at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(7) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain

any public member or cannot be found. Make sure the namespace or the type is defined and contains

at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcOrderF.vb(9) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.VS2005CF.MobileSeller.WebServices' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(202) : warning

BC42105: Function 'RootQuestions' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestion.vb(212) : warning

BC42105: Function 'Questions_ForCompany' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(238) : warning

BC42105: Function 'AnswersForQuestion' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(244) : warning

BC42024: Unused local variable: 'sSQL'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcQuestionAnswer.vb(254) : warning

BC42105: Function 'AnswersForQuestion_IncludeUserAnswers' doesn't return a value on all code paths.

A null reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcRepF.vb(354) : warning BC42104:

Variable 'oRep' is used before it has been assigned a value. A null reference exception could

result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(905) : warning BC42105:

Function 'PopulateComboFromRepProductCategories' doesn't return a value on all code paths. A null

reference exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(917) : warning BC42025:

Access of shared member, constant member, enum member or nested type through an instance;

qualifying expression will not be evaluated.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(967) : warning BC42024:

Unused local variable: 'sValue'.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1228) : warning

BC42104: Variable 'nCol' is used before it has been assigned a value. A null reference exception

could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1300) : warning

BC42104: Variable 'PaymentsSplit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1318) : warning

BC42104: Variable 'NoSignaturesSplit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1336) : warning

BC42104: Variable 'CancellationsSplit' is used before it has been assigned a value. A null

reference exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1356) : warning

BC42104: Variable 'NotesColonSplit' is used before it has been assigned a value. A null reference

exception could result at runtime.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcTypeF.vb(1413) : warning

BC42105: Function 'VisitResultCodes' doesn't return a value on all code paths. A null reference

exception could occur at run time when the result is used.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisit.vb(12) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(8) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.PhoneAPI' doesn't contain

any public member or cannot be found. Make sure the namespace or the type is defined and contains

at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(9) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.CodeCabinet.VS2005CF.MVnetApplicationVB' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOcVisitF.vb(10) : warning BC40056:

Namespace or type specified in the Imports 'MVnet.VS2005CF.mobileseller.WebServices' doesn't

contain any public member or cannot be found. Make sure the namespace or the type is defined and

contains at least one public member. Make sure the imported element name doesn't use any aliases.
BO -> C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll
------ Deploy started: Project: BO, Configuration: Release Any CPU ------
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL

ServerMobilev2.0System.Data.Common.dll'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL

ServerMobilev2.0wce400ARMV4sqlce20.ppc.wce4.armv4.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL

ServerMobilev2.0wce400ARMV4sqlce20.dev.ppc.wce4.armv4.cab'
Deploying 'C:DevVS2005CFReferences
eleaseMVnetApplication.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand v1.7RuntimeInTheHand.Interop.dll'
Deploying 'C:Program FilesIn The Hand LtdADOCE In The Hand

v1.7RuntimeInTheHand.Data.Adoce.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll'
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========


which as you can see is bringing in the two cabs.

Is there an easy way to determine what exactly requires these two cabs?

I strongly suspect that it's a third party stuff from ADOCE which I'm using to access access databases on the PDA.

View 5 Replies View Related

Huge Performance Difference When Running UDF In Workstation Vs Server

Dec 13, 2007

Hi,

I created a CLR UDF that returns a large number of rows, when I run it from my VPC (XP, SQL Server Developer Edition and 1GB Memory) it takes approx 2 min and 30 secs to start displaying the rows (Using Management Studio), when I run the same query in our development server (Win 2003, SQL Server Enterprise Edition, 8 GB Memory and 8 Processors) it takes more than 15 min to start displaying the results, does anybody have an idea why is this happening?

Thanks in advance

View 2 Replies View Related

SQL Server 2014 :: Huge Number Of Rows In Table Spool

Jul 6, 2015

I have a CTE query against a table with 32K rows that runs fine in 2008R2. I am running it in 2014 Std Ed. against the same data and it runs very slowly. Looking at the execution plan I think I see what's contributing to the slowness.

Note that the "actual number of rows" is some 351M...how is this possible?

the query:

declare @amts table (claim int,allowed decimal(12,2),copay decimal(12,2),deductible decimal(12,2),coins decimal(12,2));
;with unpaid (claimID) as (select claimID from claim where amt+copay + disct+mm + ded=0)
insert @amts
select lineID, sum(rc), sum(copay), sum(deduct),
case when sum(mm)>0 and (sum(mm)<sum(mmamt)) then sum(mm) else 0 end
from claimln
where status is null
and lineID not in (select claimID from unpaid)
group by lineID

it's like there's some massively recursive process going on?

View 5 Replies View Related

[SQL Serevr 2005 Express] Loading Data From An Excel Sheet

Apr 20, 2006

Hi,

View 3 Replies View Related

How To Work With Huge Amount Of Records In A Table Using MSSQL Server 2000?

Dec 21, 2005

In
one of our forth coming projects, with ASP.Net/C#/MSSQL Server, We have
to deal with a Business table having about 15 millions of records. We
want to know, that which methodologies should we adopt, both regarding
front end and back end perspective, so the site could give optimised
performance. Also in place of a Dedicated Server, the Hosting Company
provides MSDE (that come with .net). Will this create any problem with
this project, that have such a huge table? Should we go for some
advanced database technique, such as, Clustering, Spliting Tables, etc.

Followings are the fields that the business table contains:

ID, Category ID (which comes from a Category table, each business is
under a category), BusinessName, SignupDate, Address1, Address2, Phone
Number,
Hours Of Operation, Years in Business, LicenseNumber, DiscountCoupon, Website

View 3 Replies View Related

SQL Server 2008 :: Huge Volume Of Records To Copy To Excel File Through SSIS

Oct 22, 2015

I am copying data from database to an excel file through SSIS. database is MS SQL 2005 and BIDS is also 2005.However, the job doing this task fails every time.As per investigation, the result of the query is more than 100,000 rows and we know that excel has a limit of 65000 rows of data.Is there a way of setting the limit up? or something? a better approach maybe so that everything will be copied to the excel file successfully.

The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error Error: 2015-10-22 04:34:58.05 Code: 0xC0047021

Source: Data Flow Task
Description: SSIS Error Code DTS_E_THREADFAILED.

Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:30:00 AM Finished: 4:35:05 AM Elapsed: 304.844 seconds. The package execution failed. The step failed. "

View 1 Replies View Related

SQL Server Admin 2014 :: Huge Traffic Between Share Point Front End Servers To Content Database?

Feb 20, 2014

We have a Customized share point application with Very minimal data usage and we have used only 5 to 6 lists and libraries only in the share point.

Configuration is

Clients -- fire wall --- Load Balancer ---- WF1 and WF2 --- SQL DB

ROUTING IS VIA FIRE WALL.

SUDDENLY THE SITE GOT DEAD SLOW AND UNABLE TO TRACE THE PROBLEM AS EVERY THING LOOKS FINE.

Checked with the firewall Team and they stated its fine from their end & even we have verified the counters, CPU, Memory & Page life expectancy, buffer counters all looks good and even we do not have huge data in the database. We have only 50 concurrent users are working...

View 2 Replies View Related

Loading To SQL Server

Jan 26, 2006

What is the fastest way I can load data into SQL SErver -- it seems to me it's with Bulk Copy and minimal logging. But that seems very slow when I look at Orace's Data Pump and DB2's LOADer. Does SSIS help here -- from what I can tell, you help me tons and tons on the ET part, but the L is what I'm wondering about...

View 5 Replies View Related

DTS LOADING FROM MainFrame To SQL Server

Sep 18, 2000

hi
I am loading from Mainframe to Sqlserver.
Right now i am truncating the tables in sqlserver connecting to mainframe and downloading the tables to Sql server. The problem is sometimes i fail to connect to Mainframe. So is there any way of checking whether i can connect to mainframe and if succesful truncate the tables.
Thanks

View 1 Replies View Related

How To Optimize Data Import With Huge Volumes And Joins Across Data Sources Not All SQL Server Based?

Jun 7, 2006

I need to periodically import a (HUGE) table of data from an external data source (not SQL Server) into SQL Server, with the following scenarios:
Some of the records in the external data source may not exist in SQL.Some of the records in the external data source may have a different value at different imports, but this records are identified univocally by the same primary key in the external datasource and in SQL Server.Some of the records in the external data source may be the same in SQL.

Due to the massive volume of the import, I would like to import only the records which are different from what I have in SQL Server (cases 1 and 2 above). In fact case 2 is the most critical.

I thought of making a query with a left outer join between the data in the external data source table (SOURCE) and the data in the SQL Server table (DESTIN). The join is done on the respective primary keys (composed keys of up to 10 columns) and one of the WHERE conditions will be that the value in SOURCE is different from the value in DESTIN.

The result of this query would be exactly what I need to import.
How to do this in SSIS??? I couldn't figure out how to join tables in different data sources yet.

In fact I cannot write a stored procedure to do that, since one of the sources is in a datasources not SQL Server.
I have seen the Lookup transformation in this article http://www.sqlis.com/default.aspx?311 but this is not exacltly what I want to do.
Another possibility is to use the merge join, but due to the sorting I believe its performances would be terrible!

Thanks in advance for your suggestions!

View 9 Replies View Related

Loading SP 5a Dump Onto Server Running SP 4

Oct 5, 1999

I looked for an answer in the archives and could not find one.
Does anyone know if it is ok or works loading a database dump
from one SQL server running SP 5a (production server) onto another SQL server running SP 3 (backup server)? We were not planning to upgrade our production and backup servers simultaneously unless there would be a problem loading the
database dumps.

Thanks you in advance.

View 2 Replies View Related

Loading Transaction Logs From One Server To Another

May 14, 1999

I am trying to setup 2 SQL servers (ver 6.5) - A live server and a standby server. The plan is to have regular transaction logs dumps from the Live server databases to the standby server and then have these logs automatically applied.

I have managed to get the logs dumping automatically but when I tried to apply them I keep getting synchronisation/sequence errors.

Has anyone done/tried anything similar. Any advice on this would be very useful.

Thanks
Samir

P.S I can't do this via replications as most tables in the database do not have primary keys.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved