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
Describe table structure
Describe table structure Which query will give the table structure with column definitions in SQL?
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
C# and NoSql databases
C# and NoSql databases Is there any particular NoSQL database suitable for C#? Thank you!
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
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
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
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
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
What is a Covered Index?
What is a Covered Index? I've just heard the term covered index in some database discussion - what does it mean?