« first day (896 days earlier)   

1:05 AM
Sticks head over the parapet, at risk of a Remus correction...
0
A: Does Database Detach or Offline Clear the Cache Quickest?

Mark Storey-SmithI initially thought you were on to something here. Working assumption was along the lines that perhaps the buffer pool wasn't immediately flushed as it requires "some work" to do so and why bother until the memory was required. But... Your test is flawed. What you're seeing in the buffer pool ...

 
 
7 hours later…
7:39 AM
good morning
 
gbn
Morning all
 
8:01 AM
Morning. It's quiet these hours.
 
@ypercube I'm quiet as I'm still fighting an indigestion for the last 2 days. Hope the heap is better than me :).
 
8:57 AM
@Marian Not quite. Trying to phrase an answer that is strong but not insulting.
 
@ypercube for DBA.SE or for SO? :)
 
@Marian None of the 2, for a customer.
 
@ypercube ah, good luck then. Hopefully you won't lose it.
 
@Marian It probably is. :) Can't imagine it fighting with "indigestion" for so long. Not with so many "antibodies" around. :)
 
@AndriyM it's a better organism :D. And with SO so close, I bet it will just get stronger.
 
9:10 AM
@Marian Yeah, never undervalue the SO vaccine. :)
 
@AndriyM exactly :)
 
gbn
9:23 AM
How to make life hard:
-1
Q: Operand data type nchar is invalid for avg operator

MrAdenI have a table that saves the size of file in the database when the user uploads it. I want to get the average value of all the size that the user uploaded. I have the following column as example that shows the size in Mb's |Size| |1.20| |0.25| |0.50| The result that I want as average is s...

nchar to store numbers, mixed locale formats, then int conversion on real numbers. FFS
 
@gbn a probably missing closing * after the *and
 
gbn
@AndriyM typo. oops. thanks
 
 
1 hour later…
10:34 AM
VtC candidate
0
Q: MongoDB Schema for Users and Admin

JR GaliaI'm new to schema design in MongoDB. How to design User schema in my web app. The web app allow users to create their account and login with their email address and password. Also, there is an admin dashboard of the web app which can be accessed only by administrators. Admin will also use email...

 
 
3 hours later…
1:20 PM
It's too early in the morning for poor ideas like this
-1
Q: Loading data from PDF file to Excel using SSIS

venkatI wanted to load data from PDF file to excel file using SSIS 2008 package. Can any one help me on this. Thanks, Venkat

 
@billinkc Well, it is half past three PM, 35°C outside - and I see where I was wrong an hour ago: I would have taken my helicopter to go shopping (four corners)
(I feel some strangeness in my tense usage above)
TomTom hits again
Probably you should consider a) improving your answer showing this difference and possible problems and b) more importantly, stop calling posters idiots. — dezso 28 secs ago
And could someone nudge this person to do his reviewing more useful?
Yasir Arsanukaev reviewed this 7 mins ago: No Action Needed
the Q definitely needs editing:
0
Q: How to add column/alter structure to big table in MySQL

ineersa'm php developer so dont be strict. I have a big table ~5.5gb dump. Our PM decided to make new column in it to perform new feature. Table is InnoDB So what i tried: Alter table in screen with table lock. Took ~30hours and nothing. So i just stopped it. First i made mistake cause didn't end all t...

 
1:39 PM
@dezso that guy has issues
 
@dezso Yes it does need editing..i was too lazy :(
 
@DerekDowney me too - but then didn't press 'No action needed'...
 
I don't see how or why the answer can be edited.
"No, not possible. Not sensible either. Broken design."
 
... and we now know that not only the OP is an idiot but so is mrdenny
 
Very poor answer, deserves the downvote oblivion it is heading for
 
1:43 PM
(and probably my humble self)
 
-5
A: How to make trigger code execute only for a specific application?

TomTomNo, not possible. Not sensible either. Broken design.

 
Heh, I was about to get offended :(
 
@dezso and he would be fired immediately
 
@dezso Not directed at you. Perhaps against the 6 upvoters of the other answer.
 
Wow, drama on DBA. Where is my popcorn?
 
1:46 PM
@PaulWhite he makes me laugh :).
 
@MikaelEriksson it is over, answer deleted
 
Ah, pity. Answer deleted.
 
he gets a badge for that doesn't he?
deleting a severely downvoted answer or some such :)
 
