Slow network on Vista - Computer hangs

I updated my network driver two days ago... The installation went well, but after the reboot the network was very slow! If I disabled the network card (wireless) my computer became responsive again. The same happend if I logged in to a local account rather than my normal domain account. No errors in the event viewer on the client or the server. It seems like this problem only occors on Vista computers joined to a domain.

The resolution was to do a couple of settings on the tcp stack. I ran a cmd-window as administrator (on the local account because of the speed) and typed in these two commands:

netsh interface tcp set global rss=disabled [enter]
netsh interface tcp set global autotuninglevel=disabled [enter]

After a new reboot I could again log into my domain as normally!

Select random from Microsoft SQL Server

I have previously written code to select a random row from a table in SQL Server. Earlier this was a big job with a lot of statements in T-Sql. From versjon 2000 of Sql Server you can use the new future newid() and you will get a random record back. The sql statement will be as follows:

select top 5 * from YourTable order by newid()

that will return 5 random records from the table YourTable.

Creating a page that returns xml to the user - high performance

If you have to return xml, an image or any other type of not-html data you should build an ashx-handler. The ashx-handler does not have all the regular events that is attached to a normal aspx-page, and as a result the performance will be improved.

ASPCode.net have posted a great article about how to build a ashx-handler, with code examples. Read the article here.