.NET Brisbane, Australia
-
TeamSystem and TFS add-on to Count Lines of Code and Predict Errors
-
Old Memories, Hard Disk
-
How To Make a Productive Project Meeting ?
-
Stored procedure takes longer run on SQL 2005 than SQL 2000
Here there is something interesting that I would like to share with you guys.
Even thou Microsoft SQL Server 2005 is out for quite some time, it is still common to see people working in projects using Microsoft SQL Server 2000 and often in mixed environments.That's the case I want to talk about: The mixed environment, and I am working in a project where some applications have that hybrid configuration.So someone told me that my report developed in .NET 2.0 was running slower than the similar one done in the old fashioned ASP. Of course I denied, just to see later the proof I was wrong.Yes, the same stored procedure executed from the same page from, in the same machine was running faster in the old environment while it was slower in the new (and supposedly improved) environment. How's that possible? I traced the execution, used the SQL profiler but nothing gave me a good clue. Than I found this in the Microsoft website.In SQL Server 2000, the execution plan for the query uses an Index Seek operator. In SQL Server 2005, the execution plan for the query uses an Index Scan operator. The optimizer produces an index spool for the Index Scan operation. When you use the FORWARD_ONLY cursor, SQL Server scans the index for every FETCH statement. Each fetch takes a long time. Therefore, the query takes a long time to execute.See that example below: -
How does Microsoft collect usability data from the users ?
That's a very funny video, made by Microsoft-Italy, that I saw once and I would like to share with you guys :-)
-
ASP.NET Login is lost when I refresh the page. How come?
Here another interesting problem. Crazy logins loosing their tokens. I had a chat with a friend that happens to work in an online shop website. He knew that I've developed once the authentication/authorisation mechanism for a similar company then he asked me that:
-
How to Setup Technorati Post Here ?
hi guys,
-
How to get the best of your team and your job
Hi guys, let's talk about open communication, and let me start sharing this point of view. I reckon the expression 'if you do not work, I fire you' is becoming history now more and more.