@dezso Wait no... ah maybe for the best.
 
1:48 PM
It was deleted by a mod I think. I have an extra helpful flag for it.
 
don't mess with @aaron the mod! :)
 
@AaronBertrand that comment was ridiculous....the content of the question clearly said that the trigger should work for one application. The change on the title was right
 
Interesting! Well, at least it's gone. Is there a badge?
6
 
Sadly I think TomTom only read the title before whipping out his "answer"
 
@AaronBertrand yeah, most likely
 
1:54 PM
@PaulWhite no comment :-)
 
let the flags come
 
Indeed
 
@AaronBertrand I was wondering what he had flagged, thnx.
 
is @FreshPrinceOfSO around? he would be trigger-finger happy :)
@AaronBertrand the edit was very good. I don't get his flag. Maybe he's just seeing red..
 
I should probably remove that detail.
Anyway, I did not delete his answer, he self-deleted.
 
1:57 PM
So I get the idea of moderators nudging along people who contribute but occasionally drop the ball. What's the score with PITA numbnuts that just wind everyone up?
 
@MarkStorey-Smith they increase the sales of popcorn and beer. Probably work in marketing? :)
 
@MarkStorey-Smith I'll just say that there is a tolerance threshold
 
gbn
one for here?
0
Q: MSSQLServer 2008 R2 Database Context and Stored Procs

mistawacI am working on a customized maintenance solution and while using the sys.dm_db_index_physical_stats view; I currently have it being referenced from a stored proc. Now when that stored proc runs on one of my databases, it does what I want it to do and pulls down a listing of all records regardin...

 
@MarkStorey-Smith They eventually get a 1-year cool-down after generating a small amount of drama that no-one remembers a week or two later.
 
@PaulWhite I don't want to miss that bit
 
1:59 PM
@PaulWhite I doubt it would ever start at a year
 
@AaronBertrand True, the person in question must have worked hard to achieve that on SO
 
That is probably after a number of repeat offenses and a demonstrated unwillingness to change
 
@gbn looks appropriate for us
 
Not sure there's a good answer... you could put it in master and mark it as a system procedure, or you could put it in the maintenance database and pass it the database name, using dynamic SQL to form three-part names to get the right context.
One doesn't meet his objective (it's not in his maintenance database), and the other is messy (dynamic SQL).
 
@AaronBertrand I was thinking at the last option, dynamic sql.
 
2:07 PM
I guess there's one other approach: a view in the maintenance database that is hard-coded to have SELECT dbname = N'db1', * FROM db1.sys.tables UNION ALL SELECT N'db2, * FROM db2.sys.tables
That has a drawback as well (needs to be maintained) but could still meet the objective
 
gbn
if marked as sytem, has sp_prefix and in master, will it change context automagically?
then it can be wrappered, maybe, in a proc in the DBA database. And the dynamic SQL is in the wrapper as USE XXX EXEC sp_thisone
 
@gbn I'm not sure that the additional layer of redirection will still work like that
 
gbn
@AaronBertrand A bit Rube Goldberg
 
@gbn It works, though
 
2:23 PM
Haha, I got the pundit badge with a comment on a deleted answer
 
poll: if you were going to monitor availability groups, would you use DMVs or XEs?
 
hey neat, finally crossed the 10k mark and I can see deleted answers/posts
 
@DerekDowney congrats
 
@DerekDowney bravo, now start downvoting :)
 
haha
 
2:30 PM
Pál Péter is here
 
I downvote when when appropriate and people haven't spammed downvoted already
 
@dezso future DBA? :)
 
@Marian probably
 
@dezso congrats, nice looking boy you have there.
 
@swasheck SQL Sentry. :-)
2
 
2:34 PM
@Marian Thanks
 
@AaronBertrand that was my first thought ... i was looking at the features and couldnt find it listed
 
@dezso congrats
 
@dezso awesome, congrats!
 
@swasheck it will be announced shortly.
 
@AaronBertrand ah. excellent. that will be excellent and save me a lot of XML querying given the fact that i was leaning toward XE
 
@Marian what did i miss?
 
@FreshPrinceOfSO see @Paul's starred message :).
 
looks like i missed the show
 
