« first day (385 days earlier)      last day (4779 days later) » 

jcolebrand
jcolebrand
04:40
@NickChammas when you're about tomorrow ... since I'm headed to bed
11 1
normalization
3 1
normalization
should both show as unregistered when you goto their page. I can't do anything about those, until one is registered. You should be able to see that. The corrective action in the future is to ask them to register one or the other account. I've got to refresh my memory how that is done (create an OpenID? actively login? I forget) but for now, goodnight all
 
1 hour later…
Nick Chammas
Nick Chammas
05:52
@jcolebrand ah ok; I didn't check
 
2 hours later…
deostroll
deostroll
07:34
Hi. I have a primary key int field on one table in sql server...can I alter that column and make it an identity column?
 
4 hours later…
gbn
gbn
11:08
@NickChammas of The Sun?(NSFW)
 
1 hour later…
Martin Smith
Martin Smith
12:09
@JNK That's because it doesn't have to do a sort isn't it?
@JackDouglas SQL Server does not implement any facility to seek directly to the next distinct value in an index skipping duplicates along the way. I thought that was what the skip scan did in Oracle. Guess I was wrong about that then? For SQL Server if there are lots of duplicates then a recursive CTE can be faster (repeated index seeks) as @Sqlkiwi illustrates on this post sqlservercentral.com/Forums/FindPost1013407.aspx
 
2 hours later…
JNK
JNK
13:48
@MartinSmith I think it's sort-related, yes. the point is having an index on the appropriate keys does make a positive impact.
Mark Storey-Smith
Mark Storey-Smith
14:20
@JNK re: dba.stackexchange.com/a/11459/2374 Cost percentages in a plan are always "estimated costs". There is no relation to the resources incurred.
JNK
JNK
@MarkStoreySmith - yep I know they are all estimates. However there is a unit based on some combination of resource usage (estimates).
Mark Storey-Smith
Mark Storey-Smith
@JNK My suggestions is to clarify that the costs are estimated, rather than being an indication of the actual costs incurred when running the query and seeing an "actual plan". Your answer reads (to me) that the percentages are a reflection of the actual costs incurred to run the query. If you see what I mean :)
JNK
JNK
Gotcha, I'll take a look.
take a gander at the revision and make sure it's clear
Mark Storey-Smith
Mark Storey-Smith
@JNK All good!
JNK
JNK
thanks for catching that
Ben Brocka
Ben Brocka
14:45
Good news! The vendor database removed all default values so none of our insert statements work :D
I think these guys aggressively hate data integrity
Ben Brocka
Ben Brocka
15:23
Is there like a best-practice way to add an index on a huuuuge table in production? I need to add an index that takes half an hour and at some point I need to move it into production. Best thing I can think of would be to schedule adding it on the weekend when the system isn't in use, that's when we run backups and such...
Ben Brocka
Ben Brocka
15:41
Crisis averted, the index doesn't help anyway. Which brings me to a better question...how the hell can a SELECT query get 4x slower after adding a non-clustered index? I thought only DML queries got slower
Mark Storey-Smith
Mark Storey-Smith
@BenBrocka If the optimiser thinks it will be faster to use the index... but it isn't
Does the execution plan show it being used?
Ben Brocka
Ben Brocka
Eff, I already deleted the index and closed the window with that execution plan. It was an index suggested by SSMS. It obviously wasn't helpful. The execution plan w/ the suggested index had much fewer steps but I didn't notice what it was doing
I'm curious but don't really want to wait another 30 minutes to generate the index again
Jack Douglas
Jack Douglas
16:07
@MartinSmith a skip scan does something like the opposite - matching on non-leading fields. Thanks for the link - Paul's post does something similar to what I do with a subquery in the select - force multiple 1-row range scans. Seems like a fairly cheap optimization for the DB to save the hassle though I wonder why they haven't implemented something like it internally.
gbn
gbn
@BenBrocka do you introduce a key lookup? That is, the NC index is not coverng?
eg stackoverflow.com/questions/1395275/…
Nick Chammas
Nick Chammas
@gbn No, but I hear there are some fun WTFs in that paper too.
Ben Brocka
Ben Brocka
Should be covering I think...between ON and INCLUDE it covers all relevant columns
Alex Mathew
Alex Mathew
16:31
@jcolebrand : hi. why u ping me?
Martin Smith
Martin Smith
@BenBrocka Maybe there is some correlation with your statistics that does not fit the optimizer's assumptions, for an example see
6
Q: SQL why is SELECT COUNT(*) , MIN(col), MAX(col) faster then SELECT MIN(col), MAX(col)

