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

http://msdn.microsoft.com/en-us/library/ms147827(v=sql.90).aspx

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

you can break month wise and set partition function on month of 2011 like JAN,FEB,MAR then it will save these month data,in the next year 2011 no need to add...

whats the version of SQL Server and did you enable AWE in SQL Server to allocate maximum RAM and lock pages in memory in the LOCAL SECURITY POLICY of OS

Regards,

Syed...

tempdb is not like as swap partition in linux or virtual memory concept in windows,The tempdb system database is a global resource that is available to all users connected to...

To move the master database, follow these steps.

1.From the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server...

I didnt say like this as you get ,snaphot database work with database which one is snaped shot,A database snapshot is a read-only, static view of a database (the source...

2 physical nodes

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

you should define or maintain a document which have ERD(Entity Relation Diagram) and mapping like primary key and foreign key relation,you have applied normalization that you will define all table...

you should have to upgrade DTS packages on SSIS and then check how you can schedule this package on SQL Server 2008 as attachment shown

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP...

you can use SSIS services and Linked Server to move database access to SQL Server

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My...

http://msdn.microsoft.com/library/ms170722(en-US,SQL.90).aspx

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

do you think this is overhead,you are partitioning year wise,month wise and week wise ,do you delete or archive data after 1 year or what

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP...

In Cluster environment if 1 node failed then services move on another node but logically you can install second instance of sql server on the same cluster but you have...

Make the NIC Teaming then use same for mirroring,it will manage load automatically on both NIC

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP |...

that is the restriction of Standard Edition you can failover only 2 nodes if you want to failover more than 2 then you should for Enterprise Edition , this edition...