« first day (2871 days earlier)      last day (1997 days later) » 

jadarnel27
jadarnel27
4:01 AM
@ypercubeᵀᴹ Homeowner's association, in case a JEAGL is truly needed =P
 
 
1 hour later…
Evan Carroll
Evan Carroll
5:25 AM
@MaxVernon they do love me, their new president.
At the last meeting I had one guy get up and say, "I'm going to vote your ass off, you're a leftist."
lol #houston
Glad to know all those conversations about the difference between me and a Democrat paid off.
 
 
2 hours later…
hot2use
hot2use
7:04 AM
Morning
 
Peter Vandivier
Peter Vandivier
7:44 AM
morning :)
 
McNets
McNets
Morning
 
Andriy M
Andriy M
8:49 AM
Morning
 
Peter Vandivier
Peter Vandivier
@EvanCarroll something something only a leftist when I'm JOIN-ing something something
2
 
Master Database
Master Database
9:00 AM
0
Q: Not dead yet! Repairing damaged external links

Peter VandivierIt seems sqlblog.com is now sqlblog.org 1.. One effect of this is to break outgoing links from dba.se. In the past, I've tried to be a good netizen 3,4,5,6 and edit posts with dead links to an appropriate new home or archive copy (god bless the wayback machine - RIP MS Connect). Sadly in this c...

support feature-request
 
Colin 't Hart
Colin 't Hart
9:35 AM
Morning
 
 
1 hour later…
MYGz
MYGz
10:56 AM
greetings!
Will there be any performance difference between these 2 queries?
select * from t1 join t2 on t1.id=t2.id and t1.date=t2.date
select * from t1 join t2 on t1.id=t2.id where t1.date=t2.date
 
Philᵀᴹ
Philᵀᴹ
11:35 AM
 
hot2use
hot2use
@MYGz What DBMS are you talking about?
 
hot2use
hot2use
12:01 PM
Wow. So he has her credentials. That's a security no-no IMO.
3
Q: How to access a SQL Server database using another user with permissions in the same intranet

OutmanWhile I'm waiting for my user to get access permissions, I'm stuck using a colleague's, and whenever I try to run basic SQL queries I have to switch from my Windows user to hers. Hopefully this is clear enough: I want to access a SQL Server for which another user on the the same intranet has per...

sql-server connectivity
> ... for which another user on the the same intranet has permissions while I only have her credentials, and that the server utilizes Integrated Security.
 
Tom V
Tom V
@MYGz There shouldn't be in a reasonable RDBMS
 
George.Palacios
George.Palacios
@hot2use I don't disagree with that at all. But if it's a culture issue it may be beyond this guys power to change. Been there too many times haha
 
MYGz
MYGz
@hot2use @TomV Sql Server 2012
 
hot2use
hot2use
@MYGz Open SSMS and then open a New Query window Click the small icon for Include Actual Execution Plan and then execute the queries.
The small icon just above sa(54)
Compare the output of the execution plans. Do they differ?
 
MYGz
MYGz
12:31 PM
@hot2use Same result for both
 
Tom V
Tom V
29
A: Index performance on ON versus WHERE

Tom VThe performance will be the same. The optimizer will recognize this and create the same plan. On the other hand I wouldn't say they are equal. The first form in the question is far more readable and generally expected. For an example using some tables I have at hand you can see the execution pl...

 
hot2use
hot2use
@TomV Just what I was going to say
 
 
2 hours later…
George.Palacios
George.Palacios
2:59 PM
Hehehe. That thread is growing arms and legs
 
Tom V
Tom V
@MaxVernon not a duplicate, the target is using Enterprise, not Express
:D
Voting to reopen :D
 
