experience, lots of DBA work...

post the results of this query:

SELECT TOP 10

[Wait type] = wait_type,

[Wait time (s)] = wait_time_ms / 1000,

[% waiting] = CONVERT(DECIMAL(12,2), wait_time_ms * 100.0

...

whats does the available memory perfmon counter say?. How much memory is SQL actually using?

a max memory setting of 118GB is the buffer pool only, other SQL caches will...

If the schema (I presume that is what you are going to be using) are not related perhaps they should not be in the same database. What if you need...

I still have a fair number of SQL2000 installs out there. I am trying to upgrade or retire all of them but it is difficult as the application support people...

so he does.

The ops only choice is...

whats the state_desc value in sys.master_files for this offending log file?

if it is 'offline' and you have issued an emptyfile and remove file a transaction log backup could remove this...

why? Are you using a case sensitive collation?

Markus, having done so would they work on the new server? Are not the maintenance plans heavily tied to the server they were created on?

got enough space scripts yet? I have some more 😀 (one of 'em written by Jeff)

A heap is a table without a clustered index. Reindexing would not defragment the base data.

Views occupy no space, they are just queries.

heres a couple of queries to run in...

you had 2GB worth of growth because of the growth factor of 10%, the mdf was almost 20Gb, so it grew by 2GB. When it was only 3GB it would...

whats the growth factor on the database mdf file?

when you back the database up, how big is the backup?

you could do that. Set up logshipping in the normal way then disable the backup job.

As stated above write a process to check log full percentage which then executes...

As Lynn has said if you dont want log backups, put the database in simple mode, it doesn't matter what the vendor says, they rarely know very much about database...