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...

Msg 121, Level 20, State 0, Line 0

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired

In...

If you want to restrict user can see only definition of the objects then remove all rights exclude public then give VIEW DEFINITION

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA...