It means the inactive part of the log (transactions commited and flushed to disk) are removed logically. This does not release the space back to the operating system but will...

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup

DECLARE @fileDate VARCHAR(20) -- used for...

It will if you ensure that the Network Service Account belongs to the following user rights assignment: Perform Volume Maintenance Tasks, through group policy.

This is because the first time the procedure is run it must first load the data from disk into SQL's buffer pool (memory), since you are loading the data everyday...

Change the recovery mode to Simple. Read the following article first to understand the implications:

http://msdn.microsoft.com/en-us/library/ms175987.aspx

Have you tried running the more granular shrink commands (I'm thinking your default file size is set high!):

The values are in MB

DBCC SHRINKFILE (N'YourDbName' , 5000)

GO ...

If you are going to reuse the GETDATE() result for multiple statements then you must assign it's value to a variable as you are proposing. For 2 reasons:

1. Performance -...

You can have as many logical processors as you do physical processors or cores on the VMWare host.

There is a top limit of about 160 depending on what version of...

With the recovery model set to simple, do as already suggested and batch up this import into say 10k rows at a time. After each batch SQL will probably initiate...

What I would do is this:

1. Save this spreadsheeet as a CSV (importing Excel sheet into a database is not so easy)

2. Import the file to a staging table using...

What windows accounts did you specify for the services to use?

Sounds like you have a super huge transaction going on during the day that you need to pinpoint! How big is the database itself?

Just make that the instance your are applying the service pack to stopped else you may run into an issue where files are locked and the service pack will only...

You can do it, append WITH COPY_ONLY to your command.

It makes no difference at all to the execution plan, it's a matter or personal preference or what coding standards you choose to adopt.

For me, I prefer the global BEGIN...