« first day (2172 days earlier)      last day (2712 days later) » 

Evan Carroll
Evan Carroll
2:38 AM
DBA.SE has a huge non-voter problem.
 
 
5 hours later…
hot2use
hot2use
7:31 AM
Morning all
 
Andriy M
Andriy M
Good morning
 
Evan Carroll
Evan Carroll
8:02 AM
HALLO
 
Jack Douglas
Jack Douglas
8:36 AM
@EvanCarroll not really, voting is happening enough to sort most answers roughly by quality which is all that matters. Of course it happens much slower here than SO, and that's more pronounced on postgres than SQL Server tags (for example).
 
Evan Carroll
Evan Carroll
bleh kids don't vote on shit, how am I ever going to buy the Blessed Breastplate of Undead Slaying and beat this game?
 
Jack Douglas
Jack Douglas
8:55 AM
with patience? you aren't doing too badly for votes here
the thing that can be annoying is when you get 100+ votes for a simple answer, but hardly any for the one you spent hours on
 
Evan Carroll
Evan Carroll
doing too badly?!
 
Jack Douglas
Jack Douglas
oops, fixed
 
Evan Carroll
Evan Carroll
Yea, I know, but at this rate I'll never have the Blessed Breastplate.
This game sucks.
I hope they fix this in the expansion pack.
 
Andriy M
Andriy M
9:22 AM
@EvanCarroll How do you buy in this game of yours?
 
dezso
dezso
morning
 
Andriy M
Andriy M
Good morning @dezso
 
dezso
dezso
@AndriyM you are so polite
 
Andriy M
Andriy M
Just trying to prevent any unnecessary grumpiness :)
 
dezso
dezso
@AndriyM I am not (yet?) grumpy
 
Andriy M
Andriy M
9:29 AM
@dezso So far it works then :)
 
ypercubeᵀᴹ
ypercubeᵀᴹ
9:53 AM
Where is @Kermit? We have a Vertica, Boom! Bug! question
0
Q: False value of query

user5198335My query return the true values for img and name but not the true position. This's what i except to return : name | position FV17JAN03_3.jpg | 2 FV17JAN03_2.jpg | 3 My query : SELECT product_...

sql vertica
 
dezso
dezso
> its defiantly working
-2
A: grant all privileges of all tables in database to a user

maninder singhgrant unlimited tablespace to user_name its defiantly working

so, did some reviews, one post is defiantly nonsense, the other one is a LMGTFY
 
hot2use
hot2use
10:25 AM
@dezso I downvoted on that one, because it was 100% pure unrelated IMHO.
 
War
War
10:39 AM
Anyone know what this EF migration actually does ... 
    AlterTableAnnotations(
        "dbo.Pages",
        c => new
            {
                Id = c.Int(nullable: false, identity: true),
                ParentId = c.Int(),
                Name = c.String(nullable: false),
                Path = c.String(),
                Layout = c.String(),
                Content = c.String(),
                Script = c.String(),
            },
        annotations: new Dictionary<string, AnnotationValues>
        {
            {
                "DynamicFilter_Page_PagesForUser",
 
dezso
dezso
10:49 AM
destroys your DB?
 
ypercubeᵀᴹ
ypercubeᵀᴹ
11:27 AM
@IlanAizelmanWS: Exactly. In SQL Server that would be really easy using TOP (1) WITH TIES. In MySQL you'll have to use a different approach. We are back to square one. — Andriy M 24 mins ago
@AndriyM and we have an accepted answer with TOP 1 for a question tagged with [mysql] ...
 
Mark Sinkinson
Mark Sinkinson
11:44 AM
@ypercubeᵀᴹ Did you mean to leave a 'The' on its own? dba.stackexchange.com/a/158244/33638
 
dezso
dezso
> you are very confusing
:D
 
Tom V
Tom V
12:04 PM
My fault, I should've VtC when I posted the comment on the question
 
Andriy M
Andriy M
12:27 PM
@ypercubeᵀᴹ I think that's fair. I wanted to post my answer soon but I wanted to have my lunch too. I chose the latter. The OP wanted to have a solution but they probably wanted to get it quickly, so they chose accordingly, I guess.
 
ypercubeᵀᴹ
ypercubeᵀᴹ
12:48 PM
@MarkSinkinson thnx
 
wBob
wBob
I must be in with a chance of winning the "Best Joke featuring two SQL Server Luminaries and a Palindrome" hat, surely?
 
ypercubeᵀᴹ
ypercubeᵀᴹ
1:08 PM
@wBob Luminaries and Palindrome sound like characters from Harry Potter
 
wBob
wBob
1:23 PM
@ypercubeᵀᴹ or spells!
 
ypercubeᵀᴹ
ypercubeᵀᴹ
1:50 PM
yes!
 
 
1 hour later…
Tom V
Tom V
2:51 PM
So we have a plan to solve a performance issue
It includes the terms "Service Oriented", "elastic cloud" and "best of breed". What could possibly go wrong
 
dezso
dezso
@TomV what is not performant enough?
breeding?
I am confused
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV No microservices? Ah, that would be a problem!
 
Lamak
Lamak
@TomV best of breed?
 
Tom V
Tom V
3:07 PM
 
Lamak
Lamak
@TomV yikes
 
Tom V
Tom V
@dezso A process every company finds to be very complex, Invoicing
 
Lamak
Lamak
oh, my:
> Learn daily! Get a new 'techie term' in your in-box every morning
 
Tom V
Tom V
@dezso for reference, generating an invoice for their largest customer takes 8 hours!
They invented an insane logic to determine prices resulting in millions of table scans each taking 150-ish milliseconds
So instead of revising the logic, they decided on moving the same logic to the cloud, rewriting it in another language and calling it over a webservice
 
dezso
dezso
4:14 PM
@TomV beautiful
 
Forrest
Forrest
I'm beginning to think that consultants are secretly powered by schadenfreude
 
swasheck
swasheck
5:14 PM
rep bump from someone awesome. thanks!
@Lamak BUZZWORD BINGO
 
Thomas Ward
Thomas Ward
5:49 PM
Am I allowed to ask questions relating to DB table/structure design here, or should I save that for Code Review or elsewhere?
Got a few nagging things about a few of my tables in my own listserv implementation that I'd like to change, but wanted input first.
 
MDCCL
MDCCL
@ThomasWard Sure, don't forget to add the database-design tag
 
Thomas Ward
Thomas Ward
will do. :)
there's no Rubberducking tag is there? :P
 
dezso
dezso
@ThomasWard well, you could only add it after deleting the question (because you got it while writing up)
 
Thomas Ward
Thomas Ward
true
but that was more or less a joke ;)
 
Thomas Ward
Thomas Ward
6:23 PM
@TomV I've got five already. Muahahahahah
 
ypercubeᵀᴹ
ypercubeᵀᴹ
6:41 PM
Only 3 days till ... Hats !
 
Andriy M
Andriy M
hat is good news
 
James Lupolt
James Lupolt
Does anyone here know?
0
Q: How do I convert between the transaction ID formats in fn_dblog() and sys.dm_tran_database_transactions?

James Lupoltfn_dblog() shows transaction IDs in this format: 0000:00049d43 And sys.dm_tran_database_transactions shows transaction IDs in this format: 9811233 I believe the above examples show the same transaction ID in different formats. Is there a way to convert between the two formats? Or are these...

sql-server transaction-log database-internals
 
Tom V
Tom V
0
Q: ListServ Database: Statistics Table Design Question

Thomas WardI've got a little bit of a design question going on here. I have my own ListServ implementation written in Python, that works with a PostgreSQL database backend for most of the functionality of determining the following: What lists exist on the listserv Who has ever been seen on the listserv W...

postgresql database-design
@JamesLupolt Is [parent transaction id] making sense?
(just guessing)
 
Thomas Ward
Thomas Ward
7:03 PM
@TomV Thanks for linking. I see I got my first upvote here xD
 
Tom V
Tom V
@ThomasWard Mine :)
 
Thomas Ward
Thomas Ward
nice.
I assume it's a clearly defined question? I assume you'd comment if it wasn't, I tried to include as much info as I could that'd be useful without being vague.
 
Tom V
Tom V
@ThomasWard I don't tend to answer design questions, I don't have any formal knowledge and go with my gut feeling, @MDCCL is the design guru around here
If you check some of his answers, prepare to be amazed by the detail, structure and IDEF1X notation
 
Thomas Ward
Thomas Ward
@TomV I more or less was asking if it seemed like a decent question xD
 
Tom V
Tom V
Most of which are underrated (I suppose the tag isn't popular) like this one
3
A: How to model a Letter Transportation business context in a database diagram?

MDCCLAlthough you stated that the database structure you are depicting in your diagram is part of a university project, the objective should be to make it as realistic as possible, so I consider that carrying out an interview (or a series of interviews) with the experts of a correspondence company mig...

2
 
Thomas Ward
Thomas Ward
7:07 PM
I don't doubt there's experts here :)
I know that there's only a handful of Postgres people around here, but the core thing here is design, less so code / SQL-flavor-specific things.
 
Andriy M
Andriy M
@JamesLupolt This seems to be of relevance: blogs.msdn.microsoft.com/vijaybk/2009/04/29/…
 
MDCCL
MDCCL
7:39 PM
@TomV Thank you for the kind words.
@ThomasWard I would add a description of what each of the tables in your question stand for. In my opinion, each table should represent a certain kind of entity, that is, an entity type, and the columns should represent an attribute shared by all the individual instances (the table rows) of such an entity type. In this way, I find it easier to capture the meaning of a certain business domain. But the question is good as it stands.
 
Thomas Ward
Thomas Ward
@MDCCL Thanks. I will do that - though I would have thought the actual table names are pretty clear given that this is a listserv systme.
 
Lamak
Lamak
@ThomasWard you should also stop using diagonal arrows, everyone knows this
 
MDCCL
MDCCL
@ThomasWard Some things may seem obvious, but some people say that the devil lives in the details (or something like that) :)
 
