« first day (2662 days earlier)      last day (2198 days later) » 

Evan Carroll
Evan Carroll
12:23 AM
How could you ever prove that without access to all the data where the ops go full toxic and then wrongfully delete the posts and ban people?
 
 
2 hours later…
MYGz
MYGz
2:36 AM
Hi. I don't see excel in destination of SQL Server Import Export Wizard. Any tips?
Download Sql Server Data Tools. Lets see if that solves it.
 
jadarnel27
jadarnel27
@MYGz I think you could do CSV, and then just open it in Excel. It's been a while though, I may be wrong.
 
MYGz
MYGz
no csv as well. Just flat file and other odbc connections.
 
jadarnel27
jadarnel27
@MYGz Excel can open flat files to. It has its own import wizard thingamajig. Not ideal, but if it's a one time thing.
 
MYGz
MYGz
Excel provides data import by sql query. But i have records in excess of 800K. So throws memory error.
I would require this often so checking how to add excel.
 
jadarnel27
jadarnel27
2:56 AM
@MYGz Why do you need the data in Excel? Like, what are you trying to accomplish?
Also, what version of Excel?
 
MYGz
MYGz
I have to send transaction data reports in excel that is verified by someone else. Excel 2016.
 
jadarnel27
jadarnel27
For some reason, I am thinking that I have an Excel doc with a SQL Server data source with more rows than that. But I might be wrong.
@MYGz oh, okay.
 
MYGz
MYGz
There is this problem of copying data from SQL server as well. Some times throws memory error if I try to copy more than 300k records
So I have to copy 200K rows at a time and then Excel dies after 800K. But with Export wizard I can go above 1M.
 
jadarnel27
jadarnel27
Have you tried exporting to flat file out of SQL Server, and then opening Excel and importing the flat file?
Otherwise, you may need to consider writing an SSIS package (which is all the export wizard is under the covers I believe).
 
 
2 hours later…
Tom V
Tom V
5:28 AM
@MYGz try 64 bit perhaps?
 
hot2use
hot2use
5:52 AM
Morning
 
gbn
gbn
6:10 AM
user image
2
@hot2use Apropos of a few days ago
 
Andriy M
Andriy M
@gbn Who's that?
Morning
 
gbn
gbn
@AndriyM dunno, random facebook image I liked
appeared in my feed, and I remembered the windows update discussion 2 days ago
 
Andriy M
Andriy M
Ahh, I thought it was from the Windows collection of images
Would seem strange for such one to have a face a random person
 
hot2use
hot2use
@gbn hmmmm
 
gbn
gbn
@AndriyM Have you seen my Avatar?
Well I thought it was funny :) Mrs gbn complained that Windows Update had been nagging for 2 weeks to reboot too
 
Andriy M
Andriy M
6:17 AM
You mean the one with a bloke with a mullet? I seem to remember to have seen it, yeah
 
hot2use
hot2use
I guess the "update" is on a nearly horizontal trajectory and destined for an "impact" on the perfectly working pc?
 
Andriy M
Andriy M
Ohhhh, I've only just realised what's happening there.
The "Windows 10 Update" caption slightly obscured the object and I didn't pay attention to it until I opened the image in a separate tab
 
hot2use
hot2use
being helpful:
As is the nature of the Internet sites and pages often vanish in black holes, never to found again. If you want to reference a site in your answer then that is fine, but it helps the community more if you add some of the relevant information in your answer. It saves it from being sucked into a black hole. Link only answers are removed: ...Answers that do not fundamentally answer the question may be removed. This includes answers that are: ...barely more than a link to an external site... — hot2use 1 min ago
Is that worthy of a "not an answer" flag?
 
Andriy M
Andriy M
6:33 AM
Not sure about that but I would certainly add a comma after the "Internet" in the beginning
 
hot2use
hot2use
@AndriyM Dang, too late
 
Paul White
Paul White
Better yet, make the edit you're hoping the OP will, to demonstrate what you mean as a teaching exercise.
Sometimes that is less effort than writing a beautifully crafted comment
The alternative is to raise a flag and let at least five other people solve the problem for you
Just saying :)
 
Andriy M
Andriy M
Five?
 
hot2use
hot2use
I know, but logically seen: Every answer is an answer (even if it is a link)
The question was/is: What flag should I raise?
@PaulWhite :-)
 
McNets
McNets
7:02 AM
morning
 
Andy K
Andy K
7:14 AM
morning and evening
 
Paul White
Paul White
7:55 AM
@hot2use None, if you can fix it. NAA if you must.
 
 
1 hour later…
Jack Douglas
Jack Douglas
9:05 AM
@McNets we have tweaked it so it's ever so slightly less horrible now
 
Andriy M
Andriy M
9:35 AM
@JackDouglas On a slightly different note (but still related to dbfiddle), is there an easy way to copy all the batches as a single script, similar to how you can split a single script into batches?
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
10:34 AM
@PaulWhite I think git wasn't a terribly good choice of name for an application to begin with.
 
Jack Douglas
Jack Douglas
@AndriyM no but that does sound like a sensible feature
 
hot2use
hot2use
10:53 AM
> Torvalds quipped about the name git (which means unpleasant person in British English slang): "I'm an egotistical bastard, and I name all my projects after myself. First 'Linux', now 'git'."
Git
Git () is a version control system for tracking changes in computer files and coordinating work on those files among multiple people. It is primarily used for source code management in software development, but it can be used to keep track of changes in any set of files. As a distributed revision control system it is aimed at speed, data integrity, and support for distributed, non-linear workflows. Git was created by Linus Torvalds in 2005 for development of the Linux kernel, with other kernel developers contributing to its initial development. Its current maintainer since 2005 is Junio Hamano...
 
hot2use
hot2use
11:20 AM
also from the source code: 
The name "git" was given by Linus Torvalds when he wrote the very
first version. He described the tool as "the stupid content tracker"
and the name as (depending on your way):

 - random three-letter combination that is pronounceable, and not actually used by any common UNIX command. The fact that it is a mispronunciation of "get" may or may not be relevant.
 - stupid. contemptible and despicable. simple. Take your pick from the dictionary of slang.
 - "global information tracker": you're in a good mood, and it actually works for you. Angels sing, and a light suddenly fills the room.
 
dezso
dezso
11:30 AM
It is defined in sequelize as 'DataTypes.STRING', so 255 is not something that I have set personally. But then in pgAdmin, the column is listed as character varying (255). I did leave out the varying part, thinking it was redundant. Maybe that is what you are requesting? — David Gustavsson 23 hours ago
now that's a really unexplainable design decision from whoever wrote sequelize
 
Andriy M
Andriy M
@JackDouglas Currently there's a workaround using the Markdown feature. You need to apply some editing to get just the script but overall it's probably better than copying & pasting the batches one by one, especially when there are particularly many of them.
Something similar to the Markdown "button" but showing just the batches as a single script would seem to me just the thing, although I can see how someone later might request batch delimiters, and preferably customised too...
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
11:56 AM
Be afraid ...
 
Michael Green
Michael Green
12:10 PM
This made me giggle.
107
A: On a dual CPU server, is it normal for one CPU to run hotter than the other?

samozThe problem ended up being a poorly fit heatsink. Maybe poorly fit isn't the right description. Turns out, you have to put thermal paste on the heatsink, not the plastic cover that goes over the heatsink. After removing the plastic cover, the CPU is nice and cool, thanks everyone!

 
Taryn
Taryn
12:21 PM
@sp_BlitzErik that is terrible on so many levels, it's not even funny
 
sp_BlitzErik
sp_BlitzErik
12:35 PM
@Taryn which part?
 
ypercubeᵀᴹ
ypercubeᵀᴹ
I think it's just dumb.
 
hot2use
hot2use
@Taryn +1
 
sp_BlitzErik
sp_BlitzErik
the challenge, or the premise that stack overflow is toxic?
 
Taryn
Taryn
@sp_BlitzErik there are many things wrong with that challenge. SO has issues we're very aware of that.
 
Tom V
Tom V
The tweet he's responding to should just have been ignored
Sounds like one of those crybabies that assume minorities are excluded everywhere
 
Taryn
Taryn
12:43 PM
@sp_BlitzErik the response by both David and Tim captures most of it.
 
Tom V
Tom V
I think bluefeet can attest women are discriminated against by StackOverflow
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV is that tweet related to the challenge? (wondering)
 
sp_BlitzErik
sp_BlitzErik
dba.se is an egalitarian haven where only bad questions and answers are discriminated against
4
 
Tom V
Tom V
@sp_BlitzErik maybe so is worse I don't know, that tweet is so full of hyperbole
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV unless they were talking about SO meta ;)
 
Tom V
Tom V
1:13 PM
@ypercubeᵀᴹ It's a cesspit I agree, but does it discriminate based on background?
 
MYGz
MYGz
Why won't this work?
select * into NewTable from
;with Tb1 as (select * from tb where condition), select ... from Tb1 join tb2 condition
the second line is fetching correct records
I want to insert those records into newtable
 
Lamak
Lamak
@MYGz because is not valid syntax?
 
MYGz
MYGz
How can I insert the fetched records into newtable?
Post as a question?
 
Lamak
Lamak
I mean, replace the last select with select columns into NewTable from ...
 
MYGz
MYGz
1:29 PM
;with Tb1 as (select * from tb where condition), select * into NewTable from (select ... from Tb1 join tb2 condition)
Tried this, not working.
 
Lamak
Lamak
you don't have to use a comma after the CTE
I mean, you need to not use that
 
MYGz
MYGz
Thanks got it.
 
Lamak
Lamak
my bad
 
Joe Obbish
Joe Obbish
mine too, apparently
this room sure feels toxic this morning
 
MYGz
MYGz
I thought I have to select first and then insert
This worked:
   ;with Tb1 as (select * from tb where condition), select ... into NewTable from Tb1 join tb2 condition
 
Lamak
Lamak
1:45 PM
@JoeObbish it does?....is it morning already?
@MYGz I don't see how that could work...it still has that comma
 
