« first day (2429 days earlier)      last day (2432 days later) » 
00:00 - 20:0020:00 - 00:00

Andriy M
Andriy M
12:43 AM
Isn't there some kind of irony in the situation when revival of a two-month old question is rewarded six years later?
 
 
2 hours later…
Paul White
Paul White
2:59 AM
@AndriyM Yes.
 
Paul White
Paul White
3:16 AM
Today is the day (here) that there is exactly as much daylight as nighttime.
 
Joe Obbish
Joe Obbish
4:10 AM
@sp_BlitzErik Your comment made me find a bug and I had to do a bunch of extra work
hope you're happy
 
 
2 hours later…
Andriy M
Andriy M
5:46 AM
@PaulWhite So I thought.
Good morning
 
Paul White
Paul White
morning
 
hot2use
hot2use
Good morning
 
ypercubeᵀᴹ
ypercubeᵀᴹ
6:16 AM
morning
 
hot2use
hot2use
Yewww. Is the following question too basic?
-1
Q: Progress to MS SQL linked server

Parassharma1990I have to setup a linked server from progress DB to MS SQL . Progress is installed on Linux machine and MS SQL is installed on windows machine. Please help !!

sql-server linked-server progress-database
No need to click on the link. That's all you get.
 
Andriy M
Andriy M
Don't know about too basic but it's not very clear what specifically their trouble is.
 
Colin 't Hart
Colin 't Hart
6:47 AM
IMHO this question should be voted to close as "Too broad", not "Unclear". It's very clear what they're asking, but they haven't identified a specific problem.
 
Andriy M
Andriy M
7:05 AM
I often find it difficult to decide between unclear and too broad.
"Unclear which close reason to choose"
3
 
Master Database
Master Database
7:24 AM
0
Q: Change the "add a comment" link text?

Paul WhiteThere is an active feature request on meta.SE by one of the Community Managers, proposing to change the add a comment text below each post to something that better conveys the intended usage of comments on Stack Exchange. The change on Area 51 uses "suggest improvements": There is a separat...

discussion comments
2
 
Paul White
Paul White
@AndriyM When more than one applies, I tend to choose the one with the text that is most likely to help the OP improve their question.
 
hot2use
hot2use
@MasterDatabase Vote cast
@AndriyM Thanks for the additional cleanup. Was too focussed on getting the question into a reasonable state to notice the obvious.
@PaulWhite got it
 
Paul White
Paul White
7:41 AM
@hot2use You missed a chance to flag one of my comments as No Longer Needed :)
 
Tom V
Tom V
The distinction on the meta.se post should be made here too
 
hot2use
hot2use
@PaulWhite oh bugger me jumpers ;-)
 
Paul White
Paul White
8:29 AM
@TomV hm? oh I see ok
 
hot2use
hot2use
8:54 AM
@PaulWhite now I didn't
:-)
Do I get bonus points for flagging a moderator to remove a moderator's comment?
 
Paul White
Paul White
@hot2use Yes; however, only moderators can see your "bonus points" :)
 
hot2use
hot2use
9:13 AM
I see (well actually I don't)
 
hot2use
hot2use
9:23 AM
Hmmmm. Funny.
 
gbn
gbn
I'm with Aaron on a quick read of that. Most folk are too stupid to analyse with Thomas really means
I've had 200GB tables with no PK for example, bit I like to think I knew what I was doing in that one particular case
But hey, keeps me employed when someone copies and pastes off the interwebz
2
 
hot2use
hot2use
@gbn True
 
gbn
gbn
I see Thomas' point, but it's not the general case for all those shit databases out there.
My peak load has been 50k rows per second in previous gigs. Is that high or low in Thomas' eyes? Or OP's eyes?
The question says "The system is relatively young and our biggest tables are just over a million rows". So it's Excel then
 
hot2use
hot2use
9:41 AM
I agree with Aaron in that the sentence in question is right at the top and is left there on its own without context.
 
dezso
dezso
10:09 AM
> over-villainised
 
 
1 hour later…
Mikael Eriksson
Mikael Eriksson
11:12 AM
Just wondering if this function is missing an order by. I certainly would add one just to make sure numbers are concatenated in order. Adding it however does not add a sort operator to the execution plan so apparently SQL Server somehow knows that numbers come out in order from Sequence Project operator. But guaranteed? I think not.
 
sp_BlitzErik
sp_BlitzErik
11:26 AM
@JoeObbish ecstatic! Did you file a connect item and update the post?
 
Alex
Alex
12:12 PM
Hi all
 
Paul White
Paul White
@MikaelEriksson Yes TOP should always be accompanied by an ORDER BY unless random results can be tolerated. As you say, adding the correctness incurs no overhead, so why be sloppy. Equally for the ordering part of the XML PATH.
 
Mikael Eriksson
Mikael Eriksson
12:33 PM
@PaulWhite I would not put it in the cte where top is used but in the xml query. Think I trust riownumber not to skip numbers but not trust ordered rows going to the udx operator.
 
Paul White
Paul White
@MikaelEriksson Right, absolutely, but in principle TOP (LEN(@pString)) (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) could return any numbers in any order.
There's nothing to say that the 'first' row encountered should be numbered 1, for instance.
 
Mikael Eriksson
Mikael Eriksson
That is true. Will let you know if I can repro that :)
 
