Viewing 15 posts - 361 through 375 (of 490 total)
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...
April 28, 2011 at 10:22 am
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...
April 28, 2011 at 10:09 am
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...
April 28, 2011 at 10:06 am
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...
April 28, 2011 at 10:02 am
2 physical nodes
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 28, 2011 at 9:53 am
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...
April 28, 2011 at 9:49 am
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...
April 28, 2011 at 9:36 am
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...
April 28, 2011 at 9:30 am
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
April 28, 2011 at 9:27 am
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...
April 27, 2011 at 10:31 am
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...
April 27, 2011 at 10:20 am
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 |...
April 27, 2011 at 10:04 am
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...
April 27, 2011 at 9:54 am
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...
April 27, 2011 at 9:48 am
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...
April 26, 2011 at 5:37 am
Viewing 15 posts - 361 through 375 (of 490 total)