@FreshPrinceOfSO a small bit by Tom, he's started to clash with @dezso first, then Aaron. Not expecting to see him survive his SO year here.
 
i missed everything. TomTom is a prick and got banned or something so why is he still around?
 
2:46 PM
@swasheck he was banned on StackOverflow. Not here.
 
oohhhhhhhh
so now he's here making life miserable
 
@swasheck and, as @PaulWhite said, we have him for a year!, how lucky
 
@Lamak it may change...
 
@swasheck if there will be guys patient enough to remove his rated words, he'll stay longer, I suppose. The crowd here is stronger than on SO. At least in skills, if not in patience.
 
@Marian then he'll come into chat and become @FreshPrinceOfSO 2.0 ... i mean ... whoops (just kidding njk)
4
 
2:54 PM
@swasheck well, we have at least one room owner at one time here, just to cool him down if he's too hot-headed.
 
@AaronBertrand looks good --- and glad i didnt have to set up the lab. that sounds like it was frustrating
 
please vtc
-1
Q: Implementation of Pivot keyword in oracle

bourneI was looking at the Pivot keyword in oracle How is the pivot keyword implemented in Oracle?

 
@swasheck i'm not that bad
 
@swasheck that's not the final look and feel but should give a good idea. Good charts and grids detailing everything.
 
@Marian The activity at SF is evident of the behaviour: serverfault.com/users/37059/…
 
2:59 PM
please vtc
0
Q: How can I combine multiple rows into a comma-delimited list in SQL Server 2005

RobHow can I combine multiple rows into a comma-delimited list in SQL Server 2005? Right now, I have a SQL Query like this one: SELECT X, Y FROM POINTS It returns results like so X | Y 12 | 3 12 | 2 18 | 12 18 | 29 29 | 46 29 | 73 29 | 33 I'd like to return results like so: X | Y...

 
@ypercube I see he's searching for new friends..
 
@FreshPrinceOfSO i know ... it was just a joke and you were my first target
 
i has a tail?
 
I'm continually amazed by Oracle's efforts to prevent anything from being easy.
 
@MikeFal in my 3 weeks here, i've learned that Oracle's support also blows goats
 
3:02 PM
@MikeFal fun isn't it?
 
@AaronBertrand even still ... it looks good in its raw, unpolished form
 
@bluefeet If fun is defined as walking barefoot over broken glass, then yes.
 
@ypercube his behavior is a bit better lastly. Not so many down-voted questions.
 
@MikeFal That's my favorite hobby
 
@bluefeet hence, the blue feet
 
3:06 PM
@Lamak that would actually be redfeet or bloodyfeet
maybe that should be my new name... bloodyfeet
 
@bluefeet Unless smurfs bleed blue.
 
@bluefeet right....maybe it's a side effect from the blood loss
 
@MikeFal true
 
Ok, screw you Oracle, back to playing with Riak.
 
3:19 PM
your removed comments are interesting
 
someone didn't like that we closed that oracle pivot question
-1
Q: Implementation of Pivot keyword in oracle 2

the_slkBecause somebody closed the question: Implementation of Pivot keyword in oracle SQL> EXPLAIN PLAN SET STATEMENT_ID = 'PIVOT' for 2 SELECT * 3 FROM EMP 4 PIVOT 5 ( 6 SUM(EMP_ID) FOR f_name IN ('ankit', 'sumit', 'namit', 'manas') 7 ); Explained. SQL> select * from tabl...

it is a good question. Why is it closed? He is asking about the implementation. Implementation is the realization of an application, or execution of a plan, idea, model, design, specification, standard, algorithm, or policy.the_slk 17 mins ago
 
@bluefeet just for fun let's close this one too
 
@swasheck don't even need to for fun, it isn't even a question.
 
@swasheck not really for fun, it isn't a question (though it is fun to close it)
 
yeah
fine
wow ... i'm out of touch
 
3:24 PM
This is fun. The guy is the Chuck Norris of SF chat:
3
in The Comms Room, Jun 10 at 22:05, by Dennis Kaarsemaker
@Jacob TomTom's phone has better internet than Australia.
in The Comms Room, Jun 5 at 14:00, by tombull89
We're a little bit different from other sites. Here's how: if we don't see you trying, we'll rip your head off and poop down your neck. Well, TomTom will, anyway.
in The Comms Room, Jun 2 at 0:29, by Michael Hampton
As TomTom would say, I can do 30.000 visitors/day on my phone...
in The Comms Room, Jun 4 at 20:10, by WesleyDavid
@ewwhite You got a good answer off of a cheap bounty and TomTom said it was a good question?! ARE YOU PREPARED TO DIE TODAY?!
 