Paul White
Paul White
Hey good luck with that one, but there's really no need to not write this sort of thing correctly.
 
Mikael Eriksson
Mikael Eriksson
BTW is segment + sequence op non parallel plans/section only?
 
Paul White
Paul White
@MikaelEriksson Historically yes, more recently it can be parallelized on PARTITION BY elements, otherwise yes. Haven't tested that limitation with the new window aggregate though.
But to state it simply, numbering rows is a serial op.
 
Mikael Eriksson
Mikael Eriksson
12:40 PM
Got the new window batch operator (parallel) if I order by something requiring a sort.
 
Paul White
Paul White
@MikaelEriksson Yes it certainly can of course, not sure about ROW_NUMBER without a PARTITION BY?
@MikaelEriksson Oh yes you're right, that appears to work.
 
Mikael Eriksson
Mikael Eriksson
It was with this query using some parallel suggestion trace flag and a CCI of course
 
Paul White
Paul White
It's probably all in Itzik's window agg post.
 
Mikael Eriksson
Mikael Eriksson
I now that you mention itzik. I have already asked this exact question to him in a comment. And he answer and I forgot.
 
Lamak
Lamak
@PaulWhite Haven't tested that limitation, well, we are waiting
 
Paul White
Paul White
12:44 PM
@Lamak Well I've tested it now :)
 
Lamak
Lamak
that was a short wait
 
Mikael Eriksson
Mikael Eriksson
 
Paul White
Paul White
12:57 PM
@MikaelEriksson Sad. Otherwise it would be easy to show that row number assumption breaking.
 
Paul White
Paul White
1:23 PM
@MikaelEriksson Are you going to mention that anywhere? I was thinking of posting something on the SSC thread about it. Maybe with a raw CLR implementation if I can be bothered.
This seems about right to me: pastebin.com/2y0pSUX6
 
Mikael Eriksson
Mikael Eriksson
I could edit the answer with a change comment.
 
sp_BlitzErik
sp_BlitzErik
on which ssc thread?
 
Mikael Eriksson
Mikael Eriksson
 
sp_BlitzErik
sp_BlitzErik
ah, okay
i only asked because i know paul had linked to the same ssc article i had in a comment
and i think the guy who wrote it (dwain) died sort of recently
 
EBrown
EBrown
@sp_BlitzErik So we have really poorly performing queries at work (like, some are taking 30-40s), the Execution Plan recommended two indexes, which we created (total "estimated" impact ~20%), I'm thinking about running a statistics update this weekend, is there any "gotcha" of this? (Never updated stats before.)
 
Paul White
Paul White
1:30 PM
@sp_BlitzErik Yes, very sad, though not all that recently.
 
Mikael Eriksson
Mikael Eriksson
Jeff M might not like being edited.
 
sp_BlitzErik
sp_BlitzErik
@EBrown what does the first part of that have to do with the second part of that?
 
Paul White
Paul White
@MikaelEriksson Go for it. All edits are suggestions. If he doesn't like it he can roll it back.
 
EBrown
EBrown
@sp_BlitzErik You're the one who is completely against worrying about index fragmentation, also trying to provide context.
 
