Compare 2 tables are equal in SQL

Reference:

http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

SQL window function

Just read the SQL cookbook and learn userful sql windows function.

Over()

http://msdn.microsoft.com/en-us/library/ms189461.aspx

NTILE

http://msdn.microsoft.com/en-us/library/ms175126.aspx

TSQL Date and Time function

http://msdn.microsoft.com/en-us/library/ms186724.aspx

WITH common_table_expression (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms175972.aspx

See a good list of SQL tutorial while googling:

http://www.databasejournal.com/article.php/3649246

http://www.databasejournal.com/features/mssql/article.php/3780311/Exploring-SQL-2005146s-Ranking-Functions-150-NTILE-and-ROWNUMBER.htm

Debugging Design-Time Controls

Microsoft's article for debugging design time Control

http://msdn.microsoft.com/en-us/library/ms996457.aspx

Design mode property

http://stackoverflow.com/questions/7008217/visual-studio-2010-crashes-when-opening-a-form-containing-an-user-control-in-de

Reference:

http://dotnetfacts.blogspot.com/2009/05/determine-debug-mode-in-net.html

http://stackoverflow.com/questions/2663873/user-control-always-crashes-visual-studio

http://stackoverflow.com/questions/39648/good-way-to-debug-visual-studio-designer-errors

asp.net Page method insecurities

http://encosia.com/asp-net-page-methods-are-only-as-secure-as-you-make-them/

CSV Reader in VB.net

Public Shared Function CsvToDataTable(ByVal filePath As String, ByVal isRowOneHeader As Boolean) As DataTable

Dim afile As TextFieldParser = New TextFieldParser(filePath)

afile.TextFieldType = FieldType.Delimited

afile.Delimiters = New String() {","}

afile.HasFieldsEnclosedInQuotes = True

Dim index As Integer = 0

Dim csvDataTable As DataTable = New DataTable()

Dim headings() As String

If (isRowOneHeader) Then

index = 1

Dim row As DataRow = csvDataTable.NewRow

headings = afile.ReadFields

For i As Integer = 0 To headings.Length - 1

csvDataTable.Columns.Add(headings(i), Type.GetType("System.String"))

If Not String.IsNullOrEmpty(headings(i)) Then

row(i) = headings(i)

End If

Next

End If

Do While Not afile.EndOfData

Try

Dim row As DataRow = csvDataTable.NewRow

Dim csvDataRowStr = afile.ReadFields

For j As Integer = 0 To headings.Length - 1

If Not String.IsNullOrEmpty(csvDataRowStr(j)) Then

row(j) = csvDataRowStr(j)

End If

Next

csvDataTable.Rows.Add(row)

Catch ex As FileIO.MalformedLineException

Throw

End Try

Loop

Return csvDataTable

End Function

Reference:

http://stackoverflow.com/questions/736629/parse-delimited-csv-in-net

SQL optimization

http://www.techartifact.com/blogs/2009/12/sql-optimization-tipsquestions.html

http://www.databasejournal.com/features/mssql/article.php/1437391/Transact-SQL-Optimization-Tips.htm

http://www.sql-server-performance.com/2006/tuning-joins/2/

Node.js tutorial

http://debuggable.com/posts/understanding-node-js:4bd98440-45e4-4a9a-8ef7-0f7ecbdd56cb

http://howtonode.org/