Oh, man, I'm posting duplicate comments on everything. Stop saying what I want to say people!
@ypercube yup, seems so
 
@Lamak Let me remove my comment so you look sleak
 
@ypercube well, thanks :-)
 
@ypercube Awesome
 
that's very funny
 
3:36 PM
Am I missing something on this persons question?
0
Q: how to search for a file in directory and sub directories basing on the file name in ssis

New to stackoverflowHow can we search for a particular file in sub folders basing on the file name. I have multiple sub folders and the file which i am looking for may present in the sub folder level or it may be present in sub folders under the present sub folder. can any of you guys help me in this

 
@billinkc I saw a similar question from him yesterday, but didn't bother to answer it. I'm guessing he wants to look for a particular filename?, or maybe some rules with the name
something like "ThisIsMyFile_*.txt"
 
FFS, seriously people? Can they not think 'I wonder what this * thing does'
 
in The Comms Room, Apr 18 at 10:59, by tombull89
As headlines go, TomTom brandishes new strap-on in Amsterdam is probably not the best one. Or maybe it is.
:)) OMG
 
@billinkc questions like this make me wonder if there's a different English out there that makes this make sense
 
@billinkc dude, this is a guy that says that your answer didn't work because you are using the Input folder instead of his folder
how can I post "*" on a comment on SO?
 
3:44 PM
@bluefeet the heap is an unstoppable closing force
closed as not a real question by bluefeet, ypercube, swasheck, Lamak, billinkc
 
user image
4
 
and people think we're not underemployed
 
please vtc
0
Q: Concatenating more than 1 Authors using CASE

Masa RumiI have a sub query that gets the top author by first name but since there can be more than 1 author, I want to concatenate the authors by ",". Would I need to use a case statement to check if there are more than 1 authors and then get the authors. How would I do that exactly? The following is t...

 
4:06 PM
in The Comms Room, Feb 17 '11 at 18:51, by Chopper3
I'd love be a fly on the wall in SF'er TomTom's house; "Where's my cold-cut based breakfast wife!?", "This sausage is too curved!", "What do you mean I can't annex the Sudetenland?!?!?!"
 
4:19 PM
Are there any more ways I can explain why my versions work and the one he's written in the question will not?
@Josh again, that can't work correctly in the version as written in the question because you can only inner join to ONE copy of the sys.tables and sys.indexes catalog views, and there is one copy per database. So if you execute your stored procedure from database 12 (I have no idea what the name of database 12 is), it will only find tables and indexes that are in database 12's copy of sys.tables and sys.indexes. I'm not sure how many ways I can explain this, but look at SELECT name FROM database12.sys.tables and compare it to SELECT name FROM database17.sys.tables (replacing with real names) — Aaron Bertrand 2 mins ago
 
If troublemakers come in the room complaining about bans, let a mod know, and don't engage them.
3
 
@jcolebrand them?, as in multiple guys?
 
@jcolebrand name some names just so we know
 
@swasheck well, a quick look to a certain user with a repeated username (think like tintin), shows a 7 day suspension
 
@jcolebrand I understand there is an ignore feature that might come in handy?
 
4:26 PM
@Lamak sounds adventurous
 
@MarkStorey-Smith mods should never use that ;-)
@swasheck if I were gonna name names I wouldn't have been cryptic
@Lamak a gentleman would never tell
 
@jcolebrand of course
 
anyone attending the brent ozar webinar?
 
@jcolebrand aw c'mon.
 
@swasheck I wasn't that cryptic, you know
 
4:31 PM
@Lamak mm. i know.
 
@PaulWhite Just Jeremiah and Jes
 
@FreshPrinceOfSO His answer was still witty
 
@FreshPrinceOfSO Bugger, my clever comment doesn't look so clever now :(
 
@billinkc missed it
 
why oh why does outlook 2010 never remember that I want new folders to have a specific view?
<sigh>
Did you try a WHERE clause? — bluefeet 8 secs ago
 