sp_BlitzErik
sp_BlitzErik
@PaulWhite yeah, very. i always enjoyed dwain.
@EBrown those missing index requests sound like they suck. 20% is a cry for help, not a solution.
 
Joe Obbish
Joe Obbish
1:32 PM
@sp_BlitzErik no, the bug was in my code
not MS's
 
Paul White
Paul White
@sp_BlitzErik Yes, I remember his first article for SSC, then watching as he progressed to SImple Talk etc.
 
EBrown
EBrown
@sp_BlitzErik Well most of these tables we indexed are brand new, and over the course of the last month they have literally gained ~500k rows each, running the execution plans have significant differences between the expected and actual row counts (like, expected of 15 and actual of 20k or so), and I'm grasping at straws at this point.
 
sp_BlitzErik
sp_BlitzErik
@PaulWhite i was really happy when he started his own blog, too
@EBrown sounds like you should hire someone who knows what they're doing
 
EBrown
EBrown
@sp_BlitzErik Thanks, very helpful, glad I asked.
 
sp_BlitzErik
sp_BlitzErik
22 hours ago, by sp_BlitzErik
is there an aloofness competition in chat today?
 
Joe Obbish
Joe Obbish
1:36 PM
Don't take it personally. Paul tells me to hire a professional all the time.
 
sp_BlitzErik
sp_BlitzErik
i was going to suggest hiring you
 
Paul White
Paul White
Good one!
 
Joe Obbish
Joe Obbish
I'm not for hire
 
Paul White
Paul White
@sp_BlitzErik Yes. IIRC (and I may not) I discovered the blog very shortly before learning he had passed on. Quite a shock when it's someone you 'know'.
 
sp_BlitzErik
sp_BlitzErik
@PaulWhite yeah. prior to him it may have been larry toothman, and then before that maybe ken henderson.
@JoeObbish it was a trick suggestion, no one would hire someone who writes blog posts with code bugs in them.
 
Paul White
Paul White
1:40 PM
@sp_BlitzErik Ah true.
 
Andriy M
Andriy M
@sp_BlitzErik And misaligned tag sections.
2
 
sp_BlitzErik
sp_BlitzErik
@AndriyM career suicide, tbh
 
Joe Obbish
Joe Obbish
if you don't have a blog then I don't want to hear it from you
you can't possibly understand the struggle
 
sp_BlitzErik
sp_BlitzErik
joe understands the struggle and the streets
 
Joe Obbish
Joe Obbish
yes
and all of you corporate types have all of the blogging stuff taken care of for you
so you don't get to judge either
 
Mikael Eriksson
Mikael Eriksson
1:44 PM
 
Paul White
Paul White
@MikaelEriksson Yes I saw. Is that order by N ok? There are quite a lot of Ns at that level.
 
sp_BlitzErik
sp_BlitzErik
@JoeObbish all these IVORY TOWER types with PAID wordpress themes
 
Paul White
Paul White
@sp_BlitzErik And custom domains!
 
hot2use
hot2use
@sp_BlitzErik Good man Ken. His books taught me the basics of indexes and optimization.
 
Mikael Eriksson
Mikael Eriksson
@PaulWhite Perhaps change to 1 instead?
 
sp_BlitzErik
sp_BlitzErik
1:45 PM
@PaulWhite truly not blogging for the common people
 
Joe Obbish
Joe Obbish
@sp_BlitzErik and their plugins
I have to use BETWEEN to avoid formatting bugs
 
Paul White
Paul White
@MikaelEriksson Or alias it uniquely and order by that
 
Joe Obbish
Joe Obbish
good think Aaron doesn't know about my blog
 
sp_BlitzErik
sp_BlitzErik
@JoeObbish probably have custom applets for formatting t-sql too. break out the guillotines.
 
Paul White
Paul White
@JoeObbish Just don't switch to visual stay in text
 
Joe Obbish
Joe Obbish
1:47 PM
I don't know what that means
 
Paul White
Paul White
 
sp_BlitzErik
sp_BlitzErik
 
Paul White
Paul White
Look at us being all helpful.
 
sp_BlitzErik
sp_BlitzErik
@PaulWhite i'm flagging this as "unclear what you're screen capping"
 
