tagged [database]
Adding MySQL.Data as a Reference in Visual Studio Ultimate 2010
Adding MySQL.Data as a Reference in Visual Studio Ultimate 2010 I'm creating a new C# project. I want to connect it with the MySQL server. When I click Add Reference, MySQL.Data is not shown. This lea...
- Modified
- 21 Jun at 10:24
Persist Security Info Property=true and Persist Security Info Property=false
Persist Security Info Property=true and Persist Security Info Property=false For the properties: and Can you tell me what is the difference between them, and if I don't put it in my connection what wi...
- Modified
- 24 May at 04:3
How big can a MySQL database get before performance starts to degrade
How big can a MySQL database get before performance starts to degrade At what point does a MySQL database start to lose performance? - - - I have what I believe to be a large database, with roughly 15...
- Modified
- 27 Jan at 23:40
Primary key or Unique index?
Primary key or Unique index? At work we have a big database with unique indexes instead of primary keys and all works fine. I'm designing new database for a new project and I have a dilemma: In DB the...
- Modified
- 30 Aug at 13:59
Database, Table and Column Naming Conventions?
Database, Table and Column Naming Conventions? Whenever I design a database, I always wonder if there is a best way of naming an item in my database. Quite often I ask myself the following questions: ...
- Modified
- 29 Sep at 14:40
How to replace a string in a SQL Server Table Column
How to replace a string in a SQL Server Table Column I have a table (`SQL Sever`) which references paths (`UNC` or otherwise), but now the path is going to change. In the path column, I have many reco...
- Modified
- 27 Mar at 11:8
mysql query speed
mysql query speed I just want to ask which out of the two ways of storing data would give my better results A. Storing data in a single table with over 20+ columns OR B. Distributing the data into two...
- Modified
- 31 Jul at 13:39
How to get a list of column names on Sqlite3 database?
How to get a list of column names on Sqlite3 database? I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist. ...
- Modified
- 2 Jun at 08:47
Best method to store Enum in Database
Best method to store Enum in Database What is the best method of storing an Enum in a Database using C# And Visual Studio and MySQL Data Connector. I am going to be creating a new project with over 10...
- Modified
- 15 Apr at 15:8
Is the usage of stored procedures a bad practice?
Is the usage of stored procedures a bad practice? We have an application that is written in C# that is connected to a ms sql server. We use to make a stored procedure for every database call, but then...
- Modified
- 19 Nov at 09:28
Which embedded database to use in a Delphi application?
Which embedded database to use in a Delphi application? I am creating a desktop app in Delphi and plan to use an embedded database. I've started the project using SQlite3 with the DISQLite3 library. I...
- Modified
- 18 Nov at 19:12
How to change default database in SQL Server without using MS SQL Server Management Studio?
How to change default database in SQL Server without using MS SQL Server Management Studio? I dropped a database from SQL Server, however it turns out that was set to use the dropped database as its d...
- Modified
- 15 Sep at 20:1
Challenge!! Example of a valid 4th normal form relation that can perform 5th normal form decomposition
Challenge!! Example of a valid 4th normal form relation that can perform 5th normal form decomposition According to my professor in Intro. to Database Theory, there are NO examples in existence to sho...
- Modified
- 8 Aug at 12:21
Reset identity seed after deleting records in SQL Server
Reset identity seed after deleting records in SQL Server I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Y...
- Modified
- 14 Jul at 15:48
What does ON [PRIMARY] mean?
What does ON [PRIMARY] mean? I'm creating an SQL setup script and I'm using someone else's script as an example. Here's an example of the script: ``` SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO C...
- Modified
- 4 Dec at 22:48
Describe table structure
Describe table structure Which query will give the table structure with column definitions in SQL?
C# and NoSql databases
C# and NoSql databases Is there any particular NoSQL database suitable for C#? Thank you!
Strings as Primary Keys in MYSQL Database
Strings as Primary Keys in MYSQL Database I am not very familiar with databases and the theories behind how they work. Is it any slower from a performance standpoint (inserting/updating/querying) to u...
- Modified
- 16 Feb at 11:0
performance - single join select vs. multiple simple selects
performance - single join select vs. multiple simple selects What is better as far as performance goes?
- Modified
- 18 Dec at 13:44
How to SELECT in Oracle using a DBLINK located in a different schema?
How to SELECT in Oracle using a DBLINK located in a different schema? We have an Oracle DBMS (11g) and the following configuration: - - - - - : When logged on as "MYUSER", what is the correct syntax t...
- Modified
- 28 Sep at 09:23
Auto Generate Database Diagram MySQL
Auto Generate Database Diagram MySQL I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and t...
- Modified
- 1 Apr at 10:30
Can we update primary key values of a table?
Can we update primary key values of a table? Can we update primary key values of a table?
- Modified
- 4 Oct at 13:23
Firebase Storage How to store and Retrieve images
Firebase Storage How to store and Retrieve images How to store and view images on firebase?
- Modified
- 27 Dec at 12:32
What database does Google use?
What database does Google use? Is it Oracle or MySQL or something they have built themselves?
- Modified
- 2 Sep at 22:52