4:39 PM
@bluefeet Because you should only accept the default Group By nothing, except that we will really just group by date because that's so not useful
 
@FreshPrinceOfSO I'm attending
 
update #Account
set ID = g.ID
from core.Account g
inner join #Account a on a.AccountIdentifier = a.AccountIdentifier
Why would that have #Account.ID be the exact same value in every field?
Should all the #Account.ID be unique per what's in core.Account?
 
@James as a non-dba this is alien to me
 
AccountIdentifier is a GUID
 
@jcolebrand Is that a typo? on a.AccountIdentifier = a.AccountIdentifier
 
4:42 PM
Why do you have a.column = a.column? Shouldn't the join be a.column = g.column?
 
gah, that is a typo
 
Also should be UPDATE a, not UPDATE #Account
 
I'm cross eyed
thank you
@AaronBertrand I wasn't sure
thank you all
 
@FreshPrinceOfSO what's the topic?
 
@FreshPrinceOfSO It seems like a good intro to mirroring. Basic stuff but I might have needed to read about it first if I didn't work as a systems DBA.
 
4:47 PM
@swasheck mirroring
 
@FreshPrinceOfSO who's the fairest of them all?
mirroring ... is it DR or HA (did he discuss that yet)?
 
you mean Jes?
and she's mentioned it
but i don't understand it
 
@FreshPrinceOfSO well you said Brent so i just assumed it was a "he"
 
it's a brent ozar production
its being recorded
so i'm sure it'll get put up on metube
 
yeah I think they usually have links to the videos on brentozar.com within a couple days
 
4:50 PM
yes. they do
 
now that brent has that green screen you can enjoy him twice as much
 
5:02 PM
Has anyone here seen his training on SQL Server on SAN and VMWare
?
 
5:15 PM
Oh, those far east countries
 
5:29 PM
should we start a petition to START putting them in keychains
sorry. i was thinking roaches and crickets. not lizards.
 
it's so fun when you post an answer first and a later identical get more upvotes...
 
@bluefeet link?
 
0
Q: Can we further simplify this MySQL query?