Paul White
Paul White
@sp_BlitzErik DECLINED
 
sp_BlitzErik
sp_BlitzErik
1:49 PM
@PaulWhite when the rev comes... when the rev comes...
 
hot2use
hot2use
user image
3
 
Paul White
Paul White
@hot2use I have the same set!
 
Joe Obbish
Joe Obbish
oh I see
that doesn't work
 
sp_BlitzErik
sp_BlitzErik
@hot2use that's awesome
 
Paul White
Paul White
@sp_BlitzErik That's why I'm making the most of my time now
 
hot2use
hot2use
1:50 PM
I like(d) his style so I bought the lot
 
Paul White
Paul White
I got mine in a box. Not sure where from.
 
Joe Obbish
Joe Obbish
I'm trying out the new gzip feature in sql server
feel free to make fun of me
 
sp_BlitzErik
sp_BlitzErik
@JoeObbish "new"
are you talking about the compress function?
 
Joe Obbish
Joe Obbish
yes
and it's for the latest version
 
sp_BlitzErik
sp_BlitzErik
i wish you could zip and unzip files with those
 
Paul White
Paul White
1:51 PM
meh 2016 that's old skool
 
sp_BlitzErik
sp_BlitzErik
I wonder if there's going to be a SQL Server 2018.
 
Paul White
Paul White
Or a 2017.5
 
Joe Obbish
Joe Obbish
2017R2
 
Paul White
Paul White
No doubt they'll move to monthly releases at some stage
@JoeObbish We don't joke about R2
 
Joe Obbish
Joe Obbish
2017R3
 
Andriy M
Andriy M
1:53 PM
2017C3PO
5
 
Paul White
Paul White
@MikaelEriksson Num works yes. It was probably fine before, but probably.
The evil side of me considered submitting that function to Code Review SE :)
 
Mikael Eriksson
Mikael Eriksson
@PaulWhite For a while there I had different cardinality estimates with the modified version. Can't repro so probably some silly mistake.
 
dezso
dezso
@sp_BlitzErik for Android (codenamed TomTom), presumably
 
sp_BlitzErik
sp_BlitzErik
@dezso HAHAHA
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@hot2use I've got those ones too. Pity the author died.
 
Paul White
Paul White
2:02 PM
We all live in tempdb
4
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@PaulWhite I thought you lived in a yellow submarine, but maybe I was thinking of someone else.
 
sp_BlitzErik
sp_BlitzErik
@PaulWhite now i know what you're doing with that 240gb of your ssd
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@sp_BlitzErik Could be worse. Could be 1,900TB of porn.
 
sp_BlitzErik
sp_BlitzErik
@ConcernedOfTunbridgeWells searchable? asking for a friend.
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@sp_BlitzErik Don't know. Ask the OP.
 
sp_BlitzErik
sp_BlitzErik
2:05 PM
@_@
i was only answering questions on dba.se, i swear
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
Some people have far too much time on their hands.
And not enough hand cream.
I'm here 'til Thursday. Try the fish.
 
sp_BlitzErik
sp_BlitzErik
waits for all the "on their hands" jokes
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
I believe Amazon have withdrawn their 'unlimited' storage options.
 
hot2use
hot2use
@sp_BlitzErik really now...
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
2:21 PM
I am reminded of a time (about 20 years ago now) when a friend of mine - who now works as a SRE for a major social networking site - got involved in making a bayesian web filtering appliance. This device was primarily intended for use by schools to identify porn sites or other material that folks might not want their little darlings browsing during school time.
In order to train the device they scraped 700 porn sites. We can only speculate what their ISP must have thought of this.
 
Joe Obbish
Joe Obbish
in middle school I figured out how to defeat filtering like that and told all of the other students
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
Silly boy - you should have charged them for it.
(Showing my age) Back when I was about that age I made a recording of a 976 phone sex line and charged folks 50c to listen to it. I think I got about 3 takers in the end, and back then a long-distance call from New Zealand to the U.S.A. cost about $3/minute.
This would have been about the beginning of the 1980s sometime IIRC.
 
Max Vernon
Max Vernon
how to be super-helpful:
You created a backup of your manifest file, correct? — Max Vernon 14 secs ago
 
