Question : I’m just testing my PowerShellScript to do bulkcopy of multiple tables between sql-server and oracle Databases. When the […]
Tag: ado.net
Does Sql Server caches parameterized anonymous blocks?
Question : “Anonymous block” is a term from Oracle. But speaking of the thing for sql server Declare …. Begin […]
Stored procedure big where clause or multiple procedures
Question : Is it better to have one big query or N small ones? For example to select all the […]
What is the relationship between ADO.NET and Npgsql?
Question : There is a sentence in the Npgsql official page: Npgsql is an open source ADO.NET Data Provider for […]
How to track SSIS memory and CPU performance?
Question : I may be missing some pieces to this puzzle, but this is what I have: All of this […]
Use serial ID for multiple columns and return it from INSERT
Question : I am using Npgsql and I want to be able to do an insert, and if statement that […]
How can I setup and use a PostgreSQL database without installing a driver?
Question : I have a portable PostgreSQL database that runs perfectly on my computer as a database server. This is […]
SSMS returns results immediately; ADO takes longer
Question : I am running a query that returns ~250k results. It is basically SELECT * FROM my_schema.my_view (and the […]
Trying to get a large amount of data (column type is “text”) from an MS SQL Server
Question : I want to get like 300MB of data (text column) out of an MS SQL Server, but with […]
What is the purpose of sqlbulkcopy’s useinternaltransaction property?
Question : I’m just testing my PowerShellScript to do bulkcopy of multiple tables between sql-server and oracle Databases. When the […]