Well whatever app is expecting to use these tables is not going to be easy to switch - I honestly have no idea how you're going to store varray data or how the app or its interfaces will have to change to deal with it... — Aaron Bertrand1 min ago
I have created an application that use a sql server database.
But the problem is that a user can open sql server management studio and can do anything that I don't like , for example :
1) Can modify values inside tables.
2) can delete records
3) Can see and can get my database structure.....
...
my question was a problem with a query for TWO different servers MSSQL 2000 and H2. I did not find a bug because its already known! i did never say that my question is SQL standard nor that it is perfect. it was the query that was used on mssql2000. i removed the last query as you requested MY ANSWER/ Solution, which is finally different to what i wrote before. i do not know what you mean by 'flaws' in my question. but actually i do not longer want to know it as you seem to search for someone to flame. so leave it that way. — lumo49 mins ago
@ypercube It says here H2 did have issues with outer joins, only it was with right outer joins, not left, and it was prior to version 1.3.
I wonder, maybe the OP had heard something ("H2 has issues with outer joins") and misapplied that to their case when they failed to reconcile the SQL Server syntax with H2.
Yes, seeing his latest so question. He frustrated Aaron.
Oh my gosh, then do it with two operations. What is this question really about? Bypassing permissions? What does "only allowed" mean? Is mommy validating your queries? — Aaron Bertrandyesterday
How very appropriate! Not only the question turned out to be a duplicate of the linked one, but also your answer looks almost like an exact copy of the accepted answer to the linked question. You even used same variable names and formatting, just amazing! — Andriy M11 secs ago
Problem
Having trouble finding a Key-Value store that is tolerant of writes and deletes.
Details
Need a good key-value store to use for storing very large hash tables. These hash tables are used as indexes and are very "active". Very many deletes and writes are executed against them.
Currentl...
I think you've been a user long enough to recognize that you should make an effort first before asking for help. Please update your question with what you've tried. It would also be helpful if you provided an example of the desired result. — Kermit1 min ago
i'm also so mean
You need to normalize the table. Whoever designed this is a moron. — Kermit1 min ago
I am using a query where I am using distinct in it, to get the unique rows. But I want to avoid using distinct in my query, little confused in how to do that can anyone help me out. Here is the query:
SELECT DISTINCT pp.PLCY_NO,
pp.PLCY_PRD_END_DT,
Rtrim((SELECT...
@AaronBertrand nice article. Hopefully that gets high in the Google results! I see a very slight spelling mistake: "Still, it is a good think to be conscious of this issue" should be "Still, it is a good thing to be conscious of this issue"
@AaronBertrand This I wasn't aware of at all: "RCSI can't use efficient allocation order scans; you will see range scans instead." That could have a pretty negative effect for some workloads!
Our business case was that I had to shorten a hierarchy. "True" hierarchy was Grunt reports to supervisor, supervisor to manager, manager to VP, VP to P. "Actual" was Grunt to Manager because the supervisor was not filled
Is anybody using HierarchyId in real production with tables of reasonable size, more than a few thousand rows? Is it reliable/performant? So far I have not found anyone not affiliated with the vendor recommend it, and Paul Nielsen advises against it here.
What is your experience with using Hiera...
Here's where you can find the full details and application. But if you hate clicking:
Requirements
If you're fluent in Spanish and you're reading this, you likely have at least 75% of the things we're looking for for this role:
Fluency in English and Spanish (native-level writing in Spanish)...
@billinkc why i need to edit my question. its clear and got reply from users mhn, thomas harathy. please let me know which part is not clear and then i will explain you clearly. — SQLMike1 min ago
I won't comment here about the Spanish community manager job.
I'm commenting here about the crazy idea you had to create a Stack Overflow website for 10 different languages. That's the stupidest idea I've ever seen on meta.
I'm French, I always speak French, everyone at my job speaks French, bu...
@Lamak so was the request for mentors. It's MSO people get pissy with anything. The issue isn't just the site, it's the fact that SE is using MSO to asks for things
@Lamak I think you'd be great for it. When you've interacted on MSO/MSE you always are on-point with your comments and you're willing to listen to others. That's a big thing
If Lomuk applies for the position, I will need to invest in some Chilean alcohol producers. You will start after being subjected to that all day long :D
If it were clear, they would have provided answers. Instead, we have comments. Your question was put on hold and marked as a duplicate because it is not clear. The SSIS tag is mine. I love SSIS, do it all day long and I'm telling you, I don't understand what you are attempting to do. — billinkc7 mins ago
Vertica does not enforce uniqueness of primary key or unique constraints on load due to the potential overhead associated with the operation.
If ANALYZE_CONSTRAINTS() is run before committing, you should be able to capture potential duplicates. There's also overhead with doing UPDATEs and those...
I understand the resistance of SO in other languages, and I also think it's really important to learn english.....that said, this kind of comments still pisses me off
Fragmenting the sites into multiple languages is the worst possible idea that ever happened to SO ever. It only creates borders and kills the global community spirit. Most likely localized sites will attract lazy people who can't bother to learn English, and if you can't learn English as a programmer, then with all due respect I don't know what you're doing in this industry in the first place. — Bartek Banachewicz4 mins ago
I just don't get the logic from some of those users
@TimPost "the people we're looking to serve" served by whom? Because whoever will serve them won't be serving me and all the others able to at least read English. I resent that. — VonC17 mins ago
Fragmenting the sites into multiple languages is the worst possible idea that ever happened to SO ever. It only creates borders and kills the global community spirit. Most likely localized sites will attract lazy people who can't bother to learn English, and if you can't learn English as a programmer, then with all due respect I don't know what you're doing in this industry in the first place. — Bartek Banachewicz4 mins ago
Fragmenting the sites into multiple languages is the worst possible idea that ever happened to SO ever. It only creates borders and kills the global community spirit. Most likely localized sites will attract lazy people who can't bother to learn English, and if you can't learn English as a programmer, then with all due respect I don't know what you're doing in this industry in the first place. — Bartek Banachewicz4 mins ago
Fragmenting the sites into multiple languages is the worst possible idea that ever happened to SO ever. It only creates borders and kills the global community spirit. Most likely localized sites will attract lazy people who can't bother to learn English, and if you can't learn English as a programmer, then with all due respect I don't know what you're doing in this industry in the first place. — Bartek Banachewicz4 mins ago
Fragmenting the sites into multiple languages is the worst possible idea that ever happened to SO ever. It only creates borders and kills the global community spirit. Most likely localized sites will attract lazy people who can't bother to learn English, and if you can't learn English as a programmer, then with all due respect I don't know what you're doing in this industry in the first place. — Bartek Banachewicz4 mins ago
I think that this is a good argument:
@BartekBanachewicz The notion that the existence of SO in other language is fragmenting the community is totally false. The "global programming community" is already fragmented because not everyone is comfortable asking and answering questions in English. If it feels united to you, it's because you are privileged to be proficient in English and are part of the community. Silence from non-English speakers does not equal the nonexistence of non-English-speaking programmers. — Laura ♦2 mins ago
@lamak Way I heard it, she was traumatized after they locked braces and spent the next 30 minutes trying to separate. She then went and joined a lesbian revolutionary group in El Salvador.
Thanks. Join me on Saturday for my speech at the airport Hilton, "You're gonna die alone anyway, so why are you so worried about failure?" - only $20, bad coffee provided
I'm running the Create script right after my full backup restore, so I get 24 and then I select everything from Sys.Foreign_Keys that gives me all my current FKs of 34, which tells me that the Create script is truncating the rest of them as the last Alter statement (24th) in the output of the Create script is missing the name of the Foreign key that its referencing, so I manually type the rest of it when I paste it into my query editor window, so it seems I have to see which ones are also missing to total it to 34 Alter Add statements for each drop. — Shayma Ahmad4 mins ago
> Ich bin mit der Erstellung Skript direkt nach meiner vollen Backup wiederherzustellen, so dass ich 24 und dann ich alles von sys.foreign_keys, die mir alle meine aktuellen FKs von 34, die mir sagt, dass das Skript erstellen Abschneiden der Rest von ihnen als letzte Anweisung ALTER (24.) in der Ausgabe des Skripts erstellen den Namen der Fremdschlüssel,
> der seine Referenzierung fehlt, so dass ich den Rest von ihm manuell eingeben, wenn ich einfach in meiner Abfrage-Editor-Fenster, so dass es scheint, ich habe zu sehen, welche ebenfalls fehlt, um es zu insgesamt 34 Aussagen hinzufügen Alter für jeden Tropfen.
or
> Τρέχω το σενάριο αμέσως μετά την πλήρη αποκατάσταση της δημιουργίας αντιγράφων ασφαλείας μου Δημιουργία, ώστε να πάρω 24 και στη συνέχεια θα επιλέξετε τα πάντα, από Sys.Foreign_Keys που μου δίνει όλες τις τρέχουσες FKS μου 34, το οποίο μου λέει ότι το σενάριο Δημιουργήστε το περικόπτοντας τους υπόλοιπους όπως την τελευταία δήλωση Alter (24) στην έξοδο του σεναρίου Δημιουργήστε λείπει το όνομα του Εξωτερικού κλειδί που παραπομπών του,
> γι 'αυτό πληκτρολογήσετε τον υπόλοιπο αυτό όταν το επικολλήσετε στο παράθυρο του editor ερώτημα μου, έτσι φαίνεται έχω για να διαπιστωθεί ποιοι από αυτούς λείπουν επίσης να ανέρχονται σε 34 Alter Προσθήκη δηλώσεις για κάθε πτώση.
@AaronBertrand i think it's a fairly easy mistake to make, once. but learn from it and move on. also, don't argue with people who know what they're talking about
There is no way anyone can make recommendations based solely on statistics I/O output. Could you show the query, and maybe an actual post-execution plan (post the XML somewhere, don't take a screen shot of it)? — Aaron Bertrand ♦12 secs ago
@TheLostMind That kind of throws the idea for SO to be a unified knowledge bank for programming/coding questions aside. If I have a problem regarding X, and there is an answer in <insert foreign language here> and not in English, SO wouldn't carry the same fairness that it does now. — OverMind11 mins ago
I'm really asking because I commented about the "fairness" thing, but got this reply:
@Lamak I applaud your brain's ability to formulate what I said into "OVerMind said it's not fair if an answer is in another language!". Looking at my comment logically and abstractly, I am saying if I have a question, and there's a thread on SO regarding it, but the answer isn't in English, how is that benefitting the general public, when code is in English? What language is documentation written in? What if there's a link on a foreign language SO site that points to English documentation because none exists in that language? Is that fair? Or the way the the world is? — OverMind6 mins ago
Ok the plan is 45 MB (!) and your chosen download service is throttled and very slow. So right now my browser estimates I will have the plan fully downloaded in about a half hour (and I have 90Mbps down). So, I'll revisit later unless you feel like putting it somewhere more useful, like OneDrive, GoogleDrive, DropBox, etc. — Aaron Bertrand ♦8 secs ago
There is no way anyone can make recommendations based solely on statistics I/O output. Could you show the query, and maybe an actual post-execution plan (post the XML somewhere, don't take a screen shot of it)? — Aaron Bertrand ♦19 mins ago
I had it on my GS3 and now my MotoX and it's awesome. The best speed I've gotten was 63 down 30 up and it's always consistently faster on my phone than my home PC.
The missing output clause would go right here:
SELECT ID
FROM T1
CROSS APPLY
(
INSERT INTO FINAL(TEXT1, TEXT2, TEXT3)
-- here vvv
OUTPUT ...
-- here ^^^
SELECT T2.TEXT1, T2.TEXT2, T3.TEXT3
FROM T2,
T3
WHERE T2.VALUE = T3.VALUE
AND T2.ID ...
That's what I was doing exactly as I understood it by copying whatever the script is printing out and pasting it! Isn't that what the script is all doing? Thanks for posting the link above, I will try validating and check the long strings with your solution. — Shayma Ahmad3 mins ago
I have created an application that use a sql server database.
But the problem is that a user can open sql server management studio and can do anything that I don't like , for example :
1) Can modify values inside tables.
2) can delete records
3) Can see and can get my database structure.....
...
Problem
Having trouble finding a Key-Value store that is tolerant of writes and deletes.
Details
Need a good key-value store to use for storing very large hash tables. These hash tables are used as indexes and are very "active". Very many deletes and writes are executed against them.
Currentl...
I am using a query where I am using distinct in it, to get the unique rows. But I want to avoid using distinct in my query, little confused in how to do that can anyone help me out. Here is the query:
SELECT DISTINCT pp.PLCY_NO,
pp.PLCY_PRD_END_DT,
Rtrim((SELECT...
Here's where you can find the full details and application. But if you hate clicking:
Requirements
If you're fluent in Spanish and you're reading this, you likely have at least 75% of the things we're looking for for this role:
Fluency in English and Spanish (native-level writing in Spanish)...
Vertica does not enforce uniqueness of primary key or unique constraints on load due to the potential overhead associated with the operation.
If ANALYZE_CONSTRAINTS() is run before committing, you should be able to capture potential duplicates. There's also overhead with doing UPDATEs and those...
The missing output clause would go right here:
SELECT ID
FROM T1
CROSS APPLY
(
INSERT INTO FINAL(TEXT1, TEXT2, TEXT3)
-- here vvv
OUTPUT ...
-- here ^^^
SELECT T2.TEXT1, T2.TEXT2, T3.TEXT3
FROM T2,
T3
WHERE T2.VALUE = T3.VALUE
AND T2.ID ...
