SQL2005 SP2, 32-bit Windows Server 2003 EE SP2
Server has 8GB RAM - SQL Server currently takes 1.7GB
I'd like to get SQL Server to about 4gb RAM.  I've been reading all the
posts and replies and I think I may have all the info, taking a little from

what is the passing score in MCTS exam for sql server 2005.

Is it possible to create multiple endpoints for Database Mirroring in SQL
Server 2005?
After reading that only 10 databases should be mirrored per endpoint I tried
to create another endpoint and received the following error:

I have 3 questions regarding memory configuration on a Windows Server 2003
SP2 Enterprise Edition with SQL2005 SP2.
1. Can someone advise on the correct boot.ini file configuration to utilize
4GB of local memory? I'm not sure if I need the 3GB switch?

Gurus,
When you install a SQL Server 2005 Named Instance, it uses a dynamically
allocated port (as opposed to port 1433 in a default instance).  Is this
more "secure"?

Is there a quick way to copy a set of stored procedures in SQL Server 2005
from one database engine to another, as quickly as using DTS in SQL Server
2000?  Other than restoring from a backup.
Thanks,

We're late to the party, as far as rolling out SQL2K5.  I would like
to *GASP* apply the latest SP2 cumulative update to the servers(looks
like CU6).  We of course have not yet encountered any of the errors
that are addressed in the CU updates.  The probably-not-unique-to-us

This conversation came up and I was wondering if anyone had some
definitive proof one way or another....
If you have a key column for a table and that column will be used as a
reference/foreign key to other tables often and frequently but also

We are seeing a differince in size column for the same files between
sys.database_files and sys.master_files. sys.master_files inidcates smaller
sizes so I think that rules out deferred drop operations.  Any ideas?  this
is for Tempdb files.

By default, the transactionlogs are created in the same location as
the databases. We've gone through the works of moving the already
exisitng transactionlogs to a seperate disk and have changed the
default location of the transactionlogfiles.

Had to replace leased server hardware running Server2003, Sql2005.  Had
machine Server B, set up sql2005, set up maintenance plan to do full backup
on all user dbs every night to Server C network share.  Worked great for over
a week.  Came time to do the swamp, brought down old ...

I've got a server with dual processor, each one quad core.
I wan to setup a virtual machine to run sql server on my production
environment.
What kind of license do I need to buy?

I will be greatful for help with the expression.
Example:
'I currently requested 50 rows from a database and now I want the next 50
rows.

How to create a new tableA from tableB by a single SQL?
I can't find from the book online, i remember that is possbile.
Thanks,
Martin

What scares me about the 70-431 exam is the huge amount of complicated
T-SQL commands. Look at the syntax of any T-SQL command with all its
options; many many options, how can I remember them. Do I need to
remember all these instructions for the exam. Please let me know.