sp_BlitzErik
sp_BlitzErik
flagged as self-promoting vote ring collusion
 
Joe Obbish
Joe Obbish
eh
in terms of getting in trouble for it
 
Max Vernon
Max Vernon
2:28 PM
@sp_BlitzErik lol, it's only a comment-answer.
 
Joe Obbish
Joe Obbish
feel like if you were making money the consequences would be a lot worse
besides, no way to prevent other students from telling others
 
sp_BlitzErik
sp_BlitzErik
joe's first open source project
 
Joe Obbish
Joe Obbish
yes
our IT department was really bad
defeating the filtering was trivially easy
the guy in charge told a student an admin password
six characters long
worked on every PC
 
sp_BlitzErik
sp_BlitzErik
"admin!"
 
Joe Obbish
Joe Obbish
people were playing games, switching to linux, minor stuff like that
that one I got in a lot of trouble for because somebody snitched
it's one of those things that you can't just handle well as a kid
they threatened us with legal action and all kinds of nonsense
 
hot2use
hot2use
2:32 PM
My telephone bills were 600 CHF/month back in the 90's. Compuserve was the way to go back then. 100776.1776 ( I think)
 
Joe Obbish
Joe Obbish
anyway, the best part is that the guy went to jail for stealing millions of dollars
so I guess he was incompetent at that too
 
hot2use
hot2use
Was able to download PGP 2.0 even though I was living in Europe.
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@ConcernedOfTunbridgeWells The date is fine. Where is Kent? ;)
 
Paul White
Paul White
Nowhere near Superman.
 
Andriy M
Andriy M
That's a popular culture reference all right
An easy one, even I know what it's about
 
dezso
dezso
2:43 PM
@AndriyM is it?
 
Lamak
Lamak
@dezso yes
 
dezso
dezso
@Lamak well then
@ypercubeᵀᴹ directly before uckyFC
 
Andriy M
Andriy M
Clark Kent
Clark Joseph Kent is a fictional character appearing in American comic books published by DC Comics. Created by Jerry Siegel and Joe Shuster, he debuted in Action Comics #1 (June 1938) and serves as the civilian and secret identity of the superhero Superman. Over the decades there has been considerable debate as to which personality the character identifies with most. From his first introduction in 1938 to the mid-1980s, "Clark Kent" was seen mostly as a disguise for Superman, enabling him to mix with ordinary people. This was the view in most comics and other media such as movie serials and TV...
 
Paul White
Paul White
@AndriyM It works for the guy going to jail for stealing millions of dollars as well. One of the early films had Richard Pryor collecting rounded cents.
It's only modern pop culture I struggle with :)
 
Andriy M
Andriy M
OK :)
 
Zane
Zane
3:47 PM
Wat do with this?
0
Q: Trying to find a good SSRS bootcamp/course

mcmahon.anI'm trying to find a reputable SSRS bootcamp in my area. I've Googled, but I'd like to dig deeper. Where should I look to find a good bootcamp? Please feel free to point me to another part of stackexchange.

ssrs
 
bluefeet
bluefeet
Well that was easy @Zane
 
Lamak
Lamak
hey @bluefeet
 
bluefeet
bluefeet
hey
 
Zane
Zane
@bluefeet I kind of figured it would get obliterated but I tried to toss the poor fella a link real quick.
 
 
1 hour later…
Tom V
Tom V
5:08 PM
Hey @Zane how are you doing
 
Zane
Zane
Pretty fantastic.
 
Max Vernon
Max Vernon
5:40 PM
I'm sorry Dave, I can't let you do that.
 
Zane
Zane
Where's that one from?
 
Max Vernon
Max Vernon
I just got it when posting an answer. I suppose SE thinks I'm not human.
 
Zane
Zane
You're just to damn good.
 
Max Vernon
Max Vernon
lol, I doubt that!
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon maybe you didn't give proper full disclosure
 
Zane
Zane
5:49 PM
@sp_BlitzErik I think he's just been a dang robot the whole time!
 
Max Vernon
Max Vernon
@sp_BlitzErik my monitor hates you. (goes off to get windex).
 
sp_BlitzErik
sp_BlitzErik
6:00 PM
@Zane WHAT'S WRONG WITH ROBOTS
 
