Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: ado.net

What is the purpose of sqlbulkcopy’s useinternaltransaction property?

By adminPosted on January 25, 2023

Question : I’m just testing my PowerShellScript to do bulkcopy of multiple tables between sql-server and oracle Databases. When the […]

Does Sql Server caches parameterized anonymous blocks?

By adminPosted on December 13, 2022

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

By adminPosted on November 27, 2022

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?

By adminPosted on October 22, 2022

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?

By adminPosted on September 19, 2022

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

By adminPosted on May 30, 2022

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?

By adminPosted on April 11, 2022

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

By adminPosted on March 2, 2022

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

By adminPosted on February 22, 2022

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?

By adminPosted on February 10, 2022

Question : I’m just testing my PowerShellScript to do bulkcopy of multiple tables between sql-server and oracle Databases. When the […]

  • 1
  • 2
  • 3

Recent Posts

  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication
  • Is the overhead of frequent query cache invalidation ever worth it?
  • MongoDB deleted logs
  • TSQL Copy an existing database

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding