jQuery Tutorials Link : http://www.codedigest.com/Tutorials/jQuery_Tutorials_For_ASPNET_Developers.aspx

jQuery Tutorials For ASP.Net Developers

Beginning jQuery Development

What is jQuery? How to use it in ASP.Net Pages?

How to enable jQuery intellisense in Visual Studio 2008?

How to use jQuery intellisense in an external JavaScript file?

Introduction to jQuery in ASP.Net and 10 Advantages to Choose jQuery

Using jQuery in ASP.Net Application

Master-Detail View with Selectable GridView and DetailsView using jQuery in ASP.Net

Handling or Attaching Events to Dynamic HTML using jQuery in ASP.Net

Creating Accordion Panel using jQuery in ASP.Net

Building Collapsible Panel Control using jQuery in ASP.Net Page

http://www.codedigest.com/Tutorials/jQuery_Tutorials_For_ASPNET_Developers.aspx 

Building Ajax Application using jQuery

Doing AJAX with jQuery in ASP.Net

Calling a WebService using jQuery in ASP.Net

Ajax Application using jQuery and JSON

Building Cascading DropDownList in ASP.Net Using jQuery and JSON

Creating a Simple AJAX Master-Details View Using jQuery, JSON and jTemplates in ASP.Net

Populating RadioButtonList Using jQuery, JSON in ASP.Net

Lazy Loading jQuery Collapsible Panel in ASP.Net Using JSON

UserName or Login Availability Check Using jQuery in ASP.Net

Rotate Text Link Advertisements Using JQuery in ASP.Net

Lazy Loading jquery Accordion Panel in ASP.Net

Creating a Simple Rating control using jQuery and AJAX in ASP.Net

UserName or Login Availability Check Using jQuery in ASP.Net

GridView Style Edit Update in Repeater Control Using jQuery and Ajax

GOOD JAVASCRIPT SITES

http://www.w3schools.com/js/js_ex_dom.asp

http://www.quackit.com/javascript/examples/

http://www.comptechdoc.org/independent/web/cgi/javamanual/javadocument.html

CAST CONVERT PINAL

http://blog.sqlauthority.com/2007/07/07/sql-server-convert-text-to-numbers-integer-cast-and-convert/

How to convert text to integer in SQL?
If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or CONVERT function.

How to use CAST or CONVERT?
SELECT CAST(YourVarcharCol AS INT) FROM Table
SELECT CONVERT(INT, YourVarcharCol) FROM Table

Will CAST or CONVERT thrown an error when column values converted from alpha-numeric characters to numeric?
YES.

Will CAST or CONVERT retrieve only numbers when column values converted from alpha-numeric characters to numeric?
NO.

How to parse/retrieve only numbers from column values contains alpha-numeric characters?
SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String

What are the online references for CAST and CONVERT?
CAST and CONVERT

Which one are better ? scalar , Table , multiline , inline UDFs

Inline UDFs offer a SET based operation where as multi-line  and scalar udfs offer row-based operation.

Bottom Line : Avoid CURSORs , WHILE LOOPs , multi-line  and scalar udfs

http://www.sqlservercentral.com/articles/T-SQL/73887/
http://jahaines.blogspot.com/2009/10/converting-scalar-user-defined-function.html

1 indicate least recommended and 3 indicates most recommended UDFs


1. Scalar UDF
1. Multilne UDF
2. Table UDF
3. Inline Table UDF
3. Inline UDF

Page Split DBCC SQL Code

This is from QOD40. Remember that even a ROLLBack causes a page split.

create table test ( c1 int , c2 varchar(1000))create

insert into test values (1, REPLICATE('a' , 900))insert into test values (2, REPLICATE('b' , 900))insert into test values (3, REPLICATE('c' , 900))insert into test values (4, REPLICATE('d' , 900))insert into test values (6, REPLICATE('f' , 900))insert into test values (7, REPLICATE('g' , 900))insert into test values (8, REPLICATE('h' , 900))insert into test values (9, REPLICATE('i' , 900))dbcc
begin
insert tran into test values (5, REPLICATE('e' , 900))rollback tran ind(0, 'test' , 1) clustered index pk on test(c1)

SQL Server Indexes Fact Sheet

MS SQL Server

1. What is the maximum allowed size of index key in an index ( total size of columns used in the index definition) ?

900 bytes

2. How many indexes a table can have ?

 1 Clustered  and
999 non-clustered

3. How many columns can be combined in a composite index key ?
16

4. What is a heap ?
If there is no clustered index on a table, the table is called a heap.

5. How do I identify heaps and clustered indexed tables in my SQL Server database ?
The following query gives listing of clustered , non-clustered indexes and heaps :
select
(
join
(
on
order by b.type_desc ,a.name a.id = b.object_id select object_id , name , type_desc from sys.indexes ) B select id , name from sysobjects where xtype = 'U' ) A a.name , b.type_desc from

A column may have null values. But I want to ensure that all not null values are UNIQUE.

A UNIQUE constraint is not useful here because, it will allow a single NULL value in the column, no DUPLICATE NULLs.

Use  a filtered index here :
CREATE UNIQUE INDEX indexName ON tableName(columnNames) WHERE columnName IS NOT NULL

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