Paul White
Paul White
@MaxVernon I've had that too. Usually when I've had a draft open for a while.
@sp_BlitzErik I read that as RABBITS
🐰🐇🐰🐇
 
sp_BlitzErik
sp_BlitzErik
@PaulWhite that's because you're an unrepentant rabbit murderer
 
Paul White
Paul White
I thought carrots were good for them
Actually I should check pets.se
 
Joe Obbish
Joe Obbish
6:18 PM
@PaulWhite carrots are treats
 
Zane
Zane
What method should we use to crush this terrible question?
 
Tom V
Tom V
But null is unperformant
Shoot now my phone will start using that in autocorrect
 
swasheck
swasheck
@Zane i dont know
 
Tom V
Tom V
@swasheck kill it with fire
 
swasheck
swasheck
@TomV of all people i'd hoped that you would get it
 
Tom V
Tom V
6:25 PM
I thought that was what you were alluding to. Did I miss the joke again?
It's been a long day trying to prove a case of blocking wasn't a database issue so I'm tired and slow
 
swasheck
swasheck
NULL
 
mikeTheLiar
mikeTheLiar
Let's say hypothetically speaking I have two tables, A and B, that have a FK relationship. It's not enforced by the data model but we can assume they have a 1:1 relationship. I need to combine these tables, or more accurately, I need to add all of the columns from table B to table A and then transfer the contexts from B to these new columns in A. Let's also say that table B has several hundred columns and I don't want to have to manually type out all of these column names and data types.
Any suggestions on how to make this an painless as possible? And yes, this is very similar to a problem I had a few weeks ago, except this is more or less in the other direction.
 
swasheck
swasheck
normalization?
 
mikeTheLiar
mikeTheLiar
More like these two tables never should've been separate in the first place.
 
Tom V
Tom V
Sql server?
 
mikeTheLiar
mikeTheLiar
6:27 PM
tl;dr Shifting requirements.
@TomV yep
Only thing I can think of is script table B -> create to and then some really hacky text editing.
 