Dilip TiwariI have a table in MySQL with following fields. Date, block_no, entity, reading Now I am firing this SQL and getting the results. SELECT DATE,block_no, SUM(IF(entity='KS',READING,0)) AS KS, SUM(IF(entity='KB',READING,0)) AS KB, SUM(IF(entity='V1',READING,0)) AS V1, (SUM(IF(entity='KS',READIN...

 
@bluefeet hey ... they're from Denver.
 
@swasheck those darn Denver sqlers
troublemakers
 
5:35 PM
bunch of jackwagons if you ask me
 
5:54 PM
@AaronBertrand you're a parallels person, yeah?
Hmmm why can't I delete that now that I've changed my mind
 
@billinkc yes
 
6:11 PM
Someone was asking about using mac virtualization technology from a windows admin perspective. Thought you said you set up your AGs in parallels and then I gave up caring
caring about responding to their tweet. I care about you
 
i've been staring at this error
what am i missing
Schema Creation Failed: There are no primary or candidate keys in the referenced table 'dbo.weight' that match the referencing column list in the foreign key 'FK__buMetricW__weigh__0EA330E9'.:
 
@FreshPrinceOfSO are you trying to create a foreign key?
 
@FreshPrinceOfSO you are referencing weight instead of weightid
REFERENCES dbo.[weight] ([weight])
 
eff me
<3 you
 
6:16 PM
Should be REFERENCES dbo.[weight] ([weightId])
@FreshPrinceOfSO aww
 
@Lamak i'll buy a non-alcoholic beer next time I'm in Chile
 
@FreshPrinceOfSO Sounds good enough, I'll remember it
 
@billinkc Oh I haven't been brave enough to try to set up AGs using Parallels. The networking / domain requirements seem to be a little much for me.
 
@Lamak everyone on here will remember for you if you forget
 
6:28 PM
@FreshPrinceOfSO Good, good
@AaronBertrand hadn't read that
@AaronBertrand who is choosing hte "off topic" reasons list on DBA?
 
@Lamak don't know, just saw that this morning.
 
@AaronBertrand That seemed the only valid reason to close too basic questions.
 
@AaronBertrand oh, ok. And do you know what option we should use when we are closing syntax errors and similar questions?
"Read the manual", "How do I group by this list of columns?", etc questions
 
@Lamak I think I will push for "off-topic: too basic" tbh :-)
Though maybe a little more kid-glove-y
 
@AaronBertrand All looks like "good stuff"
 
6:40 PM
@MarkStorey-Smith except for the lack of an RTFM close reason
 
pardon my ignorance, but will DBCC TRACEON generate output in a SQL Agent Job?
 
@swasheck any outputbuffer message that comes from print, raiserror, ansi_warnings, etc. will show up in step history. However, you can say DBCC TRACEON(...) WITH NO_INFOMSGS; to suppress them.
NO_INFOMSGS does not work for all DBCC commands/output, and there is still no way to suppress warnings like the ones from sp_rename ...
 
@AaronBertrand that's what i thought but i didnt want to look like a moron for suggesting to trace a backup in an agent job
 
Oh so you want the error message.
 
well i'd like the info messages
 
6:47 PM
Unless you're using a TF 3226 to suppress them, won't successful backup messages be in the error log already? Why do you need them in agent history too?
 
@swasheck piece of advice, don't refrain giving ideas even if you might "look like a moron". Not having any idea would be entirely moronic ;).
 
@AaronBertrand looking to get the specific details of each step in the backup process to see where the pain is.
 
@swasheck which TF will you use for that? And I assume more than just WITH STATS = 10 kind of "step"
 
@AaronBertrand just reading through this
(though the example is for restore it reads as though it will log more info for the backup process as well)
 
TF 3213? I'd be careful:
WARNING: This trace flags should be used under the guidance of Microsoft SQL Server support. They are used in this post for discussion purposes only and may not be supported in future versions.
 
6:52 PM
@Marian hah. thanks. however, i think i'm making myself look like a moron in here (which is fine because being on the heap doesnt pay my bills)
 
TF 3004 isn't documented here so I'd only use this as a temporary troubleshooting measure...
 
testing it yields fat lot of nothing so oh well
 
@swasheck no, compared to Aaron or Paul or the other gawds many of us look like morons. But we still do our jobs :). So don't be ashamed of asking or giving ideas. To us or to your boss. Just speak loud and clear. That's why I love @jcole's way of rubbing a duck when he needs one.
 
the duck is made of rubber
I rub nothing
NOTHING
 
someone's ears were burning
 
6:55 PM
Though it is documented here and here and so is 3014
 
WARNING: This trace flags should be used under the guidance of Microsoft SQL Server support. They are used in this post for discussion purposes only and may not be supported in future versions.
 
Yep, I already said be careful (and copied exactly that text), just saying, if Microsoft blogs about them, they're essentially supported and they can't take them away.
 
@jcolebrand rubber-ducking! pardon me, sir!
 
You may also be interested in 3213 and 3042
 
@AaronBertrand yes you did. just noting that the message was heard
@AaronBertrand thanks!
wait
AWESOME
Message
慂正灵慄慴慢敳退%s : Log files done
 : Log files done
@AaronBertrand thanks so much for your help.
 
7:07 PM
@swasheck Yong Ling Li deterrence is slow Ai retreat
 
@Lamak you translated that?
 
@swasheck yeah, that's what google translate said to me
 
would asking about that on dba.se be off-topic?
 
@swasheck asking what? The translation?
 
@AaronBertrand yeah ... what that should be and why it appears that way. seems more of an amusement than anything else.
so probably OT
 
7:13 PM
@swasheck I thought that the translation was clear enough
 
@swasheck must be regional settings or something
 
@Lamak that's because you're brilliant
 
you need to retreat....because you are slow
 
i am definitely slow. the derp is strong with me
 
And, for a breath of fresh air on SO, an actual well written question:
1
Q: Select Promotional Price

chiefGuiThe goal Get the lowest price of a product. The problem To illustrate my problem: Row 1 Product_Id = 1 Product_Name = "iPhone 5" Market_Name = "Walmart" Product_Original_Price = "359.00" Product_Promotional_Price = "319.00" Product_State = 1 (is on offer) Row 2 ...

 
7:18 PM
@AaronBertrand You had to ruin it for me
This only works if the value has only changed once. — Aaron Bertrand 59 secs ago
 
Did you pick your username on a similar basis? — Martin Smith 5 mins ago
always thought of that when seeing his username :)
 