CodingBarfieldWe're seeing a huge difference between these queries. The slow query SELECT MIN(col) AS Firstdate, MAX(col) AS Lastdate FROM table WHERE status = 'OK' AND fk = 4193 Table 'table'. Scan count 2, logical reads 2458969, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical rea...

sql sql-server performance statistics correlation
@JackDouglas Thanks for the clarification on the skip scan.
Although actually the issue on that one was key lookups. If you want to generate the execution plan without actually building the index you can do some experimentation with hypothetical indexes and DBCC AUTOPILOT
Ben Brocka
Ben Brocka
16:47
@MartinSmith Unfortunately I have other stuff to work on right now. Interesting though.
Thanks
jcolebrand
jcolebrand
17:15
@AlexMathew I have no clue. Was it in here? Let's review the backlog
Jan 19 at 21:04, by Nick Chammas
what would be appropriate protocol? ask if he's interested in funneling people here?
Nick Chammas
Nick Chammas
17:34
@AlexMathew - We noticed you are the owner of the MySQL chat room on SO and wanted to let you know we have a lot of database dev and admin activity in this room. Both you and the regulars of that room are welcome to hang out here.
Ben Brocka
Ben Brocka
And so the DBA vampires set upon their latest victim...
Before long, he would be one of Them!
jcolebrand
jcolebrand
@BenBrocka hehe, yes we are :D
Ben Brocka
Ben Brocka
17:53
@jcolebrand do you know how the mod pro temp "elections" work out for new sites?
jcolebrand
jcolebrand
@BenBrocka yes, and you should too sir :p
it's outlined in the 7 meta Q
basically, you need to have a post nominating yourselves as a CW
one person, one answer
then the answers can be upvoted
then you approach rchern or someone and say "please make us pro-tems" but they'll do that about 3-4 weeks in
once you go pubbeta, that's when you need the meta Q
I wouldn't make it during privbeta, you need to sort out that loose cannon and delete more lousy Q
Ben Brocka
Ben Brocka
Was thinking it was something we do at the start of public beta (so 3-4 weeks is the length of private beta?)
jcolebrand
jcolebrand
nah, a privbeta is as long as it needs to be to show a concise vision of what the site is about
pubbeta is as long as it takes to prove the site will have people coming back
Ben Brocka
Ben Brocka
Ah. Currently I think we (cog sci) need more, better questions per day, activity has dropped off. We've dealt with most of the worst of the "spammed" questions...
jcolebrand
jcolebrand
Aye
now you need to get good content from reputable sources
Josh is one of my buddies, we skype a lot
so I know all about cogsci ;-)
 
1 hour later…
Ben Brocka
Ben Brocka
19:03
Unfortunately we don't seem to have all that many experts or practitioners in the field
jcolebrand
jcolebrand
0
Q: Data uploading from excel to database

samarI have one excel file which is updated daily, and I have to update the records in database(sql server 2005) daily. What will be the query to fetch data from excel and update on database? e.g the table structure like: Empid EmpName Emp.Des 001 Robert Engineer 002 Philip Trainer 003 J...

sql-server excel
this is pretty basic isn't it?
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@jcolebrand Yes. It could live on SO or B.I. enabled dba.se equally well but probably not much to be gained from migrating it.
Ben Brocka
Ben Brocka
@jcolebrand Do you have any experience with private betas?
Nick Chammas
Nick Chammas
20:07
5
A: Community Promotion Ads - 4Q 2011

Grace Note

needs one more vote to make community ad
Simon Righarts
Simon Righarts
20:21
@NickChammas done
Nick Chammas
Nick Chammas
20:40
@SimonRigharts Bam. Ad now shows up on main site. Sank yuu.
Ben Brocka
Ben Brocka
@NickChammas Allegedly UX has had success with that style of ad
Nick Chammas
Nick Chammas
@BenBrocka success, as in lots of twitter followers?
Ben Brocka
Ben Brocka
@NickChammas as in a fair amount of followers considering the size of the community
We discussed it's CTR and it seemed sort of tepid but I have no idea what to compare the CTR to, it's got an okay number of followers for a smaller site though, 450
Nick Chammas
Nick Chammas
CTR?
Ben Brocka
Ben Brocka
Twice as many as @stackDBAs though I';m not sure how level the playing ground is
Click Through Rate, people that clicked the ad divided by total impressions
Nick Chammas
Nick Chammas
20:55
@BenBrocka well, our ad just started showing 5 min ago :)
if that's a significant source of followers, then...
Ben Brocka
Ben Brocka
Problem is we don't have a method to track conversion rate; #/% of people who actually clicked through AND followed because of the ad
Nick Chammas
Nick Chammas
-1
Q: Attach database failed for server localhost\sqlexpress2009 (Microsoft.SqlServer.Smo)

