Clipmarks | wackoyacky's clips

ASP.NET Page Life Cycle

Fri, 07 Mar 2008 06:13:49 GMT

clipped by: wackoyacky

Clip Source: www.sql-server-performance.com

Page_Init

LoadViewState

LoadPostData

Page_Load

RaisePostDataChangedEvent

RaisePostBackEvent

Page_PreRender

SaveViewState

Page_Render

Page_UnLoad

Tags: asp.net

Generic Collections

Fri, 07 Mar 2008 05:21:58 GMT

clipped by: wackoyacky
clipper's remarks: Generic counter parts of non generic collections

Clip Source: msdn2.microsoft.com

The following generic types correspond to existing collection types:

List is the generic class corresponding to ArrayList.
Dictionary is the generic class corresponding to Hashtable.
Collection is the generic class corresponding to CollectionBase. Collection can be used as a base class, but unlike CollectionBase it is not abstract, making it much easier to use.
ReadOnlyCollection is the generic class corresponding to ReadOnlyCollectionBase. ReadOnlyCollection is not abstract, and has a constructor that makes it easy to expose an existing List as a read-only collection.
The Queue, Stack, and SortedList generic classes correspond to the respective nongeneric classes with the same names.

Basic & Practical Use of LINQ (not db related)

Wed, 26 Dec 2007 08:57:20 GMT

clipped by: wackoyacky
clipper's remarks: Most of the time we (or may be it is only me) has a misconception that LINQ has alwasy to be associated with database like MS SQL. But to my suprise after reading this article, I finally realize the basic and practical use of LINQ aside from the wrong connotation as "stored proc replacement"

The main thing that was seems important to me using LINQ on this article is that there's no need to typecast your objects(boxing and unboxing)

Clip Source: www.singingeels.com

LINQ (Language INtegrated Query) is a powerful but misunderstood new language feature brought to us in the .NET framework version 3.5 (C# 3.0 and VB 9). Even though this is a new feature, it already has some huge misconceptions (such as thinking LINQ is a replacement to SQL). This article will teach you how to use LINQ (the language itself), where LINQ can save you a lot of time and will cover some basic concepts of Extension Methods and Lambda expressions.

Tags: linq, .net

C# 3.0 New Features

Wed, 26 Dec 2007 08:03:53 GMT

clipped by: wackoyacky

Clip Source: www.developer.com

On the heels of the Visual Studio 2005 and C# 2.0 releases, Microsoft has given a sneak preview of what to expect in the version after the next: C# 3.0. Even though C# 3.0 is not even standardized yet, Microsoft provided a preview release at its Professional Developers Conference (PDC) in September so eager developers could try out some of the expected features. This article discusses the following major new enhancements expected in C# 3.0:

Implicitly typed local variables

Anonymous types

Extension methods

Object and collection initializers

Lambda expressions

Query expressions

Expression Trees

Tags: c# 3.0, .net

Widescreen Resolution for Intel Graphics Driver

Mon, 10 Dec 2007 13:23:25 GMT

clipped by: wackoyacky
clipper's remarks: After week of sleepless night doing trial and error just to make Ubuntu remember my screen resolution on every startup, finally it was resolved

Clip Source: help.ubuntu.com

There is a common issue with Intel graphics resulting in screen resolutions not being available even after adding them to the xorg.conf file. This happens with the i810 video driver, but the newer intel driver does not have this problem.

Install newer modesetting Intel video driver

Unfortunately the newer driver is only available from 6.10 onwards (Edgy, Feisty etc), but not in 6.06.1 (Dapper). If you have Edgy or above then you can install the newer intel video driver with:-

sudo apt-get install xserver-xorg-video-intel

Then edit your /etc/X11/xorg.conf and change the

Driver "i810"

Driver "intel"

Tags: ubuntu, 7.10, gutsy gibbon

Sequential Ordering on SQL 2005

Wed, 28 Nov 2007 04:11:53 GMT

clipped by: wackoyacky

Clip Source: www.sqlservercentral.com

The optional PARTITION BY clause specifies a partition, after which the row numbering re-starts. If we modify the query above to include a PARTITION BY LastName, row numbering will re-start after each new LastName in the table. Our modified query looks like this:

The RANK function is similar in syntax to ROW_NUMBER, but it serves a slightly different purpose. RANK numbers rows like ROW_NUMBER but it assigns the same row number to rows in the event of a "tie." You can see this for yourself in the results of the query above:

Tags: sql, sequential ordering

CROSS APPLY on SQL 2005

Wed, 28 Nov 2007 04:09:14 GMT

clipped by: wackoyacky
clipper's remarks: With this, you would be able to use fields from your select statement within your inner join subquery or udf

Remember the compatibility level of the database must be set to 90.

ex. exec sp_dbcmptlevel MyDb, 90

Clip Source: weblogs.sqlteam.com

select A.*, b.X
from A
cross apply dbo.UDF(A.Val) b

Tags: sql 2005, cross apply

SQL Determine The Row Size Of All The Tables

Fri, 22 Jun 2007 03:32:28 GMT

clipped by: wackoyacky

Clip Source: www.sqlservercentral.com

SELECT OBJECT_NAME (id) tablename
     , COUNT (1)        nr_columns
     , SUM (length)     maxrowlength
FROM   syscolumns
GROUP BY OBJECT_NAME (id)
ORDER BY OBJECT_NAME (id)

Tags: sql, row size

Windows Settings in GRUB menu.lst

Fri, 08 Jun 2007 18:45:00 GMT

clipped by: wackoyacky
clipper's remarks: Taken from http://apcmag.com/6101/dualboot_windows_xp_and_ubuntu

Edit menu.lst and just add this code

Clip Source: apcmag.com

sudo gedit /boot/grub/menu.lst

# This entry automatically added by the Debian installer for a non-linux OS
# on /dev/sda1
title Microsoft Windows XP Professional
root (hd0,0)
savedefault
makeactive
chainloader +1

Tags: linux, ubuntu, grub