I've heard that innodb Why innodb doesn't store geospatial data? store geospatial data but cannot index it.
Not really sure what it means. Is it a good idea to ask 20 closest businesses if point is stored in innodb?
My current strategy is to create another table in myisam that contains those spacial information. Then if I want to find 20 closest business, I'll just use join.
Is this a good idea?
My company is facing the decision whether to purchase SQL Server 2012 Denali or SQL Server 2008 R2 for a new database server. I am looking for objective reasons to choose one over the other.
Our requirements:
Standard edition (for financial reasons and a lack of need for enterprise features)
O...
With Sql Server 2012 there are 3 flagship editions: Enterprise Edition, Business Intelligence, Standard.
The full comparison between the three: http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx
The business intelligence edition implies that the purpose of it is for ...
I have following query written in HQL for Hibernate.
========================================================================
select new map(ret.retailerDesc as ret_name, ret.id.retailerId as ret_id,
ret.id.serviceId as service_id,
(select count(distinct i.inspectionId) as ins...
Not sure how this can be transformed into HQL but your query could be written as:
SELECT m.id,
(SELECT COUNT(*) FROM SubqueryTable...) > 0
AS b
FROM MyTable AS m;
But perhaps you could use this - which seems to be bypassing the problem as it is using INT columns:
SELECT m.i...
complains that ORDER BY b and ORDER BY 2 result in error.
Considering SqlServer 2008, i have a table that someone update this table every day.
I would like to create a view and instead of update this view manually like the guy does, i would like to make it automatic.
For example, today is 15/jun/2012 and the table is updated, the view must be updated(w...
Although SQL Server provides some support to data structured as XML, it is not a recommended way of storing data -- its nature just don't fit well into RDBMs.
If you need to search on data imputed as XML, I'd suggest to create a trigger on insert/update to get the searchable data and store it in...
Currently the migration path options from SO are:
Meta.SO
Serverfault
SuperUser
Webmasters
Programmers
If we are going to be limited to 5 options, shouldn't we periodically re-evaluate which sites are most appropriate?
Migration stats (10k only) indicate that the top sites for the last 90 da...
The data is being compared from the local version of the table to one in the contracts linked server. I'm not certain what the goal of this code is in the first place, but I'm trying to get a handle on simplifying it a little.
CURSOR c3 IS
SELECT bs.billing_service_id, bs.oser_id
FROM ...
In general I've found that the smarter Oracle people guard their knowledge very well. They don't seem to foster the sharing type of community that other platforms enjoy.
Maybe I'm just being negative (probably), but I don't think Oracle is as much a hobby/passion to professionals as SQL Server is to SQL Server professionals..?
I think the Oracle experts don't want n00bs to get better at their platform. Mostly because when they get better they start cutting into the consulting revenue and bring the price down.
Here's another case where someone assumes SQL Server maintains some magical ordering column for them:
Table : A
Col1 Col2
A 1
B 5
C 3
D 4
E 6
A 1
C 2
I want the result as follows :
Col1 Col2 Col3
A 1 1
B 5 6
C 3 9
D 4 13
E 6 19
A 1 20
C 2 22
Third column (Col3) shoud be the cumulative value of the second column ( Col2).
Please note that ...
@AaronBertrand Psh ... yeah right. Next you're going to tell me that the Internet is not something that you just dump something on. It's not a big truck.
I'm trying to build a cumulative sum over months for the following table ;
created_at Installs port
2011-02-01 00:00:00 2 7033
2012-02-05 00:00:00 8 7032
2012-03-01 00:00:00 1 7031
2012-05-05 00:00:00 2 8500
2012-06-01 00:00:00 4 754...
Considering SqlServer 2008, i have a table that someone update this table every day.
I would like to create a view and instead of update this view manually like the guy does, i would like to make it automatic.
For example, today is 15/jun/2012 and the table is updated, the view must be updated(w...
@ypercube I had already added something about "natural" sort to the canonical questions list, but a definitive treatise on this needs to be written since there is no answer for it yet.
Maybe I'm over complecating this, or not.
I just need a "simple" query to select one column but return only distinct rows.
Here's the key, they need to be ruled out if they are similar, not just match exactly.
For example, here's my current query
select distinct channel from audio_srcs orde...
This looks like a search for a valuable asset, but since we have a free alternative for many things, I am optimistic about this one.
A database which stores two key-value pairs like
key-value
or
key-context-value
would be very useful for web developers who collect data and want to tag them.
...
I have other queries working with the same connectionstring; the server is returning data on those calls.
some settings:
Connection.ConnectionTimeout = 3600 (in debugger)
DB timeout is set to 0
<add
name="StuffEntities"
connectionString="metadata=res://*/DataModel.Stuff.csdl|res://*/Da...
I have a table part with a few demo data as below in Oracle DB:
ID NUMBER DESCRIPTION
1 T00001 test
2 T00002 test
3 T00003 test
4 T00004 test
5 T00008 test
6 SG0001 test
7 SG0002 test
8 SG0003 test
9 SG0004 test
10 ...
I have wrote this cursor for commission report. What happens is commission comes in one table, the records are another table. I match two based on certain critera (there is not exact match available). The problem is there are duplicates where records exist. When I match commission with the record...
i would like to know whether the following query is optimized?
with cte_biggie (paid_amt,copay_amt,co_ins_amt,payor_group,load_month,load_year) as(
select
SUM(payments.paid_amt),
SUM(payments.copay_amt),
SUM(payments.CO_INSURANCE_AMT),
payor_group.PAYOR_GROUP,
DATEPART(MM,accessi...
Yeah I'm pretty sure I'm correct. Doing a SELECT IS_MEMBER('Domain\Group1') and SELECT IS_MEMBER('Domain\Group2') both return 1 if the member is indeed a member of both
But yeah, I don't think that's the right way to do it. But still works
So, asking to download a MySQL database, and test if my answer is working is a little too much to ask, right?
right now i'm trying to figure it out if it works ... LINK => aplicatii-iphone.ro/img/licenta.rar here is the whole MySQL database dump, it seems it doesn't work, i tried, or am i wrong? — Row Minds5 mins ago
@Shark sorry man, little input there. I've avoided any applications where Windows auth was a requirement (particularly through group membership) precisely because of this issue.
How much longer is the harassment going to continue on this search engine question? Will the idiots not stop until I delete my answer, which clearly they think is 100% incorrect?
Does anybody knows how Google or Yahoo perform searches for keywords against very very huge amounts of data? What sort of database or technologies do they employ for this?
It takes few milliseconds, but they have more than a billion pages indexed.
@swasheck It's backed up. I wish it was dev...it's not "live" to any other users, but it's a table on our prod system. My boss updated 28 million rows and now it's acting...weird. Some queries work fine and some take over 30s, and if I'm not mistaken it's grown from 12.5 GB this morning to 15GB today (it took 6 months to get to the first 12 GB)...
A query I wrote in PHP for a MS SQL database is having an issue where a word is not being recognized as the table name. I'm using MS SQL for PHP 2.0 (VC6). The following query works and returns all orders from the table Order when executed in MS SQL Server Management Studio.
SELECT * FROM "db_na...
@AaronBertrand @AaronBertrand No problem, it's definitely a corner-case and not anywhere near a best practice. My test lab proves my answer, though, so I'm confident with it.
........so many DBA questions on SO today. Flagged a ton, and about 10% only have been migrate......
Nobody's even made the Epic badge yet. Which should tell you how hard it is to hit rep cap in a day.
I've done it 80 times on SO (81 including today).
But I still have the same opinion I've had every other time we've talked about this: pushing people's questions here is going to increase volume, but not by as much as we'd like to think, and it can also alienate people
Everybody will point at stats but alienation isn't something you can measure with a query
@AaronBertrand I seem to make enemies as neatly as friends.
Shame that, people think I'm being highly argumentative when they can't read past the first five words of a post without considering their retaliatory text.
Meek's method of STV is an iterative process that approaches the will of the people asymptotically.
TL;DR Your vote, valued at 1.00 vote, is applied to your candidates in the order you rank them. Each candidate only uses as much of your vote as needed to become elected (shared equitably betwe...
Background
I've got a group table, users table, and a group_members table.
groups { group_ varchar(50) not null, etc... }
users { user_id varchar(50) not null, etc... }
group_members { group_ varchar(50 not null, member varchar(50) not null }
My requirements state that a group can have other...
I have wrote this cursor for commission report. What happens is commission comes in one table, the records are another table. I match two based on certain critera (there is not exact match available). The problem is there are duplicates where records exist. When I match commission with the record...
So the problem that you're facing is that you need to do some work serverside but you want to display that clientside. The first part of the problem is that HTTP is a stateless connectionless protocol, so you have to keep asking the server for more information (updates).
So what you need are sev...
Now I have a long query and I'd like to alternate with such a statement
where userid=@userid
But I have other parameters which change flow, so, I want to have two options, selecting one user or any user
Can I send a username so that It can select and user? like we do in LIKE statements, we se...
@AaronBertrand nope. I don't know why he included that, and I really didn't look at any of his code. I also didn't tell him how to initiate these methods. I'm literally giving him just the code he needs to solve this particular portion of the problem
Please use MS-SQL syntax if you can
Suppose I have a record with a comma delimited strings in a column name "Version"
Say we have a record (A) containing having these values in its "Version" column
Version=10.1.2, 10.4.3,11.6.0, (the column has comma delimited strings)
I am passing an sql ...
This is an issue I come up against periodically and have not yet found a good solution for.
Supposing the following table structure
CREATE TABLE T
(
A INT PRIMARY KEY,
B CHAR(1000) NULL,
C CHAR(1000) NULL
)
and the requirement is to determine whether either of the nullable columns actually c...
My company is facing the decision whether to purchase SQL Server 2012 Denali or SQL Server 2008 R2 for a new database server. I am looking for objective reasons to choose one over the other.
Our requirements:
Standard edition (for financial reasons and a lack of need for enterprise features)
O...
With Sql Server 2012 there are 3 flagship editions: Enterprise Edition, Business Intelligence, Standard.
The full comparison between the three: http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx
The business intelligence edition implies that the purpose of it is for ...
I have following query written in HQL for Hibernate.
========================================================================
select new map(ret.retailerDesc as ret_name, ret.id.retailerId as ret_id,
ret.id.serviceId as service_id,
(select count(distinct i.inspectionId) as ins...
Not sure how this can be transformed into HQL but your query could be written as:
SELECT m.id,
(SELECT COUNT(*) FROM SubqueryTable...) > 0
AS b
FROM MyTable AS m;
But perhaps you could use this - which seems to be bypassing the problem as it is using INT columns:
SELECT m.i...
Currently the migration path options from SO are:
Meta.SO
Serverfault
SuperUser
Webmasters
Programmers
If we are going to be limited to 5 options, shouldn't we periodically re-evaluate which sites are most appropriate?
Migration stats (10k only) indicate that the top sites for the last 90 da...
The data is being compared from the local version of the table to one in the contracts linked server. I'm not certain what the goal of this code is in the first place, but I'm trying to get a handle on simplifying it a little.
CURSOR c3 IS
SELECT bs.billing_service_id, bs.oser_id
FROM ...
Table : A
Col1 Col2
A 1
B 5
C 3
D 4
E 6
A 1
C 2
I want the result as follows :
Col1 Col2 Col3
A 1 1
B 5 6
C 3 9
D 4 13
E 6 19
A 1 20
C 2 22
Third column (Col3) shoud be the cumulative value of the second column ( Col2).
Please note that ...
I'm trying to build a cumulative sum over months for the following table ;
created_at Installs port
2011-02-01 00:00:00 2 7033
2012-02-05 00:00:00 8 7032
2012-03-01 00:00:00 1 7031
2012-05-05 00:00:00 2 8500
2012-06-01 00:00:00 4 754...
Maybe I'm over complecating this, or not.
I just need a "simple" query to select one column but return only distinct rows.
Here's the key, they need to be ruled out if they are similar, not just match exactly.
For example, here's my current query
select distinct channel from audio_srcs orde...
This looks like a search for a valuable asset, but since we have a free alternative for many things, I am optimistic about this one.
A database which stores two key-value pairs like
key-value
or
key-context-value
would be very useful for web developers who collect data and want to tag them.
...
I have other queries working with the same connectionstring; the server is returning data on those calls.
some settings:
Connection.ConnectionTimeout = 3600 (in debugger)
DB timeout is set to 0
<add
name="StuffEntities"
connectionString="metadata=res://*/DataModel.Stuff.csdl|res://*/Da...
I have a table part with a few demo data as below in Oracle DB:
ID NUMBER DESCRIPTION
1 T00001 test
2 T00002 test
3 T00003 test
4 T00004 test
5 T00008 test
6 SG0001 test
7 SG0002 test
8 SG0003 test
9 SG0004 test
10 ...
i would like to know whether the following query is optimized?
with cte_biggie (paid_amt,copay_amt,co_ins_amt,payor_group,load_month,load_year) as(
select
SUM(payments.paid_amt),
SUM(payments.copay_amt),
SUM(payments.CO_INSURANCE_AMT),
payor_group.PAYOR_GROUP,
DATEPART(MM,accessi...
Does anybody knows how Google or Yahoo perform searches for keywords against very very huge amounts of data? What sort of database or technologies do they employ for this?
It takes few milliseconds, but they have more than a billion pages indexed.
Meek's method of STV is an iterative process that approaches the will of the people asymptotically.
TL;DR Your vote, valued at 1.00 vote, is applied to your candidates in the order you rank them. Each candidate only uses as much of your vote as needed to become elected (shared equitably betwe...
Background
I've got a group table, users table, and a group_members table.
groups { group_ varchar(50) not null, etc... }
users { user_id varchar(50) not null, etc... }
group_members { group_ varchar(50 not null, member varchar(50) not null }
My requirements state that a group can have other...
Please use MS-SQL syntax if you can
Suppose I have a record with a comma delimited strings in a column name "Version"
Say we have a record (A) containing having these values in its "Version" column
Version=10.1.2, 10.4.3,11.6.0, (the column has comma delimited strings)
I am passing an sql ...
This is an issue I come up against periodically and have not yet found a good solution for.
Supposing the following table structure
CREATE TABLE T
(
A INT PRIMARY KEY,
B CHAR(1000) NULL,
C CHAR(1000) NULL
)
and the requirement is to determine whether either of the nullable columns actually c...