user1161815Getting access denied when trying to attach AP.mdf. I can see the files at the bottom of the screen. Error is: Unable to open the physical file "C:\Murach\SQL Server 2008\Database\AP.mdg". Operating system error 5: "5(Access is denied.)". Microsoft SQl Server, Error 5120)

sql-server sql-server-2008
@jcolebrand @gbn @MarkStoreySmith VtC as too localized.
@BenBrocka yah, that would require some sort of feed from twitter
Ben Brocka
Ben Brocka
@NickChammas I think you might be able to track that if you use a "follow" button directly but I don't know if we can make a link do that
How long has DBA been around, counting public beta?
Nick Chammas
Nick Chammas
13 months?
dba.stackexchange.com/badges/52?page=2
a whole bunch of people got yearling badges this week
all of them members for 1 year
so probably 12-13 months
those people also have the Beta badge
Ben Brocka
Ben Brocka
Hm, we've been around longer and have 40% more users, so I'm not sure I could attribute the difference to the ad
Er, not 40%, like 60%. Some number
Simon Righarts
Simon Righarts
21:13
Is it worth posting questions if I'm almost certain I won't get an answer?
Thinking about putting one up about sub-optimal query plan selection in Sybase
Nick Chammas
Nick Chammas
@SimonRigharts if it's an appropriate question then fire away
Ben Brocka
Ben Brocka
Depends why you don't think you'll get an answer. But if it's a real, on topic question I would post it and let the community figure out
You'll never know, nor will we, until you ask it :)
Nick Chammas
Nick Chammas
you can then share the post with anybody who might be able to help
potentially recruiting a new Sybase DBA.SE person
Simon Righarts
Simon Righarts
That's the annoying part - the only person I know who might be able to help charges $150/hour :v
(the reason I don't think I'll get an answer is because I seem to be the only person answering Sybase questions, and the question I have in mind is along the lines of forcing specific operators in a query plan)
Nick Chammas
Nick Chammas
does sybase have query hints?
in any case, we might be able to give the general advice, and you'll only need to look up the syntax
Simon Righarts
Simon Righarts
21:21
yes it does, up to a point
the other thing is that, since it's a performance issue, the problem doesn't really manifest until you get to a non-trivial data set size
(the problem tables in this query are 90 million rows, 60 million rows and 100 million rows, collectively weighing in at 60GB of data)
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@SimonRigharts Do you have a mirror or prod support box you could test it on?
Ben Brocka
Ben Brocka
@NickChammas We could really (apparently) use some of those. I don't know of any other users that know it
Simon Righarts
Simon Righarts
well we have like 30 copies of this database all up, so yeah I have test boxes coming out my eyeballs
2
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
Maybe you could frig the indexes and hints on one of the test environments.
jcolebrand
jcolebrand
22:12
@NickChammas I am tempted to leave it open as a valid troubleshooting Q. I'm just one man, however, and not perfect.
@BenBrocka I participated in this one? I've been on metaso for ages? I was in a couple other that I couldn't commit to as well as I liked?
Ben Brocka
Ben Brocka
22:38
@jcolebrand I see. I'm just trying to think How I can help the community along in the beta. I've done lots of community moderating clean up stuff but I don't know how I can help us get people more active
jcolebrand
jcolebrand
@BenBrocka get out of privbeta?
or did it go to pubbeta?
Ben Brocka
Ben Brocka
We're still in private beta, just a week old now
Nick Chammas
Nick Chammas
@jcolebrand okie doke
@jcolebrand Why are these all questions?
:P
Ben Brocka
Ben Brocka
Maybe he's a teenage girl? And he has inflection like a question? To the end of all his statements?
Nick Chammas
Nick Chammas
22:53
LOL
yes, that's what I was getting at
looking at your profile @BenBrocka, you must know a few too :)
Ben Brocka
Ben Brocka
Not as many since I gradumatated. And most people where I work are over 40...it's weird
Nick Chammas
Nick Chammas
yah, that was my first job too
big financial services company
people there had kids my age
Ben Brocka
Ben Brocka
> Children with this condition often suffer oral cavity damage both in and around the oral cavity (such as having bitten off the tip of their tongue)
Oh the things I learn from the Cognitive Sciences site
Simon Righarts
Simon Righarts
23:44
Was my comment on this question too harsh? dba.stackexchange.com/a/11500/3761
if he'd spent a hot two seconds looking at the link already provided he would've seen what he's looking for

« first day (385 days earlier)      last day (4779 days later) »