Tom V
Tom V
Right click, script as select(insert, copy pastr
Yah that
 
mikeTheLiar
mikeTheLiar
It's better than nothing. I was hoping there was a trick that I didn't know about but oh well.
Thanks anyway
 
Zane
Zane
@swasheck I thought it was a good bit.
 
Tom V
Tom V
Or dynamic sql but that would probably be worse
 
mikeTheLiar
mikeTheLiar
Dynamic SQL is the Devil's tool.
 
Max Vernon
Max Vernon
6:30 PM
@JoeObbish rabbits are treats
@TomV serves you right!
 
Tom V
Tom V
@mikeTheLiar you could use the query designer and untick some columns and the switch to sql view to avoid the text editing maybe
 
Zane
Zane
@TomV Yeah the time it would take to create this dynamic statement you could have just copied/pasted and driven home already.
 
Tom V
Tom V
I'll go wash my mouth now
 
mikeTheLiar
mikeTheLiar
@TomV eh, this should work. It's only a one-time thing so it doesn't have to be pretty.
My Excel/Notepad++ super-user skills are going to get dusted off for this one I think.
The most annoying part is going to be having to do the null -> enter data -> not null conversions but whatever, I wasn't planning on doing anything this afternoon anyway.
 
Tom V
Tom V
Excel concatenation can be useful too
I don't mind a hacky solution for a one-off
 
Max Vernon
Max Vernon
6:33 PM
@TomV useful in the same way that going to the dentist can be useful too. It hurts, and end up with less teeth.
 
Tom V
Tom V
Beats dynamic SQL
 
Zane
Zane
@TomV yeah. Way too messy.
 
Tom V
Tom V
At least with a dentist you're done in half an hour
 
swasheck
swasheck
@Zane thanks. hooray for 3VL
 
Max Vernon
Max Vernon
too bad this was deleted - I wanted to use it on this question
 
Joe Obbish
Joe Obbish
6:42 PM
"SQL Server Express instance with 20,000 databases" - how is this even possible?
is the 10 GB limit at the database level?
 
Zane
Zane
@JoeObbish hahaha you found my all time favorite question.
That guy was a nutbar.
 
Joe Obbish
Joe Obbish
"I don't think that it's that ridiculous to attach / detach a database whenever I want to do a query."
oh my
 
Max Vernon
Max Vernon
@JoeObbish yep
 
Zane
Zane
He got into a pretty maddening argument with us all back in the day.
I was in tears due the the hilarity of it all.
 
Max Vernon
Max Vernon
no kidding @zane
some people just don't want to hear "no".
 
Joe Obbish
Joe Obbish
6:46 PM
"I'm honestly planning on having 1m"
ONE MILLION DATABASES
 
Lamak
Lamak
@Zane I remember that
hilarious
 
Joe Obbish
Joe Obbish
I bet he's excited for 2016 SP1
just think about what he'll be able to do then
 
Zane
Zane
@Lamak I'll never forget that. That's the most I've ever laughed during a workday.
 
Joe Obbish
Joe Obbish
"In this case, setting the value to 2,147,483,647 (the largest number possible) (0x7FFFFFFF) should be almost long enough."
man
getting to 10k finally paid off
2
 
sp_BlitzErik
sp_BlitzErik
QUICK EVERYONE UPVOTE ME SO I CAN SEE
or just screen cap
whichever is more ethical
not that i expect ethics out of a bunch of database people
 
Joe Obbish
Joe Obbish
6:54 PM
done
 
sp_BlitzErik
sp_BlitzErik
HAHAHAHAHA
> (twenty thousand databases)
i'm dyyyyying
> I might, as an alternative- look at using SQL CE, or whatever that thing is called anymore.
@_@
this guy is a gem
 
Joe Obbish
Joe Obbish
It's interesting how much he loves sql server
 
sp_BlitzErik
sp_BlitzErik
> and I don't see the big deal. Need to shrink 1,000 databases? it's just SQL.. just a simple script. I'm a certified DBA, I'm sick and tired of paying for MS SQL licenses
 
Joe Obbish
Joe Obbish
but isn't willing to pay for it
 
Max Vernon
Max Vernon
@JoeObbish I'm not sure if he felt the sarcasm on that
 
Joe Obbish
Joe Obbish
7:00 PM
@MaxVernon you should have told him to submit a connect item to support bigint
 
Max Vernon
Max Vernon
@JoeObbish lol.... now that's going to be a long wait. Both for Connect, and if they implement, for the service to startup.
 
sp_BlitzErik
sp_BlitzErik
imagine what that would look like for an AG
 
Max Vernon
Max Vernon
@sp_BlitzErik I worked on a system with 10,000 databases on a single server, it wasn't pretty. There are so many issues that you just never see on systems with only a couple hundred dbs.
 
Joe Obbish
Joe Obbish
@MaxVernon I had an issue with 300 databases that took us months to figure out. I thought that was bad...
some kind of backup process was failing
 
Max Vernon
Max Vernon
@JoeObbish just trying to find a database in Object Explorer is a massive challenge. One that you give up on the first time you try it.
 
Joe Obbish
Joe Obbish
7:09 PM
the query times out you mean?
oh, you mean scrolling through the list
there's a database filter option
that might be the only valid use case for it
 
Max Vernon
Max Vernon
@JoeObbish yah there are ways around it but it just kinda snowballs from there.
 
Tom V
Tom V
I remember that question too. I'm not sure if you can still see the comments but he wouldn't accept the fact it was a bad idea
I can't even see deleted questions still
Either the voting ring doesn't work or my answers are crap
 
Max Vernon
Max Vernon
@sp_BlitzErik "Index rebuilds on big tables can take some time to roll back" - sounds like you learned that the hard way.
 
Joe Obbish
Joe Obbish
@TomV you have a good point to answer ratio
just need to post more answers
@MaxVernon still have that VM?
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon mostly what i learned is that dbo.Sort hates tempdb with a passion
@TomV let's start our own voting ring
 
Max Vernon
Max Vernon
7:17 PM
@JoeObbish which? the BIG_DATA one?
 
Joe Obbish
Joe Obbish
@MaxVernon yes
 
Tom V
Tom V
I'll be the first one to have a microsoft-dynamics badge though
 
Max Vernon
Max Vernon
@JoeObbish yep
 
Joe Obbish
Joe Obbish
you should issue a rebuild against it
 
Max Vernon
Max Vernon
lol. I love you too, Joe.
 
Joe Obbish
Joe Obbish
7:18 PM
hey it's a VM
I'd do it but no VM
 
Tom V
Tom V
@sp_BlitzErik I only need a hurdred more upvotes to get to 10k y'all are slacking
 
Max Vernon
Max Vernon
@JoeObbish The problem is it's on my laptop which gets suspended every day - all sessions get disconnected and everything rolls back.
if something takes longer than about 8 hours it's a bit problematic
@TomV - here's a screenshot
 
Tom V
Tom V
Ah I remembered another question then
Haha somebody started upvoting me just now.
Voting ring confirmed
3/100 @sp_BlitzErik
And my most crappy answers too ♥️
 
Max Vernon
Max Vernon
@TomV I hate zero-voted answers
 
Tom V
Tom V
7:33 PM
TBH those are old answers and probably deserve downvotes rather than upvoting
 
Max Vernon
Max Vernon
@TomV I can do that if you rather ;-)
 
