Hi. Nice to have someone to go around the basics for a while.

One thing struck my eye though.

Space needed for database.

10 % and autogrow is easy but 10 % of...

hi.

Grouping as well as order by can be used with aggregate functions when using the function in group by phrase as "group by LEFT(determinant, 5),...."

This is probably because the result...

Same thoughts exactly as Sugesh previously.

Guest user allows users to access databases while their own login doesn't.

Use always domain users or - groups. Some third party installations require sql server...

One book to read is Relational Database Index Design and the Optimizers by Tapio Lahdenmaki and Mike Leach.

This Book contains basics and a "little" further.

Regards

Great that someone reminds us of this. Although all DBA's should be familiar with restoring to a point in time.

One thing in the article which I found not so clear...

As I said in some reply to a password issue on this forum earlier, strong passwords are at least 15 characters long and it doesn't matter much if there are...

To my knowledge a strong password, which is proteced against even freeware password breaker software should be at least 15 characters long and actually there is not much advantage if uppercase...

You can also schedule dts-packages in enterprise manager. Scheduling creates jobs for them which you can name and change their scheduling parameters logically.

When you have different jobs you can collect them...

I really don't know if this helps but try using server ip addressess as registered servers when replicating across different domains, we do so and it works just fine. Although our replication...

Hi, Backuping frequency (as well as other maintenance like space allocations etc.) depends on the update and growth rate of the DB.

Basicly Full backup once or twice or more times a week, then...

If you start the dts-copy by your self then you should have sufficient authority on both servers because the job uses your account and on the other hand if the...

Have You checked the event viewer on both ends. Application log contains sql-server messages, also security and system logs should be looked into.

-j-

I also answered that there is a syntax error, as there is. The answer for the query #1 is "invalid column a..."

Null value cannot be referred to any value because...