|
Use a DTS package or a SQL server Job to schedule the stored procedure. You can setup failure notifications emails.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Hello,
I have a program in VB 2005 Express Edition which accesses an SQL Server 2005 Express Edition database.
I have 600,000 rows of data in a comma-delimited text file that I need to add to an existing table.
Is there a way to import this data quickly into the table? (Copy/Paste will take forever, as I am discovering) I know it is easy to do Access use 'Get External Data' from the 'File' menu.
Your help would be greatly greatly appreciated!
-Lee
|
|
|
|
|
Have you tried the import/export wizard that comes with SQL 2005 Express? You might want to look at:
C:\Program Files\Microsoft SQL Server\90\DTS\Binn for DTSWizard.exe
It might be helpful 
Paul
|
|
|
|
|
Beautiful...This sounds like just the thing I need. Only problem is, I've search my whole system for DTSWizard.exe and it's no on my computer.
Is it possible to install it as an add-in, or do you think I need to re-install SQL Server?
Thanks a bunch. Oh and sorry for cross posting. 
-Lee
-- modified at 20:24 Thursday 20th July, 2006
|
|
|
|
|
kscadi wrote: Thanks a bunch. Oh and sorry for cross posting.
Don't worry about it  Just a friendly reminder.
kscadi wrote: DTSWizard.exe
I don't recall where DTSWizard is found. I think it is a part of the SQL Server Management Studio Express package. I could be wrong, though. Honestly, it's been a while since I've installed SQL 2005 Express and its tools :->
|
|
|
|
|
Look up the documentation for bcp.exe.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
SQL2005 no longer provides the DTS services or like a wizard as in SQL2000, it is now provides as one of the services. Take a look at that.
Thanks.
Vani
|
|
|
|
|
VK-Cadec wrote: SQL2005 no longer provides the DTS services or like a wizard as in SQL2000
Are you sure about this? DTSWizard.exe came with SQL 2005 Express as I stated earlier
|
|
|
|
|
Hi. i want to Get information for each table in DataBase.
especially i want to get column type and column size. (I want to use OleDb) i used OleDbSchemaGid and some select statements but most of its returns are (null) and doesnt have any useful information.
|
|
|
|
|
From where do you want to use OLEDB?
C#, VB.NET, Managed C++ or native code?
If the latter, there is stuff in ATL DB Client templates that will help.
Steve S
Developer for hire
|
|
|
|
|
from C# in a Windows form app
|
|
|
|
|
If your database is SQL Server try looking up Information_Schema views in the books online.
Select * from Information_Schema.Tables
will give list of all the tables.
--
Don't take life seriously because you can't come out of it alive.
-Warren Miller
(From Monty2[^] bio)
|
|
|
|
|
No. I want to use OleDb. I want to write a Program for all kind of Databases like access,Oracle and ... . is there any standard SQL statement for that.
|
|
|
|
|
hamidreza_buddy wrote: No. I want to use OleDb. I want to write a Program for all kind of Databases like access,Oracle and ... . is there any standard SQL statement for that.
You have to create separate connection for each type of database.
Regards
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
I guess not. Doing 10 Find() operations on a large table (55000 records) loaded into a BindingSource component always takes about 1.8 secs, with or without a primary key set on the column being searched.
Any ideas on how to add an indexed field to speed up searching?
Kees
|
|
|
|
|
I guess you've bound DataTable or DataSet to your control? If so, table is searched as it was an array of objects, not as a table in a database. Hence, indexes don't matter.
If you want index to speed up the process then you need to perform search by database. Just execute query again with different WHERE clause.
|
|
|
|
|
Thanks for your reply, your information is very clear.
|
|
|
|
|
I am having one physical table in which there are 5 columns and 20,000 rows (say first table) and i want to insert those rows into another physical table(say second table) but before insertion all rows into second physical table ,i need to fetch exact ids of each columns from diff-diff. tables from first phy. table and then when i get those ,insert those ids into second physical tables.
Here i am planning to use joins to fetch appropriate id but joins can only usefull when i give one row at a time.I don't want to use cursor to fetch single rows becoz it reduce performance.
is there any other way like for-loop in sql server 2005 from which i can loop throw one by one records(rows) till end of first physical table?
montu3377
|
|
|
|
|
While the following will sap performace ...
You can write a function that will take in parameters and then return the ID. Then you can write a simple looking select statement. It is heavy on the machine but works fairly well.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Can't you do something like this:
INSERT INTO table2 (field1,field2,field3,field4,field5)
SELECT (SELECT table3.field2 FROM table3 WHERE table3.field1 = t1.field1) AS field1,
field2,field3,field4,field5 FROM table1 t1 INNER JOIN table4 t4 ON t1.fieldx = t4.fieldy
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
I have a VB.NET program that sits out on the network for people to access. This program makes numerous calls to a SQL database. There have been no changes made in the last few days. Today users are getting the error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." IT said the server looks fine. What other items should I look at to find the problem?
|
|
|
|
|
If nothing else has changed, as you have stated, it is probably that the network load is heavy and client requests are not returning within the timeout period.
If the timeout is occuring during the connection to the database, increasing the connection timeout period in the connection string should solve the problem.
|
|
|
|
|
Your queries are probably not optimised very well. It's very likely that you don't have a suitable index to use on a particular column, which means that the query optimiser decides it has to read every row ('Table Scan' or 'Clustered Index Scan' depending on whether or not you have a clustered index), which means that the time to execute increases with every row added.
I look in SQL Profiler to find the most costly queries, then use the Show Execution Plan feature in Query Analyzer to see what the optimiser did. The easiest thing to do to speed performance is to try to spot the table scans and add an index which contains the fields it's looking for in the WHERE clause.
Note that adding indexes will have an impact on INSERT, UPDATE and DELETE operations, due to the need to maintain the indexes. You need to balance this cost against the improvement in lookup times - not just on SELECTs but of course INSERT, UPDATE and DELETE all need to find records, so the indexes can help with this too.
If you're looking up on only part of a compound primary key, and the key fields you have don't include the top level of the key, consider re-ordering the fields in your key, or supplying the rest of the key information to the query.
If it's not fast enough after doing this, check for Bookmark Lookup operations. This is where SQL Server is cross-referencing between the index it used to find matches and either the base table or the clustered index, in order to check other fields in the WHERE clause that aren't in the index, or output data that you have in the SELECT clause. If this is happening you can help it out by adding the extra fields to the index as well.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
I use VCPP 6.0 and SQLExpress to connect to a database that contains 4 fields, one of the field holds the date and time. I want to be able to view entries between let's say 5 august 2005 21:30 and 8 august 23:30. I'm using the strFilter to run the queries but i got stuck when i was trying to use it on my date field. Should i separate the date from the time or smth? i think it's to late for my database.
|
|
|
|
|
Use stored procedures! (My fingers are getting cramped from writing that in this board)
in SQL you can
SELECT * FROM table WHERE effective_date BETWEEN @startDate AND @endDate
There are also methods to convert a date to a sting to make date only comparisons simple. Use yyyymmdd for this though.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
