Growing and shrinking database files will cause performance hits.  I think it's a good practice to set a size for your files that you minimize the need for growth (both by...

I had faced the similar questions couple months ago.  The decision you will make depends on the bandwitdh and your databases.  We know that you have a slow connection.  So...

Yes, it's possible and I did that at my previous job.  We had x64 AMD opteron box that I installed Windows Server 2003 Standard 64 bit OS.  Applied SP1 at...

When you modify a procedure or creat a new one and you want to save this to database you need connect to server (local or remote) and execute the script that...

What I do and recommend the developers to follow is when you create an object always explicitly grant permission on that.  For example let's say that everyone will need to...

I use pkunzip in one of my job step to unzip compressed file to a location.  I also have the job saved as batch file.  You can execute the batch file...

this is the error message that I got back after trying differential backup of master database

Server: Msg 3024, Level 16, State 1, Line 1

You can only perform a full backup...

Well explained.  Thanks for posting back and let us know.

Good day,

Bulent

check out the link below too.

http://www.databasedesign-resource.com/

Good day,

Bulent

Have you looked for sqlstop.log file located at system root folder?  You know the default location for windows xp system root folder is c:\windows  this file is a setup log...

Have you tested it out?  Let us know.  I would think that it may work since you make sure that the job that backs up the log file and moves...

I have not tested this but I read that someone was able to create a database that data and log files resided on a network location.  But I know that...

For SQL Server 2000 you need to purchase a seperate license.  But If you purcahse SQL Server 2005 Enterprise only the host needs to be licensed and you don't need...

Your cert is on SQL 7 not on SQL 2000.  I don't think you qualify for the upgrade path for MCITPatabase Administrator

Good day

Bulent

Stop using Sa and implement Windows authentication using Windows Groups or windows accounts.  By using groups and group membership there will be less SQL login /user administration.