|
What is the difference between graph-based databases ( http://neo4j.org/ ) and object-oriented databases ( http://www.db4o.com/ )?
Started by Gili on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
With Object-oriented databases, you have answer this differently: object and graph....
With graph databases, you have a slight semblance of a chance that it is based on mathematical graph theory.
Was asked in the comments to this blogpost.
|
|
I am retrieving the database list by executing the sp_databases stored proc. Is there any way I can exclude system databases from this list? I do not want to use the query SELECT name FROM dbo.sysdatabases where dbid > 6.
Thanks
Started by Jay on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The only thing you can do is use the INSERT EXEC pattern to insert table #t (db_name varchar(255), db_size int, remarks text) insert #t exec sp_databases select/instance & I have to list the databases....
Sp_databases takes no params.
|
|
We would like to implement an application architecture in which we have large numbers of databases on the disk, one database file for each customer.
When a user request comes in the database is opened (if it isn't already).
After a certain period of time...
Started by Simon Wentley on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
That multiple databases or schema are a logical artifact within the system databases, lower the memory....
This is a problem, as I don't think the modern databases really make the kind of distinctions that you're talking about internally.
|
Ask your Facebook Friends
|
I am trying to find the best area to download SQL tables of common subjects like states, countries, zip codes. Maybe even public/government information like FDA or FCC information. Does such a resource exist and is it mature?
Started by Maximilian Morresi on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Geonames.org is a pretty good source of such data.
It's available directly from the ISO board in PDF, but can be found online elsewhere .
For states/provinces and countries, I'd recommend ISO 3166.
|
|
The sp_databases stored proc in sqlserver returns a remarks column. Where does this information come from, and can I edit it?
Started by Jeremy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Simply run sp_helptext sp_databases and you'll see:
REMARKS = convert(varchar(254),null)
It's a brand.
|
|
I have 2 databases. Users database and purchases database. Each database has different user and password.
If i want to execute a query to call both databases. How do I connect the databases?
$db = mysql_select_db( );
Started by mysqllearner on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If you have a user, which has permission to select from both databases, it should be possible by
SELECT * FROM db1.table.
The permission, you will not be able to do a statement which connects 2 databases.
|
|
Trying to do a test with development virtuals and need to move the databases to a dedicated DB server (they are currently located on the development virtuals).
As part of the move I need to rename the databases.
Is there an easy way to rename the SharePoint...
Started by JD on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
If you do want to rename the databases on a non-production system (knowing that you may not be able to get support is how to move the databases....
To go mucking about with the SharePoint databases, especially on a production system.
|
|
How do I list all the databases for a given sql server 08 instance using sqlcmd?
Started by TheDeeno on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Sqlcmd -E -S SERVER\INSTANCE -Q "sp_databases"
EXEC sp_databases
or
SELECT NAME FROM sys.sysdatabases
or
EXEC sp_msForEachDB 'PRINT ''?''';
You can use sp_databases stored procedure..
|
|
If I add 3-400 databases to a single MSSQL server instance will I encounter scaling issues introduced by the large number of databases.
Started by David Collie on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It will more or less be what you are doing with the databases which.
What is the concurrency against those databases? Are you generating databases when you could have of database per installation.
|
|
I've bought a CSV United States business database with ~20 million records, which is divided to 51 databases, every database represents a state.
I need to write an ASP.NET MVC Web Application that will query this database, by state and more arguments....
Started by Alon on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
As long as the table is correctly indexed it will offer better performance when querying as instead of having to scan each file ... .
I would import the data into one big database.
20 million records is peanuts.
One table, with appropriate indexes.
|
