Replication

Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...

Data Type Synonyms

Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...

reading.

Reading another great book ( I know its old but good book)...Inside Microsoft sql server 2005: T-SQL QUERYING....by Itzik Ben - Gan.

Conditional reIndex and update stats.

Hi,This script is very helpful, specially for sql server 2000. I made some changes into this.Thanx to T.Pullen for this...

Things to consider...

Hi.... I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....Cool Stuff:
1.SSMS: now...

SQL Server 2005

What's new in Sql server 2008

Hi...Finally... the Complete Enterprise product sql server 2008 is a great product, it has everything  includes features which other competitors...

Truncating the log

What's new in Sql Server 2005

Its very difficult to write what all new  in Sql server 2005, almost everything is new... the complete engine has...

Transaction isolation level

Transaction isolation level:1. Uncommitted Read (NoLock)2. Committed Read (blocking)3. Repeatable Read (phantom)4. Snapshot  (no blocking)5. Serializable (no blocking)Dirty Read:(DR)Non Repeatable Read:(NRR)Phantom:(P)Great...