BULK TRANSACTIONS

1)REINDEXING
2)SELECT INTO
3)BULK INSERT
4)BPC

fragmentations:-

http://www.sqlservercentral.com/blogs/practicalsqldba/2012/04/05/sql-server-index-fragmentation-understanding-fragmentation/

http://www.mssqltips.com/sqlservertip/2262/sql-server-fragmentation-what-it-is-what-types-there-are-part-2-of-9/

BEST WEBSITE FOR SQL SERVER DBA

http://sqlmag.com/blog/why-does-data-backup-include-transaction-log

http://www.sqlbackuprestore.com/logsequencenumbers.htm

http://www.informit.com/library/content.aspx?b=STY_Sql_Server_7&seqNum=41

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s