Questions tagged [database-engine]
57 questions
0
votes
0 answers
sql 2012 engine not making sense?
Thanks in advance guys, quick inquiry below:
I have a query, hitting a 10 columns- 14,000,000 row table with a clustered index on Id, and a non-clustered index on f_date.
I also do 2 left joins to really small tables… and I have a where…
Chicago1988
- 970
- 3
- 14
- 35
0
votes
1 answer
Database Engine not appearing in SQL Server listing
I don't know if I'm searching for the wrong queries in google but I can't seem to find an answer to this. I have SQL Server 2008 installed in my pc and according to services.msc, I've got 2 database engines running: SQLEXPRESS (probably one that…
Jonn
- 4,599
- 9
- 48
- 68
0
votes
2 answers
Unable to insert data into MS Access database from Visual C#
just a beginner in Programing ...
I use a class to handle the connectionstring .
public class DataBase
{
public OleDbConnection con = new OleDbConnection();
public OleDbCommand cmd = new OleDbCommand();
public void…
Marvin De Leon
- 39
- 7
0
votes
1 answer
SQL Server SQL Agent
I'm looking to schedule some scripts from my SQL Server 2012 installation. I have installed the SQLManagementStudio_x64_ENU.exe from http://www.microsoft.com/en-us/download/details.aspx?id=43351, since that is the full version, not express. It…
Jeff Harding
- 1
- 3
0
votes
3 answers
How to check if a DataBase exist or not after the connection is made JAVA
I have a big question...
I have a database java program creation.
I want to know if the database exists or not, and the if exists just connect, if not to create it.
I tried this one:
if (dbName.exists() == false) {}
THIS IS ALL THE CODE...…
SanRyu
- 210
- 1
- 2
- 13
0
votes
0 answers
Getting all SQL query plans in SQL Server 2008
I have tried to get the estimated execution plan in SQL Server Management Studio 2008.
As far as I know the it always returns the best query plan, as an execution plan. Right now I'm working on a research and I need to get all possible query plans…
diba6122
- 31
- 1
- 7
0
votes
1 answer
How to force table select to go over blocks
How can I make Sybase's database engine return an unsorted list of records in non-numeric order?
~~~
I have an issue where I need to reproduce an error in the application where I select from a table where the ID is generated in sequence, but the ID…
glasnt
- 2,865
- 5
- 35
- 55
0
votes
2 answers
Issue with Multiple/Distributed hibernate SessionFactory instances with MySQL
I am having an issue while accessing single database instance using multiple/distributed Hibernate SessionFactories i.e. multiple instances of Hibernate SessionFactory.
If I use one session factory to perform insert operation and create new…
Ajay Bhojak
- 1,161
- 9
- 17
-1
votes
2 answers
WordPress database error occur when installing wordpress
enter image description here
This is a problem has occurred when I installing WordPress
Ashik Mahmud
- 7
- 1
-1
votes
1 answer
Database engine functionality
I am working in a project at school (university) and we have to write a simple "DB Enngine" but I am not sure what this exactly means. I have read several definitions and what I understand is that we have to implement the functionality to create…
JORGE
- 167
- 1
- 3
- 12
-2
votes
1 answer
Why can't database engines use an auto column datatype?
When defining table in database, we set column types as int / varchar etc etc.
Why can't it set to auto?
The database would recognize from the input and set the type itself, much like php handles variables. Also, youtube wouldn't have to crash their…
cowboysaif
- 241
- 2
- 9
-3
votes
3 answers
database that allows to read and write from mutable array by index
I'm looking for a database that allows me to store and retrive strings by an index. It should work just like a mutableArray but on disk. The database entries have a fixed length, the number of entries grows over time, up to about 100'000'000.
It…
Thomas Bader
- 48
- 1
- 5