Next time pleas include a small script that creates the table and inserts data instead of drawing a table. This will save time for anyone that tries to help...

Were either or both of these set up by a recruiter? First sounds like confusing data entry with DBA. Second sounds like generic DBA position but they forgot to...

Few years ago I've had very strange interview. I was asked all kind of strange questions that had nothing to do with my ability to work as a DBA....

Can you post a URL to the article? I've just checked it on 2 tables and get 2 query plans with almost the same cost. Maybe there...

Yes. When you'll grant him the permission, it will be written in the log and when that log will be restored at the secondary database, the user will be...

Users don't get any permissions by default. The users should be granted permissions. When you have a secondary database from log shipping, the database cannot be modified, so...

If the job doesn't run at all check the fallowing:

1) Is the SQL Server is up and running?

2) Is the job enabled or disabled?

3) Is the job's schedule is enabled...

What is the error that you are getting when you run the job?

Adi

I ran the script and after the select statement, the statistics were created. Are you sure that the statistics were not created on your server?

Adi

Can you post a small script that reproduces the problem (e.g. create table, insert test data, create the statistics and then the statistics are not created)?

About the statistics that...

Take a look at this article - http://msdn.microsoft.com/en-us/library/ms345408(v=sql.90).aspx. You can start SQL Server at special configuration (single user and only master database is up) and then issue alter database...

If the login is part of sysadmin server role, then he can do everything on the server and you can not limit his actions. You'll have to to remove...

I'm assuming that you want to increase the file's size. You can do it with Alter database statement. You can read about it and see an example...

Do you have any triggers on the tables? Any indexed views on the table? Are all inserts that you are doing are insert values or are they insert-select?

Adi

I'm sorry, but I don't understand what you want. You can get the difference between 2 datetime values by using the datediff function. This will return a...