Power BI excels (see what I did there?) at importing data from various sources and working off of its own copy. The people (mis)using it need to learn how to do it correctly and not hit SQL on every freakin' mouse click.

I always have a folder called _A in the root of each (fixed) drive on my systems. This means it's always at the top of the directory listing and quicker to find than "stuff". All "temporary" or "uncategorisable" stuff goes in there and every few months I have a cleanout.

It would probably be easiest to test this using LIKE: LIKE (Transact-SQL) - SQL Server | Microsoft Docs[^] Eg: "I" followed by five numbers would be: value LIKE 'I[0-9][0-9][0-9][0-9][0-9]' "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

I designed with it all my home-made furniture... You actually write some C-like code and have a nice 3D model... "The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012

Execution plan is depending on multiple factors. How to optimize? Get rid of excess colunms, get red of the date-constriction, get rid of region. Best idea; find a damn programmer. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

This is the response I was looking for! Going to definitely check these out.

It's the recommended approach - create the connection as close as possible to where it's needed, and wrap it in a "using" block to make sure it's disposed of as soon as you're done with it. Connection pooling will automatically keep a pool of the low-level connections alive to speed up reconnecting. So long as you're using the same connection string each time, and you dispose of the connection when you're done with it, you shouldn't have any performance issues caused by connecting to SQL. SQL Server Connection Pooling - ADO.NET | Microsoft Docs[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Both process are different based to the file availability process will kick start. Monthly I am getting deadlock issue when both the files are available at same time by utilizing the same table. As per my knowledge, I need to set lock/ Isolation level at store procedure to overcome this issue.

Wow!! I finally figured it out because I screwed around with -classpath so much!!. I'm on Windows so the separator has to be ; not a : Once I did that your instructions worked with the following java command: java -classpath classes;lib/* JDBCTest Notice I removed the test. (pkg name) and I changed the : to a ; While trying to get it working, I changed the output to have separate lines : SQLServerDriver:1 8 2 Thanks so much, you got me there. Phew...

#realJSOP wrote: if you're going to create those assemblies, why not just put them in your app? Because there may be many apps. You may want some functions to carry out e.g. consistency checking (beyond what you can set up in the SQL schema) regardless of which application is used. Think of such code as belonging to the schema, not to the data.

kali siddhu wrote: If i found matched record i am updating otherwise insert Right there is your problem, for every record you are checking for an existing record and when you do the update the system has to check referential integrity. Split your data into 2 set, those to be inserted and those to be updated. OR delete the records to be updated and insert all records. This may not be viable as it will break existing RI. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Get a book and work through the examples or work through one of the many articles here. Once you have learned the basics feel free to ask for help with specific issues you will come across. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

Because you are sick. The forgotten roots of science | C++ Programming | DWinLib

jsc42 wrote: The message you have got is fairly generic for a million and one database issues and does not necessary mean that you have a timeout despite the words in the message. Doesn't necessary mean that, but often does. jsc42 wrote: Often it is intermittent and can be got around by re-requesting the transaction? So why the question mark? You unsure? jsc42 wrote: If that is the case in your situation, I'm afraid it is one of the "tough - that's life, live with it" problems. No, it ain't; and if you encounter it, you pay me for the solution. I've seen and solved it; sometimes it is the query, sometimes it is the processing of the results; and before you even dare to make an offer, make it a fakkin' sweet one, since I aint tempted easily, especially not after a lecture of someone who is swimming in sand. Get back to your basket, I'm in a foul mood. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

You could try string xml = System.Text.UnicodeEncoding.GetString(theByteArray); If this does not produce proper result, you could also try one of other encodings provided by the framework: Encoding Class (System.Text) | Microsoft Docs[^]. "Five fruits and vegetables a day? What a joke! Personally, after the third watermelon, I'm full."

You're also storing passwords in plain text. Don't do that. Secure Password Authentication Explained Simply[^] Salted Password Hashing - Doing it Right[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Not the first time, it previously was due to timing / cache problems EDIT: Another possibility... there are a revision 4[^] as draft and a revision 5[^] as pending. When I reported rev. 5, it was the #1 Maybe it is ignoring the 7 reports because of the following version? M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.