Tom V
Tom V
At least the first few
 
Max Vernon
Max Vernon
@TomV SELECT * FROM Answers ORDER BY votes ASC
 
Tom V
Tom V
I don't have the peer pressure badge yet
😎
 
sp_BlitzErik
sp_BlitzErik
@TomV i tried to get one but couldn't get enough downvotes
just a bunch of argumentative comments
 
Max Vernon
Max Vernon
7:39 PM
@sp_BlitzErik lol... perhaps I should've DV'd those ones just now.
 
Tom V
Tom V
That one and reversal seem to be hard
I had an answer ready for a downvotes question at some point but the question only got to minus three
 
sp_BlitzErik
sp_BlitzErik
getting an answer to 20 upvotes is pretty hard
unless you appeal to folks who only vote for answers that quote BOL
 
Tom V
Tom V
Peer pressure should be easy if you are willing to embarrass yourself for the time the answer is visible to mortals
Posting a crap answer isn't really a challenge
 
Max Vernon
Max Vernon
ahhh but posting an answer you don't think is crap can be.
 
sp_BlitzErik
sp_BlitzErik
what was your answer?
"check out this post on brentozar.com..."
 
Tom V
Tom V
7:49 PM
It could have been that latest backup question to NUL device
I was planning to bring that one up now and then 😇
 
sp_BlitzErik
sp_BlitzErik
i upvoted that without reading it
for shame
 
Max Vernon
Max Vernon
@sp_BlitzErik I'm trying to locate it, but it's hard.
 
sp_BlitzErik
sp_BlitzErik
T
W
S
SAID
 
Max Vernon
Max Vernon
you know it!
 
sp_BlitzErik
sp_BlitzErik
for some reason it wouldn't let me put that that second S in
i'm a little embarrassed now
 
Zane
Zane
7:53 PM
Now that we know he's in Azure I feel as though my answer may not really be valid anymore. Thoughts?
3
A: Is there any limit to the number of micro-databases you can put on one SQL server?

ZaneSo there are Pros and Cons to both methods. Without knowing more about your application or the services you're looking to provide I won't be able to give a definitive answer but I'll throw out some of my thoughts on the matter. My case for why you should use 1 Database for all clients. Pros: ...

 
mikeTheLiar
mikeTheLiar
> Hopefully you're team is great at scripting everything.
@MaxVernon y u do dis
 
sp_BlitzErik
sp_BlitzErik
canadian spellcheck
 
Max Vernon
Max Vernon
@mikeTheLiar oh that's terrible spelling. dammit
 
Tom V
Tom V
@AndriyM would have fixed that tomorrow
 
Max Vernon
Max Vernon
@mikeTheLiar fixed - thanks!
@TomV true dat!
 
mikeTheLiar
mikeTheLiar
7:56 PM
❤️
 
Zane
Zane
Changing venues. Be back soon.
 
Tom V
Tom V
I just realized I probably could see deleted posts if I hadn't wasted points on bounties
 
sp_BlitzErik
sp_BlitzErik
i probably could if i answered bounties
it's a
SAD WORLD
 
00:00 - 20:0020:00 - 00:00

« first day (2429 days earlier)      last day (2432 days later) »