Sql Functions

NOLOCK

http://www.sqlservercentral.com/Forums/Topic282321-149-1.aspx
http://www.sqlservercentral.com/articles/Performance+Tuning/2764/


http://www.1keydata.com/sql/sql-use.html

SQL WILD CARDS:
http://www.techonthenet.com/sql/like.php
http://www.w3schools.com/SQL/sql_wildcards.asp


The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.

TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

The DROP command removes a table from the database. All the tables' rows,
indexes and privileges will also be removed. The operation cannot be rolled back.

DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.
********************************************************
TURN IMPLICIT TRANSACTION ON IN SQL:

http://blog.techdreams.org/2007/11/implicit-transactions-onoff-sql-server.html

http://www.allinterview.com/showanswers/71598.html

Send Mail through php(Hypertext Preprocessor)

http://www.w3schools.com/php/php_mail.asp

BCC,CC--
http://www.java2s.com/Code/Php/Form/SendemailwithCCandBCC.htm

Send mail when Error occur in website

http://www.plugins4asp.net/tipsdetails.aspx?ID=50

http://dotnetguts.blogspot.com/2007/10/error-handling-in-net-with-example.html

http://www.mastercsharp.com/article.aspx?ArticleID=61&&TopicID=2

Session Expire in 20 minutes or 2 minute

http://forums.asp.net/t/1283350.aspx
http://forums.asp.net/p/1332460/2676515.aspx
http://stackoverflow.com/questions/648992/session-timeout-in-asp-net


1.)http://www.velocityreviews.com/forums/t95194-go-to-login-page-when-session-expires.html

2.)http://zeeshanumardotnet.blogspot.com/2009/01/why-dot-net-sessions-are-cleared-before.html

3.)http://zeeshanumardotnet.blogspot.com/2009/07/why-sessions-are-terminatedloss.html

Validation of Mac failed

http://blogs.msdn.com/tom/archive/2008/03/14/validation-of-viewstate-mac-failed-error.aspx

1.)http://www.andreas-kraus.net/blog/validation-of-viewstate-mac-failed/

2.)http://www.pagedowntech.com/faq/faq.asp?faqid=145

3.)http://www.eukhost.com/forums/f15/fix-validation-viewstate-mac-failed-6085/

Set a table’s visibility to false when it has no rows (in reporting services)

http://stackoverflow.com/questions/514043/set-a-tables-visibility-to-false-when-it-has-no-rows-in-reporting-services

Database Mirroring in SQL Server 2008

1.)Database Mirroring in SQL Server 2008

http://www.databasejournal.com/features/mssql/article.php/3828341/Database-Mirroring-in-SQL-Server-2008.htm

****************************************************************
2.)Replication in SQL Server 2008

http://www.databasejournal.com/features/mssql/article.php/3820361/Peer-to-Peer-Replication-in-SQL-Server-2008--Add-a-node-and-resolve-conflict.htm

*****************************************************************
3.)get day from datetime
DATENAME ( datepart ,date )
http://msdn.microsoft.com/en-us/library/ms174395(SQL.90).aspx

******************************************************************
4.) Delete temp data from pc shortcut
run type:%temp%