« first day (13 days earlier)      last day (1561 days later) » 

7:10 AM
1
Q: MS SQL Server 2012 Express - install service pack 3

PrzemekIs it possible to install service pack 3 to an existing instance of MS SQL Server 2012 Express? The only install files I found are: MS SQL Server 2012 and Service Pack 3 for MS SQL Server 2012 not Express.

 
 
3 hours later…
10:30 AM
2 messages moved from DROP QUESTION queue;
2 messages moved from DROP QUESTION queue;
 
 
7 hours later…
5:05 PM
0
Q: Script to query MongoDB with PHP

davidWith Code Igniter and MySQL I do: $this->database->query('select * from table'); But I don't know how to use MongoDB. Can I still use this the same way to query MongoDB? $this->database->query('here')

this needs to be re-opened so that this can be deleted. The two questions were linked as dupes, although it looks like the first question has a great answer and lots of views whereas the dupe target has low views, no answers, and is not helpful.
0
Q: Efficient way to Add NON-CLUSTERED Index?

user960567I have the following table, CREATE TABLE [dbo].[Products]( [ID] [int] IDENTITY(1,1) NOT NULL, [RetailerID] [int] NOT NULL, [Name] [nvarchar](255) NOT NULL, [Price] [float] NULL, [Rating] [float] NULL, [CreatorID] [int] NOT NULL, [CreationDate] [datetime] NOT NULL, ...

 
 
3 hours later…
8:06 PM
1
Q: How to distribute a given database between multiple DBMS on a LAN?

SkyDoomGiven a Database D, i need to distribute it over different DBMS in a LAN. D will be split into tables, and each DBMS will store a given table. Here is a sketch of what i need to do : I also need to query this "cluster" in a transparent way : if Client1 queries the MySQL DB for Table2, he shoul...

0
Q: Cannot read property Collation.This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo)

joeyI am new to databases and Microsoft SQL. I just installed SSMS today and am getting this error while trying to add new login in security or rightclick-> view properties on user logins already there under security. Same error happens if I try to make a new database. I have SQL server 2008 and 20...

1
Q: Querying for reputation of the commenter and its addressee using SEDE

user2256866How can I modify this Data Explorer query for the case when user of the comment is same as the poster, then the query should look for the tagged user in the comment and print the tagged user reputation along with the reputation of the commenter or the poster of the question. SELECT CASE WHEN ...

^^^ cross posted on so
0
Q: Best database for fast read all in one table

Yusuf AliI currently have a large database in SQLite that I was using for rapid-prototyping for a software I am working on. Now that I am planning to move it to another database that should give better performance (I'm expecting well over 4M rows), I am looking for a databasing solution given the followin...

 
8:26 PM
3
Q: Is PostgreSQL or ElasticSearch/Solr the right tool for this kind of query?

geekoHere is an example of the current PostgreSQL query: SELECT a.*, a.al_location <-> '(someLon, someLat)' AS d FROM al_app.al_activity AS a WHERE to_tsvector('simple', a.al_keywords) @@ to_tsquery('simple', 'someKeyword') ORDER BY d OFFSET 1000 LIMIT 50; Basically it is against a table defined...

 
9:03 PM
4
Q: Postgresql JDBC Table Valued Parameters

OrrMSSQL has a great feature called Table Valued Parameters. It allows you to pass a table of a custom data to stored procedures and functions. I was wondering what is the equivalent in PostgreSQL, if one exists, using JDBC? I know about the option of passing arrays as function parameters, but that...

^^^ dupe on so
 
9:13 PM
1
Q: Sql Server 2012 Enterprise Backup with no file

felbusWe currently have a database which increments 5TB a day. The current backup solution we have uses Avamar, which I believe does a kind of block comparison backup where there is no need for an actual backup file. We wish to switch our backup to store it in AWS. We have a fast connection to AWS fr...

0
Q: Why does Oracle trim passwords?

stuXnetWhile looking over the settings of an application, I saw a 'typo' in the password for the database connection - it was like password='secret ', but the connection worked fine anyway. I tried the same with my configured connections in Oracle SQL Developer - putting blanks either in the beginning ...

 

« first day (13 days earlier)      last day (1561 days later) »