@TypoCubeᵀᴹ Deleted. Note deletion requires a mod since merged posts are locked. We keep the stub around for a few hours so everyone can follow what's happened. Once it's reasonably certain everyone involved has a handle on the final state of things, the merged post can be deleted. Flag as Other... to get that done.
@EvanCarroll Also: I'm always on the lookout for good unanswered questions that would benefit from a bounty outside my own area of expertise. Feel free to make the occasional suggestion.
@EvanCarroll What the heck does mtime-row mean? If you're going to create a tag, at least add some usage guidance and maybe a wiki. Before you get 2k privileges, you might consider asking on Database Administrators Meta beforehand to get the community's view on a proposed new tag.
On the FS, we call it mtime there is no name for it in the db but everyone wants it in the db, and it makes as much sense as anything else. en.wikipedia.org/wiki/MAC_times
@AndriyM Thanks, I'll do some testing. I've noticed Rextester is becoming a common resource here in DBA.SE, and it works really well.
@TypoCubeᵀᴹ Do you happen to have a (digital or printed) copy of Codd's Further Normalization of the Data Base Relational Model, by any chance? (nice username, btw)
A lot of questions involve the same thing
PostgreSQL: Auto update updated_at with custom column
Create a trigger on all the last_modified columns in PostgreSQL
how to update column on same row with trigger without recursion?
How to create trigger to update timestamp when record is updated or in...
There are a number of tags in DBA.SE that I don't fully understand, but which are related either to one or the other RDBMS, as they are part of that specific RDBMS or are common DBA l33t 5p3@k.
However, with your suggestion for the new tag mtime-row I guess the only person that would understand ...
@PaulWhite No. I didn't log in the site last night, unless you count a failed attempt to use the app from my old phone. Woke up and the blue hat (or feet, socks, whatever it is) was there!
@MDCCL I don't think so.
@MDCCL Yes, it works fine. It doesn't have SQLite and it needs different delimiters for different DBMS. I miss the SQLfiddle where we could create the tables and scripts and reuse them (with some adjustments) in different systems
@PaulWhite Yeah. I didn't think it needed merge as the answer there was a duplicate as well. Blame me for not mentioning in the flag. I guess the mod (jcolebrand) saw that both qs had answers and decided to merge.
@TypoCubeᵀᴹ Cross-site duplicates are just such a pain, especially when both have answers. It's tough to coordinate perfectly sometimes, and other times things change while one part of the process is already off and running. Huge waste of people's time.
How difficult would it be to detect cross-posts when the relevant questions have identical titles and content, and are posted by the same user? As an example:
Original, posted on SO
Following day, migrated to SO from SF
Also following day, migrated to SO from SU
If this is technically possibl...
This completely looks like a bug to me...
I don't know why it happens, but I can confirm that it happens. This is the simplest found setup that reproduces the problem (in version 9.6.0).
CREATE TABLE users
(
id SERIAL PRIMARY KEY,
email TEXT NOT NULL,
column_that_we_will_drop TEXT
...
Recently i noticed that one of my queries that is running inside of an etl process is very slow running on SQL Server. This query is a select statement and it is filling a fact table. I decided to take it and make the necessary tests and i found that the problem is in the select statement. This s...
@TypoCubeᵀᴹ He's going to write a book explaining the problem instead of just adding the plans
@StavrosKoureas I don't think you need to install the tool on the server, you can probably load a .sqlplan file in it (save as xml) and anonymize that — Tom V34 secs ago
There have been a few cases in which the snaphat was not awarded.
There have also been other cases in which it was awarded incorrectly, on old questions.
What gives?
Is there a better way to clone a user in SQLSERVER than this ? If this said user has access mappings for dozens of databases, then the answers in the question above aren't fast
to save putting conn strings in config files i'm consider running all apps in IIS under a windows account and that windows account would be given SQL permissions to manage a given db that the app sits on ... Do you guys think this is a good idea?
@PaulWhite Both, actually. I wanna share my take on the scenario, and I started putting an answer toghether yesterday, but realized that some points required clarification.
@TypoCubeᵀᴹ Thanks for the libraries link, it's very interesting. Yes, I think I'll eventually buy one of the Data base systems: Courant Computer Science Symposium 6 copies for sale at Amazon.
@TypoCubeᵀᴹ It's not indispensable, but I've seen several references with slightly different wordings of the normal forms (1NF, 2NF and 3NF) all over the web, and I tend to be kinda picky with those things. I wanna have the real Codd's definition, it's mainly a personal liking