Paul White
Paul White
It isn't valid syntax, but that's probably a consequence of not posting the real code
 
MYGz
MYGz
Oh. removed it already didn't correct it here.
 
Lamak
Lamak
@PaulWhite good thing you got here...it isn't morning, right?
 
MYGz
MYGz
The actual query is big. So kinda gets messy here. Posted as a question, actual query is there if you want to look.
 
Paul White
Paul White
@Lamak it is Friday morning :)
0
Q: Inserting fetched records into new table

MYGzI'm fetching some records with below query: ;with tb1 as (select * from tb where condition), select ... from tb1 join tb2 condition I want to insert the records fetched with the above query to a new table. How can I do that? I tried this: select * into NewTable from (followed by above query)...

sql-server sql-server-2012
 
Lamak
Lamak
1:50 PM
@PaulWhite ah dammit
now I envy you
 
Taryn
Taryn
@JoeObbish just removing unnecessary snarky comments
 
Joe Obbish
Joe Obbish
Making a snarky comment is against the rules?
 
Jack Douglas
Jack Douglas
There are no rules
(except jeagl)
 
Paul White
Paul White
@JackDouglas Is that a rule?
 
Jack Douglas
Jack Douglas
hmmmm
 
Paul White
Paul White
1:56 PM
sorry but someone had to say it and it is so usually Lamak
 
Jack Douglas
Jack Douglas
are you being snarky?
 
Paul White
Paul White
eeek
 
Jack Douglas
Jack Douglas
I was being snarky when I called you snarky
 
Paul White
Paul White
well this can't end well :)
 
Joe Obbish
Joe Obbish
the problem must be that there are no good role models in this room
 
Paul White
Paul White
1:58 PM
that would be a big part of it
 
dezso
dezso
@JackDouglas Jack Douglas was snarky. That must be the beginning of a new era.
 
Jack Douglas
Jack Douglas
my family disagree
 
Paul White
Paul White
ironic snark might be an exception to the non-rule
it's hard to know
 
dezso
dezso
@JackDouglas we are family!
 
Joe Obbish
Joe Obbish
some of us are more family than others
 
Paul White
Paul White
1:59 PM
sounds Orwellian
 
Jack Douglas
Jack Douglas
I think there might be some rules that we aren't allowed to speak about
 
Lamak
Lamak
ok
 
Paul White
Paul White
ah a fight club reference, I get that
 
Jack Douglas
Jack Douglas
so do I now
 
Paul White
Paul White
the heap is mighty recursive this morning
 
Joe Obbish
Joe Obbish
2:03 PM
I'm going to take a bit of a break from the heap. Bye!
 
Paul White
Paul White
Congrats Joe on your first clustered index!
 
Lamak
Lamak
@PaulWhite it took a moment....but I got it
 
jadarnel27
jadarnel27
@Lamak So you admit to getting the joke, and yet you still haven't explained it at great length? smh
 
Lamak
Lamak
@jadarnel27 that's not how things works around here
;)
 
Paul White
Paul White
check out the assertive new kid!
invoking The One Rule
 
hot2use
hot2use
2:15 PM
 
Paul White
Paul White
Everything has been done, shut down the internet
 
hot2use
hot2use
:-)
 
jadarnel27
jadarnel27
 
Paul White
Paul White
takes chat offline for comedy effect
 
jadarnel27
jadarnel27
I suppose I had that coming.
 
Paul White
Paul White
2:42 PM
Everyone rejoice mysql-8.0 is out
2
 
McNets
McNets
@JackDouglas I'll take a look later, thank you
 
Paul Vargas
Paul Vargas
3:40 PM
@JackDouglas Hey, Jack. :) -- How are you?
 
Jack Douglas
Jack Douglas
3:54 PM
Hi Paul :)
anyone know if MySQL 8.1 will be a major release or just bug fixes and the next major release will be 9.0?
I'm guessing 8.1 will be a major release
@PaulWhite now on db<>fiddle too: dbfiddle.uk/?rdbms=mysql_8.0
7
 
dezso
dezso
4:30 PM
@JackDouglas twas fast
 
Jack Douglas
Jack Douglas
twas easy because the MariaDB config was nearly identical :)
 
ypercubeᵀᴹ
ypercubeᵀᴹ
4:58 PM
 
dezso
dezso
@ypercubeᵀᴹ nearly starred before clicking
 
 
3 hours later…
ypercubeᵀᴹ
ypercubeᵀᴹ
8:16 PM
I removed the "nosql" tag. Looks pretty much SQL to me ;) — ypercubeᵀᴹ 3 mins ago
 
 
3 hours later…
Evan Carroll
Evan Carroll
11:05 PM
HALLO @ypercubeᵀᴹ !!!
Do we have a position on fun-questions?
 
sp_BlitzErik
sp_BlitzErik
 
Evan Carroll
Evan Carroll
11:48 PM
SELECT get_bit(110::bit(8),x), x::bit(3) FROM generate_series(0,7) AS gs(x);
bwahahah
 
Paul White
Paul White
@JackDouglas That's great, but does it have to be the new default?
 

« first day (2662 days earlier)      last day (2198 days later) »