@Marian No wonder if he gets +5-1 in this question and Gordon's (which provides a useful index suggestion) gets only +1 (and a downvote): stackoverflow.com/questions/16610647/…
In SQL Server, an explicit foreign key can help the optimizer make better decisions. But it really only helps if there are supported indexes on both sides. No idea what wonkyMySQL does though.
wonky(TM) creates an index when an FK is created (if there isn't already one), so the FK is enforced. But in the specific query, compound index is more efficient. And simply stating that FKs improve performance, is misleading. They may do but only because of the indexes dded.
I'm using DB2 which apparently doesn't let you use the GROUP BY clause when it's returning more than one column. I have records that have repeating values for ID and name, for example:
EmpID | - name - | code
___________________________________
111111 | Williams | 1
--------...
The answer is correct technically, but also technically it's a duplicate. It doesn't bring anything new/better than the other answer. — Marian1 min ago
@ypercube well I said that before I realized the dv on JW's answer was you. Initially it looked like both answers got one down-vote, which without other information smells like payback.
Today I discovered management at a certain offshore company are trying to use cyclomatic complexity on a T-SQL code base. I suggested the developer ask management to find some examples of real projects where they have measured a T-SQL code base with an average v of 10.
@ypercube It's a software metric based on the number of different execution paths in a code module. Works fine for procedural code in its way. You can use it to do things like estimate the number of test cases needed for a code base.
If you try to express the logic of even a fairly small SQL statement as if it was procedural you get to quite large values quickly. My developer is being told his average cyclomatic complexity should be 10 by somebody who is used to doing this sort of thing on .net or Java code.
The usual fixes for high complexity metrics are - of course - to break the code down into more granular functions. On SQL ... what could possibly go wrong?
Oh well. The @COTW theory of contracting still stands. If you have to work with idiots you might as well get paid for it.
A duplicate answer is just noise, this has nothing to do with discrimination. Etiquette suggests that a duplicate or inferior answer, that doesn't add any new information, posted later, should be deleted. Why do you want to keep this redundant noise here? For 4 rep points? — Aaron Bertrand13 secs ago
I'm writing a trigger to store the record count of one table as a column in another to speed up some reporting queries on a large db.
Here's what I've got so far, it works fine on deletes but I also need to it work on inserts. Do I need to use a separate trigger? Also, is the use of the cursor ...
> "posted later, should be deleted" -- I will always remember this. Always. In fact I don't even get reputation here. ohh sounds like am I repwhore as what others told me. And you also mean that this time I'm redundant here since I posted this answer 24 seconds than bluefeet. You are All always right. Anyway I will delete this lazy copy answer. Good night. – JW 웃 23 mins ago
it's not about the money ... it's about the opportunity ... to learn from a team that is more experienced than i am all by myself. more complexity ... more data ...
@swasheck my last job was like that. I just walked into my bosses office and said hey I got a better offer I'll have a resignation letter by the end of the day. Let me know what you need done before I leave and I'll try to make it happen. Then walked out.
Dear [....] I have accepted an offer of a job that offers appreciably better opportunities than I have available to me here. Please take this letter as [...] weeks notice of my resignation.
I wish you the best of luck in finding a good individual who fits well in the team to fill the role.
Dim constr2 As String = ConfigurationManager.ConnectionStrings("baminterchangerConnectionString").ConnectionString
Dim con2 As New SqlConnection(constr2)
Dim cmd2 As SqlCommand = New SqlCommand("UPDATE ([dbo].[imports] INNER JOIN [dbo].[jdsubs] ON [dbo].[imports]....
i was trying another approach and think i got it. how does this look? UPDATE a SET a.AMIPartNumber =b.OEMPartNumber FROM imports as a INNER JOIN jdsubs as b ON a.OEMPartNumber = b.OEMPartNumber INNER JOIN amipartnumbers as c ON b.OEMPartNumber = a.OEMPartNumber — Addie And-Micara Baker3 mins ago
UPDATE: Sorry, but this is not a duplicate question. This is unique. I have the code on next comment working and bringing back the OEMPartNumber. My problem is the OEMSubNumber. AS you can see in the table I cannot match the OEMSubNumber like i did the in sql i got working. I have to match the OE...
@AddieAnd-MicaraBaker you've been pointed to a solution that if read and considered careully will solve your problem. It may not be the exact code that you are running but apply the same concepts and you'll be fine. — Zane1 min ago
I have a web application that gets the shortest distance from a given point to a given array of points.
This works based on a javascript file that gets loaded when user requests the info.
Now, I want to automate this from the database. Every time that a new record arrives, look for the shortest...
It's unfortunate SQL Server can't handle this, though. Martin Cairns stole my thunder (from a future post) showing that SQL Server knows the plans are the same, but still stores separate copies of them because of the differences in the text hash.
Thank you so much guys for your help It works Fine. only problem is repitition of questions and answers that might be the Data Problem. any suggestion? to get the distinct question/Answer based on ID? — user23949184 mins ago
I don't do the source control stuff, and of course I am not a big fan of their monitoring product (not because it's a competitor of sorts but because it's a rare case in their offerings where you barely get what you pay for).
If you're going to fart around building your own that does anything like what they've already QA'd and battle-tested, you're not saving any money.
Arguably the prompt stuff is not necessary, and you aren't going to build your own IntelliSense, but if you would use it to re-format SQL (I would, if I get lots of crappy code from other people!), try to quantify in a particularly nasty day how much time you spend performing that formatting where it would be one or two clicks with a tool.
Well just as a different perspective, we have plenty of customers who pay retail. But beyond the pre-packaged volumes (like 5-packs) which have discounting built in, almost everything > 5 licenses is a custom quote.
I tried to use the GROUP_CONCAT function in sql server 2000 but it returns an error:
"'group_concat' is not a recognized function name"
so i guess there is an other function for group_concat in sql server 2000
can you tell me what it is?
thank you!
I'm on Oracle 11gR2 with a 2 node RAC system. It's shared fiber storage to an EMC Clariion.
Last friday things went bad..fast. All of the sudden processes that normally ran fine for years became very, very slow. I noticed a sudden increase in log_file_sync waits and the LGWR process is listed...
Unfortunately since you are using SQL Server 2000 you cannot use FOR XML PATH to concatenate the values together.
Let's say we have the following sample Data:
CREATE TABLE yourtable ([id] int, [name] varchar(4));
INSERT INTO yourtable ([id], [name])
VALUES (1, 'John'), (1, 'Jim'),
(2, 'Bo...
@swasheck The implications are that you tried to give notice and he brushed you off. I honestly wouldn't invest to much into it. Sounds like my boss at my last job, honestly.
So leave it on his desk/email him today and don't sweat it. Might want to cc HR, just to cover all bases.
Though that's pretty lame that he would completely brush you off like that.
@MikeFal eh. ultimately i dont envy his position and i dont want to over-consider his feelings. however, i am a sucker for wanting people to like me and approve of me.
I'm using DB2 which apparently doesn't let you use the GROUP BY clause when it's returning more than one column. I have records that have repeating values for ID and name, for example:
EmpID | - name - | code
___________________________________
111111 | Williams | 1
--------...
I'm writing a trigger to store the record count of one table as a column in another to speed up some reporting queries on a large db.
Here's what I've got so far, it works fine on deletes but I also need to it work on inserts. Do I need to use a separate trigger? Also, is the use of the cursor ...
I have a web application that gets the shortest distance from a given point to a given array of points.
This works based on a javascript file that gets loaded when user requests the info.
Now, I want to automate this from the database. Every time that a new record arrives, look for the shortest...
The "meta" link has disappeared from the top navigation bar of Stack Overflow all sites in the network...
I'm feeling quite lost at the moment.
I tried to use the GROUP_CONCAT function in sql server 2000 but it returns an error:
"'group_concat' is not a recognized function name"
so i guess there is an other function for group_concat in sql server 2000
can you tell me what it is?
thank you!
I'm on Oracle 11gR2 with a 2 node RAC system. It's shared fiber storage to an EMC Clariion.
Last friday things went bad..fast. All of the sudden processes that normally ran fine for years became very, very slow. I noticed a sudden increase in log_file_sync waits and the LGWR process is listed...
Unfortunately since you are using SQL Server 2000 you cannot use FOR XML PATH to concatenate the values together.
Let's say we have the following sample Data:
CREATE TABLE yourtable ([id] int, [name] varchar(4));
INSERT INTO yourtable ([id], [name])
VALUES (1, 'John'), (1, 'Jim'),
(2, 'Bo...
