Try this

    use dasolPSDev;
    
    EXEC sp_configure &#39;clr enabled&#39;, 1
     go
     RECONFIGURE
     go
    EXEC sp_configure &#39;clr enabled&#39;
     go

Simplified version of jams&#39; solution which worked for me (SQL Server 2012):

    sp_configure &#39;clr enabled&#39;, 1
    GO
    RECONFIGURE
    GO

Source: http://msdn.microsoft.com/en-us/library/ms254506%28v=vs.80%29.aspx

I had a similar issue, but this works for me (SQL Server 2008 R2):

    sp_configure &#39;clr enabled&#39;, 1
    GO

    RECONFIGURE
    GO

I tried with 
sp_configure @configname=clr_enabled, @configvalue=1

then restarted the sql server. it worked


I&#39;m using the `org.apache.http.HttpResponse` class in my Java application, and I need to be able to get the HTTP status code. If I used `.toString()` on it, I can see the HTTP status code in there. Is there any other function that I can just get the HTTP status code as either an int or String?

Thanks a bunch!

Get HTTP code from org.apache.http.HttpResponse

Like so:

    if (fcntl(fd, F_SETFD, FD_CLOEXEC) == -1) {
    ...

Though I&#39;ve read `man fcntl`, I can&#39;t figure out what it does.

What does the FD_CLOEXEC fcntl() flag do?

I am getting the following error on my new installation of ASP.Net and SQL Server when I run my app:

     Execution of user code in the .NET Framework is disabled. Enable &quot;clr enabled&quot; configuration option


I have tried to fix it by running this:

     use dasolPSDev;

     sp_configure &#39;clr enabled&#39;, 1
     go
     RECONFIGURE
     go
     sp_configure &#39;clr enabled&#39;
     go

But then I get:

     Msg 102, Level 15, State 1, Line 3
     Incorrect syntax near &#39;sp_config


ASP.NET CLR Not Enabled

I am getting the following error on my new installation of ASP.Net and SQL Server when I run my app:
<pre><code class="hljs language-vbnet"> Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option
</code></pre>
I have tried to fix it by running this:
<pre><code class="hljs language-go"> use dasolPSDev;

 sp_configure 'clr enabled', 1
 go
 RECONFIGURE
 go
 sp_configure 'clr enabled'
 go
</code></pre>
But then I get:
<pre><code class="hljs language-rust"> Msg 102, Level 15, State 1, Line 3
 Incorrect syntax near 'sp_config
</code></pre>

What is the difference between ASP.NET Web Forms and ASP.NET Web Pages?

[Here][1] it says that Web Pages and Web Forms are different approaches.

  [1]: http://www.asp.net/get-started





ASP.NET Web Forms and ASP.NET Web Pages

I was under the impression they are all basically the same.  Are model objects also the same?


Right now, in my architecture, I have:

    class Person 
    {

        public string PersonId;        
        public string Name;
        public string Email;

        public static bool IsValidName() { /* logic here */ }
        public static bool IsValidEmail() { /* logic here */ }
    }


    class PersonService
    {
        private PersonRepository pRepository;

        PersonService()
        {
            pRepository = new PersonRepository();
        }

        public bool IsExistingEmail(string email)
        {
            //calls repo method to see if email is in db
        }


        public Person GetPerson(email)
        {
            return pRepository.Get(email);
        }


        public void SavePerson(Person p)
        {
            if (Person.IsValidEmail(p.Email) &amp;&amp; !IsExistingEmail(p.Email)
            {
                pRepository.Save(p);
            }
        }

    }


    class PersonRepository
    {
        public void Save(Person p)
        {
            //save to db
        }

        public Person Get(string email)
        {
            //get from db
        }

        public bool IsExistingEmail(string email)
        {
            //see if email in db
        }

    }


So which of the above classes are `POCO`, `Domain Object`, `Model object`, `entity`?

What is the difference between domain objects, POCOs and entities?

I&#39;m using the EPPlus library to read/write Excel files: http://epplus.codeplex.com/

I&#39;m trying to simply merge some cells when writing a document:

    using (ExcelPackage pck = new ExcelPackage())
    {
        //Create the worksheet
        ExcelWorksheet ws = pck.Workbook.Worksheets.Add(&quot;Demo&quot;);

        //Format the header for column 1-3
        using (ExcelRange rng = ws.Cells[&quot;A1:C1&quot;])
        {
            bool merge = rng.Merge;
        }
    }

There&#39;s a property named Merge that simply returns true or false. I thought maybe that would Merge the cells, but it doesn&#39;t.

Anyone know how to do this?

Merge cells using EPPlus?

I have implemented an Ajax request on my website, and I am calling the endpoint from a webpage. It always returns **200 OK**, but **jQuery** executes the error event.   
I tried a lot of things, but I could not figure out the problem. I am adding my code below:

###jQuery Code

    var row = &quot;1&quot;;
    var json = &quot;{&#39;TwitterId&#39;:&#39;&quot; + row + &quot;&#39;}&quot;;
    $.ajax({
        type: &#39;POST&#39;,
        url: &#39;Jqueryoperation.aspx?Operation=DeleteRow&#39;,
        contentType: &#39;application/json; charset=utf-8&#39;,
        data: json,
        dataType: &#39;json&#39;,
        cache: false,
        success: AjaxSucceeded,
        error: AjaxFailed
    });
    function AjaxSucceeded(result) {
        alert(&quot;hello&quot;);
        alert(result.d);
    }
    function AjaxFailed(result) {
        alert(&quot;hello1&quot;);
        alert(result.status + &#39; &#39; + result.statusText);
    }

###C# code for `JqueryOpeartion.aspx`

    protected void Page_Load(object sender, EventArgs e) {
        test();
    }
    private void test() {
        Response.Write(&quot;&lt;script language=&#39;javascript&#39;&gt;alert(&#39;Record Deleted&#39;);&lt;/script&gt;&quot;);
    }

I need the `(&quot;Record deleted&quot;)` string after successful deletion. I am able to delete the content, but I am not getting this message. Is this correct or am I doing anything wrong? What is the correct way to solve this issue?


Ajax request returns 200 OK, but an error event is fired instead of success

How to determine if a string contains a GUID vs just a string of numbers.

will a GUID always contain at least 1 alpha character?

How to validate GUID is a GUID

How to restore a higher version SQL Server database backup file onto a lower version SQL Server?

Using SQL Server **2008 R2 (10.50.1600)**, I made a backup file and now I want to restore it on my live server&#39;s SQL Server **2008 (10.00.1600)**.

When I tried to restore the backup onto SQL Server 2008 it gives an error i.e. `Restore Failed` because:

&gt; The database was backed up on a server running version 10.50.1600.
&gt; That version is incompatible with this server, which is running version
&gt; 10.00.1600.

How do I restore the backup file on this server?

SQL Server database backup restore on lower version

It is possible to create a primary key or unique index within a SQL Server CREATE TABLE statement. Is it possible to create a **non-unique** index within a CREATE TABLE statement?

    CREATE TABLE MyTable(
        a int NOT NULL
        ,b smallint NOT NULL
        ,c smallint NOT NULL
        ,d smallint NOT NULL
        ,e smallint NOT NULL
    
        -- This creates a primary key
        ,CONSTRAINT PK_MyTable PRIMARY KEY CLUSTERED (a)
    
        -- This creates a unique nonclustered index on columns b and c
        ,CONSTRAINT IX_MyTable1 UNIQUE (b, c)
    
        -- Is it possible to create a non-unique index on columns d and e here?
        -- Note: these variations would not work if attempted:
        -- ,CONSTRAINT IX_MyTable2 INDEX (d, e)
        -- ,CONSTRAINT IX_MyTable3 NONCLUSTERED INDEX (d, e)
    );
    GO

    -- The proposed non-unique index should behave identically to
    -- an index created after the CREATE TABLE statement. Example:
    CREATE NONCLUSTERED INDEX IX_MyTable4 ON MY_TABLE (d, e);
    GO


Again, the goal is to create the non-unique index within the CREATE TABLE statement, not after it.

For what it&#39;s worth, I did not find the [[SQL Server Books Online entry for CREATE TABLE]][1] to be helpful.

Also, [[This Question]][2] is nearly identical, but the accepted answer does not apply.

  [1]: http://msdn.microsoft.com/en-us/library/ms174979.aspx
  [2]: https://stackoverflow.com/questions/2689930/how-to-create-nonclustered-index-in-create-table
  

Create a nonclustered non-unique index within the CREATE TABLE statement with SQL Server

I am trying to call a stored procedure from my C# windows application. The stored procedure is running on a local instance of SQL Server 2008. I am able to call the stored procedure but I am not able to retrieve the value back from the stored procedure. This stored procedure is supposed to return the next number in the sequence. I have done research online and all the sites I&#39;ve seen have pointed to this solution working.

Stored procedure code:

    ALTER procedure [dbo].[usp_GetNewSeqVal]
          @SeqName nvarchar(255)
    as
    begin
          declare @NewSeqVal int
          set NOCOUNT ON
          update AllSequences
          set @NewSeqVal = CurrVal = CurrVal+Incr
          where SeqName = @SeqName
         
          if @@rowcount = 0 begin
    print &#39;Sequence does not exist&#39;
                return
          end
     
          return @NewSeqVal
    end

Code calling the stored procedure:

    SqlConnection conn = new SqlConnection(getConnectionString());
    conn.Open();
    
    SqlCommand cmd = new SqlCommand(parameterStatement.getQuery(), conn);
    cmd.CommandType = CommandType.StoredProcedure;
    
    SqlParameter param = new SqlParameter();
    
    param = cmd.Parameters.Add(&quot;@SeqName&quot;, SqlDbType.NVarChar);
    param.Direction = ParameterDirection.Input;
    param.Value = &quot;SeqName&quot;;
    
    SqlDataReader reader = cmd.ExecuteReader();

I have also tried using a `DataSet` to retrieve the return value with the same result. What am I missing to get 
the return value from my stored procedure? If more information is needed, please let me know.

Calling stored procedure with return value

What is a query that will show me the full definition, including indexes and keys for a SQL Server table?  I want a pure query - and know that SQL Studio can give this to me, but I am often on &quot;wild&quot; computers that have only the most bare-bones apps and I have no rights to install studio.  But SQLCMD is always an option.

UPDATE:  I have tried sp_help, but is just yields one record which shows Name, Owner, Type and Created_Datetime.  Is there something else I am missing with sp_help?

Here is what I call:

sp_help airports

Note that I really do want the DDL that defines the table.

T-SQL query to show table definition?

        USE AdventureWorks2008R2;
    GO
    SELECT SalesOrderID, ProductID, OrderQty
        ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS &#39;Total&#39;
        ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS &#39;Avg&#39;
        ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS &#39;Count&#39;
        ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS &#39;Min&#39;
        ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS &#39;Max&#39;
    FROM Sales.SalesOrderDetail 
    WHERE SalesOrderID IN(43659,43664);


I read about that clause and I don&#39;t understand why I need it.
What does the function `Over` do? What does `Partitioning By` do?
Why can&#39;t I make a query with writing `Group By SalesOrderID`?


The SQL OVER() clause - when and why is it useful?

What are the roots in garbage collection?

I have read the definition of root as &quot;any reference that you program can access to&quot; and definition of live is that an object that is being used, which can be a local variable, static variable.

I m little confused with discriminating the difference between root and live objects.

What is path to root? How does root and live objects work?

Can someone elaborate ? 



What are the roots?

Firstly, I apologize for the length of this question. 

I am the author of [IronScheme][1]. Recently I have been working hard on emitting decent debug info, so that I can use the &#39;native&#39; .NET debugger. 

While this has been partly successful, I am running into some teething problems.

The first problem is related to stepping.

Due to Scheme being an expression language, everything tends to be wrapped in parenthesis, unlike the major .NET languages which seems to be statement (or line) based.

The original code (Scheme) looks like:

    (define (baz x)
      (cond
        [(null? x) 
          x]
        [(pair? x) 
          (car x)]
        [else
          (assertion-violation #f &quot;nooo&quot; x)]))

I have on purpose laid out each expression on a newline.

The emitted code transforms to C# (via ILSpy) looks like:

    public static object ::baz(object x)
    {
      if (x == null)
      {
        return x;
      }
      if (x is Cons)
      {
        return Builtins.Car(x);
      }
      return #.ironscheme.exceptions::assertion-violation+(
         RuntimeHelpers.False, &quot;nooo&quot;, Builtins.List(x));
    }

As you can see, pretty simple. 

Note: If the code was transformed into a conditional expression (?:) in C#, the whole thing would just be one debug step, keep that in mind.

Here is IL output with source and line numbers:

      .method public static object  &#39;::baz&#39;(object x) cil managed
      {
        // Code size       56 (0x38)
        .maxstack  6
        .line 15,15 : 1,2 &#39;&#39;
    //000014: 
    //000015: (define (baz x)
        IL_0000:  nop
        .line 17,17 : 6,15 &#39;&#39;
    //000016:   (cond
    //000017:     [(null? x) 
        IL_0001:  ldarg.0
        IL_0002:  brtrue     IL_0009
    
        .line 18,18 : 7,8 &#39;&#39;
    //000018:       x]
        IL_0007:  ldarg.0
        IL_0008:  ret
    
        .line 19,19 : 6,15 &#39;&#39;
    //000019:     [(pair? x) 
        .line 19,19 : 6,15 &#39;&#39;
        IL_0009:  ldarg.0
        IL_000a:  isinst [IronScheme]IronScheme.Runtime.Cons
        IL_000f:  ldnull
        IL_0010:  cgt.un
        IL_0012:  brfalse    IL_0020
    
        IL_0017:  ldarg.0
        .line 20,20 : 7,14 &#39;&#39;
    //000020:       (car x)]
        IL_0018:  tail.
        IL_001a:  call object [IronScheme]IronScheme.Runtime.Builtins::Car(object)
        IL_001f:  ret
    
        IL_0020:  ldsfld object 
             [Microsoft.Scripting]Microsoft.Scripting.RuntimeHelpers::False
        IL_0025:  ldstr      &quot;nooo&quot;
        IL_002a:  ldarg.0
        IL_002b:  call object [IronScheme]IronScheme.Runtime.Builtins::List(object)
        .line 22,22 : 7,40 &#39;&#39;
    //000021:     [else
    //000022:       (assertion-violation #f &quot;nooo&quot; x)]))
        IL_0030:  tail.
        IL_0032:  call object [ironscheme.boot]#::
           &#39;ironscheme.exceptions::assertion-violation+&#39;(object,object,object)
        IL_0037:  ret
      } // end of method &#39;eval-core(033)&#39;::&#39;::baz&#39;

*Note:* To prevent the debugger from simply highlighting the entire method, I make the method entry point just 1 column wide.

As you can see, each expression maps correctly to a line.

Now the problem with stepping (tested on VS2010, but same/similar issue on VS2008):

These are with `IgnoreSymbolStoreSequencePoints` not applied.

1. Call baz with null arg, it works correctly. (null? x) followed by x.
2. Call baz with Cons arg, it works correctly. (null? x) then (pair? x) then (car x).
3. Call baz with other arg, it fails. (null? x) then (pair? x) then (car x) then (assertion-violation ...).

When applying `IgnoreSymbolStoreSequencePoints` (as recommended):

1. Call baz with null arg, it works correctly. (null? x) followed by x.
2. Call baz with Cons arg, it fails. (null? x) then (pair? x).
3. Call baz with other arg, it fails. (null? x) then (pair? x) then (car x) then (assertion-violation ...).

I also find in this mode that some lines (not shown here) are incorrectly highlighted, they are off by 1.

Here are some ideas what could be the causes:

- Tailcalls confuses the debugger
- Overlapping locations (not shown here) confuses the debugger (it does so very well when setting a breakpoint)
- ????

The second, but also serious, issue is the debugger failing to break/hit breakpoints in some cases.

The only place where I can get the debugger to break correctly (and consistantly), is at the method entry point. 

The situation gets a bit better when `IgnoreSymbolStoreSequencePoints` is not applied.


**Conclusion**

It might be that the VS debugger is just plain buggy  :(


**References:**

1. https://stackoverflow.com/questions/4357420/making-a-clr-net-language-debuggable


**Update 1:**

Mdbg does not work for 64-bit assemblies. So that is out. I have no more 32-bit machines to test it on. *Update:* I am sure this is no big problem, does anyone have a fix? *Edit:* Yes, silly me, just start mdbg under the x64 command prompt :)

**Update 2:**

I have created a C# app, and tried to dissect the line info. 

My findings:

- After any `brXXX` instruction you need to have a sequence point (if not valid aka &#39;#line hidden&#39;, emit a `nop`).
- Before any `brXXX` instruction,  emit a &#39;#line hidden&#39; and a `nop`.

Applying this, does not however fix the issues (alone?). 

But adding the following, gives the desired result  :)

- After `ret`, emit a &#39;#line hidden&#39; and a `nop`.

This is using the mode where `IgnoreSymbolStoreSequencePoints` is not applied. When applied, some steps are still skipped :(

Here is the IL output when above has been applied:

      .method public static object  &#39;::baz&#39;(object x) cil managed
      {
        // Code size       63 (0x3f)
        .maxstack  6
        .line 15,15 : 1,2 &#39;&#39;
        IL_0000:  nop
        .line 17,17 : 6,15 &#39;&#39;
        IL_0001:  ldarg.0
        .line 16707566,16707566 : 0,0 &#39;&#39;
        IL_0002:  nop
        IL_0003:  brtrue     IL_000c
    
        .line 16707566,16707566 : 0,0 &#39;&#39;
        IL_0008:  nop
        .line 18,18 : 7,8 &#39;&#39;
        IL_0009:  ldarg.0
        IL_000a:  ret
    
        .line 16707566,16707566 : 0,0 &#39;&#39;
        IL_000b:  nop
        .line 19,19 : 6,15 &#39;&#39;
        .line 19,19 : 6,15 &#39;&#39;
        IL_000c:  ldarg.0
        IL_000d:  isinst     [IronScheme]IronScheme.Runtime.Cons
        IL_0012:  ldnull
        IL_0013:  cgt.un
        .line 16707566,16707566 : 0,0 &#39;&#39;
        IL_0015:  nop
        IL_0016:  brfalse    IL_0026
    
        .line 16707566,16707566 : 0,0 &#39;&#39;
        IL_001b:  nop
        IL_001c:  ldarg.0
        .line 20,20 : 7,14 &#39;&#39;
        IL_001d:  tail.
        IL_001f:  call object [IronScheme]IronScheme.Runtime.Builtins::Car(object)
        IL_0024:  ret
    
        .line 16707566,16707566 : 0,0 &#39;&#39;
        IL_0025:  nop
        IL_0026:  ldsfld object 
          [Microsoft.Scripting]Microsoft.Scripting.RuntimeHelpers::False
        IL_002b:  ldstr      &quot;nooo&quot;
        IL_0030:  ldarg.0
        IL_0031:  call object [IronScheme]IronScheme.Runtime.Builtins::List(object)
        .line 22,22 : 7,40 &#39;&#39;
        IL_0036:  tail.
        IL_0038:  call object [ironscheme.boot]#::
          &#39;ironscheme.exceptions::assertion-violation+&#39;(object,object,object)
        IL_003d:  ret
    
        .line 16707566,16707566 : 0,0 &#39;&#39;
        IL_003e:  nop
      } // end of method &#39;eval-core(033)&#39;::&#39;::baz&#39;

**Update 3:**

Problem with above &#39;semi-fix&#39;. Peverify reports errors on all methods due to the `nop` after `ret`. I dont understand the problem really. How can a `nop` break verification after a `ret`. It is like dead code (except that it is NOT even code) ... Oh well, experimentation continues.

**Update 4:**

Back at home now, removed the &#39;unverifiable&#39; code, running on VS2008 and things are a lot worse. Perhaps running unverifiable code for the sake of proper debugging might be the answer. In &#39;release&#39; mode, all output would still be verifiable.

**Update 5:**

I have now decided my above idea is the only viable option for now. Although the generated code is unverifiable, I have yet to find any `VerificationException`&#39;s. I dont know what the impact will be on the end user with this scenario. 

As a bonus, my second issue has also be solved. :)

Here is a little [screencast][2] of what I ended up with. It hits breakpoints, does proper stepping (in/out/over), etc. All in all, the desired effect.

I, however, am still not accepting this as the way to do it. It feel overly-hacky to me. Having a confirmation on the real issue would be nice.

**Update 6:**

Just had the change to test the code on VS2010, there seems to be some problems:

1. &lt;strike&gt;The first call now does not step correctly. (assertion-violation ...) is hit. Other cases works fine.&lt;/strike&gt; Some old code emitted unnecessary positions. Removed the code, works as expected. :)
2. More seriously, breakpoints fail on the second invocation of the program (using in-memory compilation, dumping assembly to file seems to make breakpoints happy again).

Both these cases work correctly under VS2008. The main difference is that under VS2010, the entire application is compiled for .NET 4 and under VS2008, compiles to .NET 2. Both running 64-bit.

**Update 7:**

Like mentioned, I got mdbg running under 64-bit. Unfortunately, it also have the breakpoint issue where it fails to break if I rerun the program (this implies it gets recompiled, so not using the same assembly, but still using the same source).

**Update 8:**

I have [filed a bug][3] at the MS Connect site regarding the breakpoint issue. 

Update: Fixed

**Update 9:**

After some long thinking, the only way to make the debugger happy seems to be doing SSA, so every step can be isolated and sequential. I am yet to prove this notion though. But it seems logical. Obviously, cleaning up temps from SSA will break debugging, but that is easy to toggle, and leaving them does not have much overhead.


  [1]: http://ironscheme.codeplex.com/
  [2]: http://www.screencast.com/t/Tjrkjl7By
  [3]: https://connect.microsoft.com/VisualStudio/feedback/details/684089/
  [4]: https://connect.microsoft.com/VisualStudio/feedback/details/551765

Making your .NET language step correctly in the debugger

Is there a function in win API which can be used to extract the string representation of HRESULT value?

The problem is that not all return values are documented in MSDN, for example [ExecuteInDefaultAppDomain()](http://msdn.microsoft.com/en-us/library/ms164411.aspx) function is not documented to return &quot;0x80070002 - The system cannot find the file specified.&quot;, however, it does! Therefore, I was wondering whether there is a function to be used in common case.


Is there a way to get the string representation of HRESULT value using win API?

I installed .NET 4.5 Developer preview from http://www.microsoft.com/download/en/details.aspx?displaylang=en&amp;id=27541, which &#39;replaces&#39; .NET 4.0 version.

However, the old way to detect the .NET framework version seems to return 4.0 (more precisely 4.0.30319.17020 on my PC), instead of 4.5 (sure probably for backward compatibility, or?):

    using System;

    namespace ConsoleApplication
    {
        class Program
        {
            static void Main(string[] args)
            {
                var version = Environment.Version;
                Console.WriteLine(version.ToString());
                Console.ReadKey();
            }
        }
    }

How do I detect that my code is really executed by .NET 4.5?


How do I detect at runtime that .NET version 4.5 is currently running your code?

I wrote some code for testing the impact of try-catch, but seeing some surprising results.

    static void Main(string[] args)
    {
        Thread.CurrentThread.Priority = ThreadPriority.Highest;
        Process.GetCurrentProcess().PriorityClass = ProcessPriorityClass.RealTime;

        long start = 0, stop = 0, elapsed = 0;
        double avg = 0.0;

        long temp = Fibo(1);

        for (int i = 1; i &lt; 100000000; i++)
        {
            start = Stopwatch.GetTimestamp();
            temp = Fibo(100);
            stop = Stopwatch.GetTimestamp();

            elapsed = stop - start;
            avg = avg + ((double)elapsed - avg) / i;
        }

        Console.WriteLine(&quot;Elapsed: &quot; + avg);
        Console.ReadKey();
    }

    static long Fibo(int n)
    {
        long n1 = 0, n2 = 1, fibo = 0;
        n++;

        for (int i = 1; i &lt; n; i++)
        {
            n1 = n2;
            n2 = fibo;
            fibo = n1 + n2;
        }

        return fibo;
    }

On my computer, this consistently prints out a value around 0.96..

When I wrap the for loop inside Fibo() with a try-catch block like this:

    static long Fibo(int n)
    {
        long n1 = 0, n2 = 1, fibo = 0;
        n++;

        try
        {
            for (int i = 1; i &lt; n; i++)
            {
                n1 = n2;
                n2 = fibo;
                fibo = n1 + n2;
            }
        }
        catch {}

        return fibo;
    }

Now it consistently prints out 0.69... -- it actually runs faster! But why?

Note: I compiled this using the Release configuration and directly ran the EXE file (outside Visual Studio).

EDIT: [Jon Skeet&#39;s *excellent* analysis][1] shows that try-catch is somehow causing the x86 CLR to use the CPU registers in a more favorable way in this specific case (and I think we&#39;re yet to understand why). I confirmed Jon&#39;s finding that x64 CLR doesn&#39;t have this difference, and that it was faster than the x86 CLR. I also tested using `int` types inside the Fibo method instead of `long` types, and then the x86 CLR was as equally fast as the x64 CLR.


----------


**UPDATE:** It looks like this issue has been fixed by Roslyn. Same machine, same CLR version -- the issue remains as above when compiled with VS 2013, but the problem goes away when compiled with VS 2015. 


  [1]: https://stackoverflow.com/a/8928476/282110

Content Type	Original Author	Original Content on Stackoverflow
Question	cdub	View Question on Stackoverflow
Solution 1 - asp.net	jams	View Answer on Stackoverflow
Solution 2 - asp.net	Jon Schneider	View Answer on Stackoverflow
Solution 3 - asp.net	Theodore Ametepey	View Answer on Stackoverflow
Solution 4 - asp.net	user7205049	View Answer on Stackoverflow

ASP.NET CLR Not Enabled

asp.net Problem Overview

asp.net Solutions

Solution 1 - asp.net

Solution 2 - asp.net

Solution 3 - asp.net

Solution 4 - asp.net

What does the FD_CLOEXEC fcntl() flag do?

Get HTTP code from org.apache.http.HttpResponse

Attributions