Hi

i will try to answer your questions...

1) - Yes . Performance of queries does get affected. Make sure that you have proper indexes and you retrieve only those rows and...

Simply moving to a new file will not improve performance.

The file should be located on a different disk(s) so that IO can distributed over the disks and this will...

Hi

From June/20 i will be on vacation for about 2 weeks. I have someone covering for me, but i like to handle the critical things myself so that iam not...

There is no direct way of doing what you want.... You can take a backup without verifying and restore it in another server to check whether the backup is ok...

Hi Pravin

There are many expamples of Bulk Insert in BOL and the net.

The operator that i was talking abt is "BatchSize".

I think Shrikant has some good suggestions but iam...

Hi

Iam not a expert on clustered environment so i cant help you there. There are different time outs in sql like remote time outs, lock time out etc.

BOL tells about...

Now things are more clear...

I think you "know" who your external users are going to be.

You are storing the external user data so that each external user gets to see...

Try correct the issue rather than setting timeout proerpty.

Is the server up and running and also SQL Server service.

are the network protocols enabled.

Is SQL Server Browser runing.

check out...

Hi

Keep a login for the external users with limited permissions.

You can differentiate external users by checking the sys.sql_login table or other system tables/views. you do not need a separate table...

If you mean designing the tables then you may want 3 tables

one each for country,state and city. Try designing them and then come to us for doubts/suggestions.

IF (DATEPART(dw,'2008/06/14') IN (1,7))

begin

PRINT 'HOLIDAY'

enD

you can also use a variable instead of the date if you want.

I will just modify the step 3 of the previous post..

Since you are inserting a million records and if your server is hard pressed for resources you can insert the...

Hi

In the pivot function you can use only aggregate functions like avg,count etc. So you will have to do the rounding part in the outer query.

BTW are you working on...

Do you mean to say that external users connect thru the web page and the other "normal" users do not.

If this is the case then having a seprate login will...

Hi

Have you set the folder correctly? Are there backup files older than 3 days in your backup folder?

check out these links

http://www.sqlservercentral.com/Forums/Topic361562-149-1.aspx

http://www.sqljunkies.com/WebLog/mz1313/archive/2006/04/03/20010.aspx

seems i was wrong about the extension name for...