I imported the Stack Overflow data dump into SQL Server 2008. Some queries, especially on the Posts table, are taking more than a minute to return.
Example query:
SELECT
Id, PostTypeId, AcceptedAnswerId, CreationDate,
Score, ViewCount, Body, OwnerUserId, OwnerDisplayName,
LastEditorUserId, LastEditDate, LastActivityDate, Tit...
There are classes:
InterfaceInterval<C extends Comparable<C>, I extends InterfaceInterval<C, I>> extends Comparable<InterfaceInterval<C, ?>>
AbstractInterval<C extends Comparable<C>, I extends AbstractInterval<C, I>> implements InterfaceInterval<C, I>, Serializable, Cloneable
AbstractTimeInterval<I extends AbstractTimeInterval<I>> exten...
Hi everybody
I work in an enterprise designing, creating and maintening custom applications on the base of ESRI ArcGIS. Some customers use Direct Connect, to connect to databases stored on Oracle or MS SQLServer. I have a problem with a standalone application for several months now.
I have an application, written in Delphi. One of ...
Hi there
I am getting a StackOverflow Error in this code:
EDIT
[XmlAttribute("ID")]
public string ID { get; set; }
EDIT2
public ParameterEntity this[string szID]
{
get
{
//Finds the parameter entity with the ID passed in.
return rParameters.Find(
delegate(ParameterEntit...
Hello,
I'm interesting in creating a web site similar to stackoverflow. As I'm usually interested in OSS I'd like to know if someone knows about the existence of other Q&A sites whose sources are licensed under an open-source license (not interested which license as long as I can use it - GPL, Apache, BSD, MIT ...).
Thank you,
Iulian
...
EDIT: Just to make things clear, this problem was caused by a typo in my code,
in
pointer = new BYTE(datasize);
should have been
pointer = new BYTE[datasize];
All is well!
END
Hi!
I'm having a weird stack overflow problem in Visual Studio 2005 in a C++ project..
In my code, I have a
BYTE* pointer;
This pointer is set to NU...
It sure looks innocuous enough. In my App Delegate, I check NSUserDefaults for a flag to show tips at startup. If it’s set then, at the end of applicationDidFinishLaunching:, I do this:
TipsViewController *vc = [[TipsViewController alloc]
initWithNibName:@“TipsView" bundle:nil];
[window addSubview:vc.view];
[vc release];
The idea is...
This has completely baffled me on a number of configurations. I keep reading the documentation, and I just don't get it. Here is my registration code:
ForRequestedType<SimpleWorkItemProcessor>().TheDefault.Is.OfConcreteType<SimpleWorkItemProcessor>();
ForRequestedType<WorkItemRetryProcessor>().TheDefault.Is.OfConcreteType<WorkItemRetry...
I'm building a small Stack Overflow application, but to collect information from Stack Overflow about a user I need to know their UserID. I would like the user to be able to enter their display name/username and for the application to find their UserID. However, I understand that usernames are not unique, but would it be possible to find...
I dont even know what caused it in my application. What is it? I created a new instance of a class (the class was in another file), but at the first time I call a method it throws a StackOverFlow exception.
The only thing that I think would logically throw a stackoverflow exception would be if someone downvoted Jon Skeet.
But seriously...
I have created a custom allocator/presenter that works fine for playback of normal media files. However, when I use the following code to try to playback a DVD, it fails with a stack overflow exception.
vmr9_ap = new vmr9ap();
HMONITOR monitor = MonitorFromWindow(hwnd, NULL);
IGraphBuilder *graph;
IBaseFilter *filter;
IDvdGraphB...
After downloading the September 2009 StackOverflow data-dump and running Brent's import query, I'm getting the following message:
Msg 7119, Level 16, State 1, Procedure sp_xml_preparedocument, Line 1
Attempting to grow LOB beyond maximum allowed size of 2,147,483,647 bytes.
Msg 8179, Level 16, State 5, Procedure usp_ETL_Load_Posts, Line...
Right now while I'm typing this theres the preview down below the editor. I would like to do something similair and am wondering how Stack Overflow does this? Thanks!
...
I am currently reading several security books(my passion) regarding secure programming, however either the distro's they provide on disc are faulty, or non-existent.
Books:Hacking The art of Exploitation 2nEd, Grey Hat hacking 2nEd
The issue is that when i try to follow the examples, obviously newer distros have stack protection and othe...
I've been trying to find an answer to this question for a few hours now on the web and on this site, and I'm not quite there.
I understand that .NET allocates 1MB to apps, and that it's best to avoid stack overflow by recoding instead of forcing stack size.
I'm working on a "shortest path" app that works great up to about 3000 nodes,...
I'm looking for a way to mirror text (like how SO provides a preview of the text being entered, as its being typed). I also need to be able to modify the texts output environment (whether it be a textbox/messagebox/ect.) for background/text color (selected from a dropdown menu). Suggestions on the best way to go about this? FYI I'm using...
function paginator($totalPages,$currentPage)
{
if($currentPage > $totalPages)
return false;
$aheadmin = max(1,$currentPage - ($totalPages - $currentPage > 3 ? 2 : (5 - ($totalPages - $currentPage) -1)));
if($aheadmin - 1 > 1)
{
$str = '1 ... ';
$aftermax = min($currentPage + 2,$totalPages);
}
else ...
I have the following code sample to illustrate my point. When I load this in IE8 on Vista I get the error "Stack Overfow at line:16"
If I recurse using a top level function (outside of the testClass object) I can recurse millions of times without a stack overflow.
Why is this happening? Ultimately I just implemented a Function Que ins...
How is the Community member/account of StackOverflow work in terms of the ID being -1? Is it in the database? If not, how is it represented in code - is it a special instance of an account?
I am not looking for delving out privileges.
I want to replicate this so that my application has special "groups" that are defined in code and not ...
When I use PropertyInfo.SetValue in asp.net , it throws a stackoverflow exception.
That I write this code:
for (int i = 0; i < rivalSeriesIDList.Count; i++)
{
cardb_series rivalSeries = seriesBll.GetSeriesInfoByID(rivalSeriesIDList[i].ToString());
this.GetType().GetProperty("brandid" + (i + 1)).SetValue(this, riv...