You create a SSIS package to insert data from xls to table. You can create a job to execute this SSIS package. Also you can schedule it as well as...

Thank you, Steve.

One more question on SQL new feature of memory-optimized filegroup.

Based on your requirement you need to work out; follwoing questions will help you to narrowdown the options:

Howmuch downtime is acceptable?

Howmany Databases on the SQL instance?

What is the storage you...

Execute following command and check the recovery model of the user databases on which you do have issue.

select name, recovery_model_desc from sys.databases

Good one. Thank you Steve.

It's 27.36 MB...

Totally agreed with everybody. Though db is in SIMPLE recovery reindex will surely affect the log size. If not check for any long open transaction.

By the way what is...

Thanks Steve for the question.

It has also been notice that Log file viewer is not displaying all the option at a time. If you open from SQL Server logs it...

In that case looks like resource crunch on the server. Check your server for any harware bottlenack.

You mean once your application launch everything become normal?

There are two ways:

One you can run RESTORE VERIFYONLY command to check and verify the backup.

Second you can restore the backup in test environment.

HTH

In addition to above, when sql server started you may also see the messages for rollback transaction and rollforward transactions in the database. which is nothing but based on checkpoint...

You can drop the article quietly but when you add the article to publication you must need to start the snapshot agent.

Check the SQL log for detail action.

What kind of application you are using on database server? As best practice microsoft recomend to have dedicated database server.

Check for any hardware bottlenack. Are you facing issue for...