@KennethFisher not specifically with OVER. Like anything else, query constructs depends heavily on the underlying schema / indexes to work correctly. An over clause that partitions will suffer the same problems as a GROUP BY. — Aaron Bertrand 2 mins ago
long, slow clap
 
7:35 PM
@bluefeet sorry about that. :-)
@Lamak oh but those big 80 pt fonts
 
@AaronBertrand yup, I was tempted to edit that out. Still, he then modified an answer instead of saying "doesn't work", so I'm willing to still like the question :-)
 
So is a misspelling in the title of a question still a "trivial, tiny one-letter edits"? twitch
 
@AaronBertrand of course now that I edited mine, I see that yours is similar just with windowing functions
 
@SQLFox broken glass is broken glass. Clean the site as you see fit. If it's detrimental to your experience after doing so, well, high value users who are inhibited from using the site are backed up with data.
 
@Marian they are on twitter as well with the same handle
 
7:51 PM
@jcolebrand ....I don't get what you are saying here....maybe a language thing?....Can you clarify so I know how to deal with one letter misspellings edits?
 
@Lamak if you are making the site a better place, and because of that you get penalized, tell me.
 
@billinkc ha, thanks :).
 
You should never get penalized for making the site better, even if it is minor edits
 
@jcolebrand oh, ok, thanks :-)
@jcolebrand since I haven't really edited "one letter misspellings" I thought that @SQLFox meant that he couldn't do it, not that he got penalized
is there a technical restriction for those edits?
 
I was going to, until I saw the warning. And since my edits still require someone else to approve them, I can understand not wanting to bog everyone down with trivial nonsense. `s all good--author fixed it already anyway.
 
7:57 PM
@Lamak oh, well, yes. You can't edit free-style without a certain amount of rep. Then you have to have approval for your edits. But titles should be editable. If the ONLY error is a single character out of place, then bring it to chat. But if one is wrong, often MANY things are wrong.
@SQLFox the others get rep for approving your edits, I believe ;-)
I'm pretty sure I don't get rep from anything anymore ;-)
 
@Lamak 6 characters I believe (though not sure that applies to title)
 
ok thanks. Then, bring it to the mods!
 
I would like to see an example that a <2k rep user finds a post that the ONLY thing wrong with it is a single misspelled word in the title, and everything else is perfect?
 
@jcolebrand I can post a question like that if you really want :-)
 
@jcolebrand probably few and far between. Especially one that a <2k rep notices before anyone with the ability to just clean it up much more quickly.
 
8:01 PM
In this instance, it was a typo from an editor who already cleaned up the rest of the post :P
 
Well if you are restricted by editing limitations, as jcole said, feel free to bring it here, plenty of folks who can bypass those limitations.
 
I think it would let me, just wanted to check etiquette. FFR, how does one link to a question in chat?
 
@SQLFox Just copy the url
 
and paste it here
 
Paste it on its own, then it will onebox.
5
Q: Trying to find the last time that a value has changed

SqlSandwichesI have a table that has an ID, a value, and a date. There are many IDs, Values, and dates in this table. Records are inserted into this table periodically. The ID will always stay the same but occasionally the value will change. How can I write a query that will give me the ID plus the most rec...

If I paste it into a comment with other text, it won't do that: dba.stackexchange.com/questions/44784/…
 
8:07 PM
@SQLFox or use the markup language and you'll link inside a word :)
[ word ] ( link ) <- the only markup tags I know by heart
 
and NOW I see the "help" link at the bottom of the page...was looking everywhere else. thanks folks.
 
@AaronBertrand So is is possible to solve that question using cross apply or was I completely insane to try that?
please vtc
0
Q: Accomplishing MYSQL's Group_Concat in MSSQL

What have you triedI'm porting an application I originally wrote to run on Apache using PHP and a MYSQL database. One of the queries used the MYSQL functions of Concat_WS and Group_Concat to first concatenate a few different columns into one string, and then concatenate all items that were grouped together by the G...

 
@bluefeet I think it's possible but certainly not intuitive IMHO
 
@AaronBertrand that is why I gave up and went with aggregation
I have been looking at it but it is distracting me from my job. I will have to look later
 
I started investigating the repeating value problem but prior to SQL 2012 I think it gets very complicated quickly - gaps and islands with a twist
 

« first day (896 days earlier)