Update:

Think i got it! forgot to take into consideration the order of the predicates. Join predicate must be used first in the index, followed by whatever im grouping/sorting by:

CREATE NONCLUSTERED...

Thanks Gail. Makes sense.

Turns out that despite the VM being allocated 2.3Ghz of processing power its only getting on average 500Mhz. Something else on the host has priority on the...

Hi. Nevermind, i figured that what im trying to do is impossible and i need more info. i think some rows should be versioned, so i need to go to...

You can schedule an agent job to run once per month, but it will still presemably require human intervention to update the password the job updates.

I'd spend some time figuring...

I'm not sure if you can do this via policy managment. IMO access to a database should be a part of a well thought out security configuration, and I don't...

why not use the international standard ISO8601. Its compatable with all date formats.

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

http://www.w3.org/TR/NOTE-datetime

not really a whole lot of information to work with. looks like your username or password is incorrect, or someone has removed access to the database instance for that particular...

You need to post the table schema, and schema of any indexes on the tables. sample data is not a whole lot...

SQL Server always logs install failures and install successes. On any of my computers the logs are stored in:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

In this log directory there is a directory...

"Database is slow" is similar to saying "the internet's broken" when you cant connect to wifi. There are many many potential causes. We need to do is narrow it down...

your running the maintenance plan via sql agent right? what does the job history say?

a Server being down or a Database being down does not in itself raise an alert, so your script would have to execute regularly, and check against a list of...

Or you could use one of the SQL Managment tools. I have used Idera SQL DM and found it quite good. Quest & Redgate have similar tools, which although i...

Powershell, get-Service cmdlet

http://www.computerperformance.co.uk/powershell/powershell_service.htm

I worked on a project where we do something similar.

The big problem you will have is if each server is a different configuration (different drives, letters etc), and each...