Thomas Ward
Thomas Ward
@MDCCL How's that edit look?
@Lamak Yes, however this is a quick-and-dirty ERD. I have the full diagram done in Visio with nice right-angle arrows. Done by hand. (I don't have Visio on this computer, so fooey)
 
Lamak
Lamak
@ThomasWard ah, everything is good then
 
Thomas Ward
Thomas Ward
7:50 PM
@Lamak Yep. For all intents and purposes, I use the DataGrip ERD as a quick and dirty one, and recreate it for documentation purposes (or as part of an RFP or such) in Visio with proper arrows and such. This one was just quick and dirty, and had the tables too close together for my liking with straight arrows, so I just spaced crap out a little, and don't have any control over the type of arrow in use.
(Noted as such in my question)
 
MDCCL
MDCCL
@ThomasWard Looks nice to me
 
Lamak
Lamak
@ThomasWard I wouldn't change the stats table to have a different column for year, month and day though
maybe a view
 
Thomas Ward
Thomas Ward
@Lamak there's not going to be any direct interaction except by predefined routines between Python and the database - any such 'views' are only going to exist as part of the data processed within the routines. My approach to this is "Don't do the SQL query directly on the Python, call the function which you can change on the DB server!"
which is actually how the initial design was xD
 
MDCCL
MDCCL
@Lamak Yes, a view seems like a good option
 
Thomas Ward
Thomas Ward
a view might work though. I'm open to suggestions for how I could create said view. As answers on the question of course :)
keeping in mind data is only exposed currently via predefined routines.
(unless i'm logged on the server as the admin user heh - the user python uses only has the ability to execute and get data from the routines on the system)
 
Lamak
Lamak
7:54 PM
@ThomasWard ah, well, if there's no interaction there then seems fine to me. The problem is when people stop seeing that table that way (no interaction) and want to start using it for other purposes. I would just avoid that future issue by having the actual date (and time)
 
Thomas Ward
Thomas Ward
@Lamak Indeed. (Though in this use case for the table, the specific use is Date without Time, so a 00:00:00 for time is sufficiently acceptable)
 
Lamak
Lamak
@ThomasWard well, no time then :-)
but the point I was making stands
 
Thomas Ward
Thomas Ward
yep :)
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@Lamak I like diagonal arrows! Guess didn't get the memo ;)
 
Lamak
Lamak
@ypercubeᵀᴹ I'm pretending I didn't read that
 
Thomas Ward
Thomas Ward
7:58 PM
xD
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@Lamak I even draw them in ASCII occasionally ;)
 
Lamak
Lamak
@ypercubeᵀᴹ well, ascii can't have a real diagonal arrow, so....
 
ypercubeᵀᴹ
ypercubeᵀᴹ
I'll try a 1000 x 1000 character array next time with print-screen and zoom out. Just for you
 
Lamak
Lamak
Seems interesting enough
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@AndriyM had revised one of my ascii arts. Can't remember what program he used but the output was quite nice: dba.stackexchange.com/posts/126961/revisions
 
Lamak
Lamak
8:14 PM
nice
 
ypercubeᵀᴹ
ypercubeᵀᴹ
8:27 PM
Is it OK if I add the sql-server tag to an azure-sql-database question?
Is it considered a SQL -Server variant or a separate product?
 
Tom V
Tom V
@ypercubeᵀᴹ Depending on the question the overlap could be big enough yes
 
 
2 hours later…
jcolebrand
jcolebrand
10:17 PM
You know, some days I think this room is just too talkative ...
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@jcolebrand Is it possible to run a query and find how many comments were made in the room each day?
 
jcolebrand
jcolebrand
@ypercubeᵀᴹ Yes, I think so ...
But, I'm pretty sure that's on the info tab
 
ypercubeᵀᴹ
ypercubeᵀᴹ
And then a graph would be even nicer
 
jcolebrand
jcolebrand
I mean, if such a thing were technically possible ... imagine the usefulness!
You could even tell when people were likely to be around
Ridiculous, I know
 
ypercubeᵀᴹ
ypercubeᵀᴹ
10:33 PM
0
Q: How can I change the lenguaje of Postgresql logs

Juan Carlos OropezaRight now my db get disconnected when calling my user function. I would like to ask for help about it but the message are in spanish. How I make my logs be in english ? I can understand what said, but dont know what to do about it. Or at least make it show the accent character properly like: ...

postgresql
Espanol anyone?
 
Andriy M
Andriy M
11:08 PM
@ypercubeᵀᴹ Likely Far Manager (quite a Swiss Army knife by way of a file manager).
 
ypercubeᵀᴹ
ypercubeᵀᴹ
11:20 PM
@AndriyM yes, right!
Jan 26 at 13:23, by Andriy M
@ypercubeᵀᴹ I like it very much, especially the sloping lines. I was just thinking of adding boxes around the entity names and it was easier to do that using pseudo-graphics (the editor in my Far Manager has a built-in plugin for that).
 

« first day (2172 days earlier)      last day (2712 days later) »