@AaronBertrand This is why, a long time ago, I asked on Meta.SO for the ability to follow people. There are some folks whom I just really would love to follow for the sake of their content.
Quora is a social network first, a discussion platform second and a Q&A site third. It is not about answering questions so much as following famous people and seeing them give pithy (and often useless) answers to popular questions
Basically Quora is a great place to follow celebrities and see what they find interesting and read their answers. It is a horrible place if you have a question you want answered
SE's sorting methods ensure new and unanswered questions float to the top, emphasizing solving problems. We strategize for the long tail of search terms from people also looking for answers. Quora's sorting is completely dominated by your friends/followings activity, so unanswered stuff is basically invisible
@swasheck I don't know honestly, I found Quora late last year, it's always been like that in my experience
If you have a request for our blogoverflow blog (http://dba.blogoverflow.com) then please put them here, one per "answer", and someone will work on a blog entry on it, I'm sure.
Also see:
Our blog is set to launch this week! (Feedback here please!)
I'm using SQL Server 2008 R2.
I would like to sort a table by a specific order which I hold as a string.
(the string is created programtically)
Consider this table named myTable
Col1 Col2 Col3
1 Jon a
2 Joan b
3 John a
4 Jonnie b
5 Jonny a
I ...
I've got a list of ledger account numbers. These numbers go like this:
5 (main account, #5)
501 (sub account of main account 5, #01)
50101 (sub account of this account, #01)
etc.
So if I have a list and want to order this by account number, then I'd like to create this order:
5
501
50101
50...
Why is SQL integral numeric column (for example NUMERIC(3,0)) generated in C# (in DataSet
as column type or in DataAdapter as parameter type) as type Decimal?
NUMERIC(3,0) can store integral values in range of -999 to 999. I think it should be in C# generated as type int or another integral one...
I have this query that I want to use as a stored procedure:
SELECT ISNULL(P.firstname, s.firstname) AS Expr1,ISNULL(P.lastname,
s.lastname) AS Expr2 FROM comment AS C LEFT OUTER JOIN professor AS P ON P.ID =
C.PID LEFT OUTER JOIN student AS s ON s.ID = C.SID
WHERE (C.VID = @VID)
i...
I know how to override the language chosen, and I believe that the chosen language is driven by the tags. I'm not asking for So if a question is tagged C#, and I want to post a SQL Server stored procedure, I use the following before my code block, and the syntax highlighting obeys the language I...
If a tag starts with sql-server* why would the right language be anything other than sql?
I think the algorithm looks at exact matches, and sql-server-2008-r2 hasn't been added. I don't think the wrong language was chosen in this case, I think the search was exhausted.
@AaronBertrand Aye, it decided to disable prettify for that question because the syntax highlighting setting for that tag is null (the default value). Easy enough to change though, and I don't see any particular reason to object to doing so.
@TimStone thanks Tim. I updated my meta question to also include a request for wildcard. It seems sql-server-2008 worked but sql-server-2008-r2 did not. And I suspect sql-server-2012 will not as well, and that when SQL Server 2015 is released we'll have the same symptom again.
@ypercube 99% of answers to questions that are tagged only with some sql-server-* tag are going to include only sql code samples, or a mix of sql and other.
Yeah, at the moment it's done on a per-tag basis because the algorithm tries to pick a specific language when possible, and defers to prettify to decide on its own when there's some conflict. While this case is pretty clear-cut, I imagine there are some other circumstances where specifying the language using a pattern might result in more conflicts than intended (the whole idea here being to avoid that where possible since Prettify doesn't always get things right)...
...but admittedly I haven't thought about it that much to say for certain.
@TimStone: Now that you are here, I have another question for you: Has what you see when clicking on the "StackExchange -> all sites" been changed recently?
The ordering seems different than it used to be yesterday.
Totally kidding, of course. But I do think there are some tag families where a regex match would be feasible and unlikely to cause conflicts (e.g. sql-server*). I think there is still room to put the algorithm in place in that case which still might decide that C# should be the language because C# is the more popular tag. And those cases will win out more often against SQL Server if it's based on a specific tag like sql-server-2008-r2.
It's a shame @jcolebrand didn't make it to the final stage of the Stack Overflow elections, since barring a change to the application, you could have made staying on top of new tag additions his job ;)
@ypercube I have no idea, but you're referring to the drop down? It should be the list of sites where you're a member, ordered by reputation (down to 200), and then random after that point.
Seems fine for me at the moment, but there was some trouble with the API today that would have likely caused it some issues in determining what reputation you had on which site to influence the order.
I stopped using Firefox two weeks ago. Too many funky things - wasn't loading remote javascript, remote CSS, etc. Half the web sites I went to looked like garbage.
Refresh sometimes worked. But even images would be missing. Switched to Chrome. It has some funky behaviors too but when a web site loads it's all there.
Perhaps the all sites list is re-ordered using a <script src> tag that isn't loading correctly.
Do you notice other things anywhere, like missing images, or Times New Roman on sites that shouldn't be using it?
Usually I expect updates to fix things, not break them more. So you've convinced me to put off trying FF again for at least a couple more updates. :-)
The deal breaker was broken functionality on my bank's web site. Which they could probably fix, but it worked on Firefox previously, and continued to work fine on Safari and Chrome (Mac) and IE on Windows. Only Firefox on both platforms was broken in the same way.
Chrome does that for me quite a bit. Mostly when clicking back.
spin... spin... spin
I also don't like that it is very aggressive in caching. I see updates pop into a question, click on a link, click back, and the updates are no longer showing. I have to manually hit refresh, like I did back in the 1990s.
This is on a Mac, behavior might be different on a pee see.
If you have a request for our blogoverflow blog (http://dba.blogoverflow.com) then please put them here, one per "answer", and someone will work on a blog entry on it, I'm sure.
Also see:
Our blog is set to launch this week! (Feedback here please!)
I'm using SQL Server 2008 R2.
I would like to sort a table by a specific order which I hold as a string.
(the string is created programtically)
Consider this table named myTable
Col1 Col2 Col3
1 Jon a
2 Joan b
3 John a
4 Jonnie b
5 Jonny a
I ...
I've got a list of ledger account numbers. These numbers go like this:
5 (main account, #5)
501 (sub account of main account 5, #01)
50101 (sub account of this account, #01)
etc.
So if I have a list and want to order this by account number, then I'd like to create this order:
5
501
50101
50...
Why is SQL integral numeric column (for example NUMERIC(3,0)) generated in C# (in DataSet
as column type or in DataAdapter as parameter type) as type Decimal?
NUMERIC(3,0) can store integral values in range of -999 to 999. I think it should be in C# generated as type int or another integral one...
I have this query that I want to use as a stored procedure:
SELECT ISNULL(P.firstname, s.firstname) AS Expr1,ISNULL(P.lastname,
s.lastname) AS Expr2 FROM comment AS C LEFT OUTER JOIN professor AS P ON P.ID =
C.PID LEFT OUTER JOIN student AS s ON s.ID = C.SID
WHERE (C.VID = @VID)
i...
