Database

Why do you need to convert to CSV, why not just read the data from the Excel file and send it direct to the database? And why have you posted the question twice with slightly different details?

Based on the requirements you posted (none) the best one is going to be the one that your or the other developers have the most experience with.

I would start with writing a code that runs as windows service and can do what you need.

This site is not associated with such things: they are a deliberate distortion of statistics designed to fool users into thinking a site is more popular than it is. Go to google, and try there: Buying of referrals - Google Search[^] Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!

Psst the best way to thank Richard (the CTE guru) is to up vote his response. Voting arrows appear on the left of the message. Never underestimate the power of human stupidity RAH

Yes, you did. Thank you very much. I will have a closer look tomorrow.

Manish K. Agarwal wrote: Also every time I want to select all possible values for given NAME. Not exactly what you said above, to be fair. It also doesn't say whether this is native or web-based, which has a relevant impact on performance of the system as a whole. If writes are rare in either case, you'll see better SELECT performance out of option 2 for one simple reason: assuming that you index the key, when it's found the appropriate key, it's done and will stop searching the table. If you're in a web environment, you have the added benefit of being able to send it straight down the pipe with no serialization/deserialization required. If all your model requires is selection speed, option 2 is the way to go. Option 2 is definitely not write friendly, though, nor can you use it to relate data down the road on the database level. If these are likely or even possible considerations, you might want to go with option 1. "There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli

So then you can do the following 1. Keep the file 2.During the day run the same process/processes on that in a development environment. 3.Profile the applications and turn on tracing every where you can. 4. Analyze the results. 5. Update as needed based on 4 including the possibility of modify the process/processes to provide addition trace data so you can further refine and define future problems.

Thank you Jörgen. The difficult we do right away... ...the impossible takes slightly longer.

Thanks. Looks great. I signed up. Cheers, Mike Fidler "I intend to live forever - so far, so good." Steven Wright "I almost had a psychic girlfriend but she left me before we met." Also Steven Wright "I'm addicted to placebos. I could quit, but it wouldn't matter." Steven Wright yet again.

Your question is not very clear. Are you after certain columns from the sys.sysdatabase view? Are you after looking at certain information about a database? Are you looking at comparing tables within one or more databases? Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON

Depends on usage... But one implementation, as I already suggested would be to pass in a 'page' and 'page size'. Then your method finds the 'page' and returns no more than 'page size' items. Then your 'Array' would never be any bigger than 'page size'. Could be less because there could be less than that.

Not if you lean on interfaces and follow the repository pattern to wrap your EF DataContexts. I generally throw a "core" or "common" library into my solutions to serve this purpose, and MEF my repository into the mix. This is also nice because it does not marry you to the EF implementation. Yes, you will be coupled to an abstraction, but that's more or less the point in my eyes. "There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli

If you sign up for a free Visual Studio Dev Essentials[^] account from Microsoft, it includes a free copy of SQL Server Developer Edition. Also, the latest version of SQL Server Management Studio[^] is a separate download, and is also free. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Based on other responses. So database is MySQL and you want to look at what statements were used. From that you want "General query log" MySQL :: MySQL 5.7 Reference Manual :: 5.4 MySQL Server Logs[^] However be very careful if you are using this on a production machine. You want to insure that the log files do not use up the entire file system. Member 13536030 wrote: if someone does a select * from any of the tables Just noting that is a bad idea. Shouldn't be allowed. Hinders maintenance work and things like exactly what you are doing. However you can't tell whether the client is using a specific column or not even if it was specified. But if "*" is used then you will know for a fact it is being returned.

thank you .for your reply mate.

Seems like a bad design, but here's the setting you need to change: Configure the nested triggers Server Configuration Option | Microsoft Docs[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

The primary use of sp_ExecuteSQL is when you the Database Developer absolutely needs to create Dynamic SQL, and not for protection. While what you have written appears safe, there is no need for Dynamic SQL and you are only adding a layer of service and reducing performance. Director of Transmogrification Services Shinobi of Query Language Master of Yoda Conditional

This has been answered at Change old store to new store[^] In future, do not cross-post across forums. Pick one and be patient - we do this in our spare time for free - sometimes it can take a little while :)

indian143 wrote: if the file is open, its reading the file and running the Package properly You might want to examine that assumption. The fact that it doesn't produce an error that you see, is not sufficient to prove that it worked. It must process the file and produce output that it could have only gotten from the file.