Max Vernon
Max Vernon
@TomV I agree it's slightly different for this OP's use case. But essentially, the advice in the dupe target is pretty good - not just my answer, Erik even has a good one [hat-tip to @sp_BlitzErik
good comment about the socket count, @tom
 
Tom V
Tom V
3:16 PM
@MaxVernon It's a comment answer, added 1 minute after the question was closed. Meh
 
Max Vernon
Max Vernon
@TomV d'oh. Sorry!
 
George.Palacios
George.Palacios
@TomV there was no good proper answer to the question anyway without further info.
 
Tom V
Tom V
Nah it's not worth reopening
it's still crap
 
George.Palacios
George.Palacios
Given the way the hosting company doles out resources, I feel the chance of this question being searched for again are slim
 
Tom V
Tom V
Erik's comment is probably the correct answer,
 
George.Palacios
George.Palacios
3:18 PM
Yeah hahaha
They shouldn't even allow the installer to run on a box with one core to be fair.
Or there should be massive warning signs every tab
Not sure I remember the last time I saw a box with less than 2 logical CPUs
 
sp_BlitzErik
sp_BlitzErik
3:46 PM
@TomV :D
 
George.Palacios
George.Palacios
4:04 PM
That needs screenshotting and adding as the actual answer
 
ypercubeᵀᴹ
ypercubeᵀᴹ
It might be VMs of some kind.
 
George.Palacios
George.Palacios
@ypercubeᵀᴹ yeah he said it was, but it still seems really strange to sell processor in GHz
 
 
2 hours later…
Evan Carroll
Evan Carroll
5:59 PM
It is I, Evan Carroll the slightly above average
@George.Palacios That shouldn't have duped.
@PaulWhite that answer by @MaxVernon is great (upvoted), but it's almost entirely specific to the cost-savings under licensing can that question then not be refined to the cost-savings under licensing?
 
Max Vernon
Max Vernon
6:36 PM
@EvanCarroll I un-duped it. Just for you™.
Listening to King Gizard and the Lizard Wizard - Nonagon Infinity. To say it's a long album is a bit of an understatement... it's designed to loop till infinity.
From henceforth, infinite loops shall be known as Nonagons.
 
 
2 hours later…
hasherr
hasherr
8:59 PM
Hey friends
Haven't been in here before but I was hoping I could get some advice on a short problem I'm having
I'm a college student and dealing with databases for the first time
 
Max Vernon
Max Vernon
@hasherr what's the question?
 
hasherr
hasherr
It's really more of a relational database question in general but I haven't been able to find a good answer online even though I know the answer is probably pretty simple
 
Max Vernon
Max Vernon
shoot!
 
hasherr
hasherr
Sure, so I'm designing a very simple web application where one of the features is that users can save lists of chord progressions to the database for viewing later/sharing
If you're not a musician, I can elaborate more, but think of it as just storing a list of strings (a good example might be the list: C major, D minor, G augmented, D7)
 
Max Vernon
Max Vernon
yah, got that. what's the question?
 
hasherr
hasherr
9:02 PM
Well I know its' against normalization to store a list in a single column of a database
So i guess I'm just wondering what the best way to store that data would be
How do you store a list of something in an efficient way without breaking normalization?
 
Max Vernon
Max Vernon
@hasherr not necessarily a problem. Are you ever going to query the data that exists inside each progression? i.e. are you going to look for any progression that has a g minor?
if so, then you'd want to split them out, most likely
if you're never going to search the contents of each progression, then just store it as a string.
be wary of premature optimization
 
hasherr
hasherr
Alright, I figured, just wanted to make sure that was okay.
Yeah I do plan on incorporating this project into another musician app I've written but I can't think of any reason I'd ever need to do that.
 
Max Vernon
Max Vernon
You could mock it up in the database using a normalized table with multiple rows for each chord/note of each progression, just to see what it looks like. That would give you a better understanding of both the difficulties and the rewards of doing it that way.
 
hasherr
hasherr
Yeah, maybe I'll look into that as well.
Thanks for the advice, much appreciated.
 
Max Vernon
Max Vernon
How many rows are you thinking there will be?
 
hasherr
hasherr
9:06 PM
In the progressions table?
 
Max Vernon
Max Vernon
if we're talking about hundreds of millions of progressions, then that's a different question than if we're talking about several thousand to a ~ million.
 
hasherr
hasherr
Yeah, not that many.
 
Max Vernon
Max Vernon
cool - you probably won't be able to make too bad of a mistake with whatever design you choose.
 
hasherr
hasherr
The most I plan on doing with this is throwing it up on Heroku and giving out the domain to a couple of friends
 
Max Vernon
Max Vernon
pick a logical maximum size for the field though. i.e. don't make it varchar(max) simply because someone might put the entire Beethoven's Fifth in there.
 
hasherr
hasherr
9:08 PM
If I ever decide I wanna give it away to the world I'll clean it up and go back and make some better design decisions (in which case paying for hosting will be my biggest problem lol)
 
Max Vernon
Max Vernon
sounds like a great plan!
 
hasherr
hasherr
That's a good thing to consider, yeah I didn't think about that.
 
Tom V
Tom V
A bit disappointed May only did jazzhands and not here dance moves when she started her speech
 
Max Vernon
Max Vernon
@TomV you're talking European again, aren't you?
I heard something about a plan for brexit today, but haven't read anything
 
Wilson
Wilson
9:25 PM
0
Q: Alert users that their records are out-of-date, as they become out of date?

WilsonI have a construction_events table in an Oracle database. Users enter construction events into the table via GIS software. For example, a user can enter a construction project for 2019. The event_status would be entered as proposed. Starts out as legit: The record is legitimate at the time t...

oracle time oracle12c data-integrity data-entry
 
Max Vernon
Max Vernon
@Wilson - are you just shamelessly self promoting that?
not that that's terrible, we just like to know
 
Wilson
Wilson
@MaxVernon Haha, yeah, I suppose that was a bit shameless.

Often I write something like "...This might be of interest to database-minded people". I guess should have intoduced it. :)
 
Max Vernon
Max Vernon
Q: How many IBM contractors and how many weeks does it take to get .Net Framework installed on a couple servers? A: as many as there are.
@Wilson yah, that's the "norm", I suppose.
 
Andriy M
Andriy M
9:41 PM
It's a little sad when people reach 30k+ rep and seemingly never learn that answers shouldn't be posted as comments.
3
Maybe I'm too harsh, maybe they are still "new", they just managed to get the rep very quickly, which, to be fair, is not impossible on SO.
 
Max Vernon
Max Vernon
Oh, Stack Overflow - I see.
All bets are off over there
 
Andriy M
Andriy M
Yeah, I was talking about the linked question
Of course, that suggestion might need a bit of fleshing out but it's still an answer, not a request for clarification or improvement.
 
Evan Carroll
Evan Carroll
10:46 PM
rolf, I filed a CoC and that got my account suspended for 29 days.
 
Max Vernon
Max Vernon
→ 1 message moved to Trash
 

« first day (2871 days earlier)      last day (1997 days later) »