If you want the result as expected I think you need to build a SSRS...

You mean: 4 instances - 4 different drive letters with multiple disks arrayed under.

terry999 (8/23/2013)Any ideas what I should investigate next time I'm connected to this machine. Trying to build a list of things to check when I next can access this machine....

The error in the summary refers to the failure to update the shared features. The instance itself is likely to be updated and stating the correct version number. Look in...

ROFL :rolleyes:

If that happened I would say the delete definitely...

Can you tell the error message you got when you tried to restore the third LOG backup? This could give some information about why the chain was broken. It could...

To get the NULL value in your results, you will need to change your WHERE clause to

WHERE name <> 'Check' OR name IS NULL

Or you need to rewrite your WHERE...

Specific for the more write intensive filegroups the performance will benefit with 4 datafiles vs. 1 datafile. With 4 datafiles the I/O will be spread over all datafiles (when they...

At first glance (I haven't analysed or executed the code) it looks like you need extra double quotes around the path/filenames.

Try changing this part:

...

CREATE DATABASE [CoreDB] ON PRIMARY

( NAME...

Most of the time a database benefits from more then one datafile. Also use multiple filegroups to seperate your data (historical vs. actual and/or clutered indexes vs. non-clustered indexes and/or...

Can you check in the SQL Error logs what is causing these memory dumps? Also check the Windows Event logs. I expect some severe error messages just before the dumps...

The time it takes to failover is very long because of the number of databases. To become online SQL needs to open filehandles to all database files (each database has...

Maybe you would be better off using:

SELECT

CASE (SELECT COUNT(1) FROM table WHERE...)

WHEN 0 THEN 'none'

WHEN 1 THEN 'single'

ELSE 'multiple'

END

and then using your simplified or complex query depending on the results.

The MAX statement will only return one single value. You can get the desired results using the TOP clause:

SELECT TOP 2

change_id

FROM table_a

ORDER BY change_id DESC

It looks like your configuration of Database Mail isn't correct. Run sp_configure to see if DatabaseMail XPs are enabled and then delete and reconfigure your mail profile and account settings...