Do also check the actual database owner for the involved databases.

If you performed the restore, the database will have your userid as owner unless you've executed sp_changedbowner after the recovery.

Exactly what I've been preaching over here 🙂

Configuration nor budget is my call in this case :Whistling:

But this being the first case since this new hosting company is in charge,...

we always use a windows domain account as service account for our sqlserver instances.

Are there firewalls involved ? If yes, did you open the needed ports ?

6 spindles:

4x136GB -> 2 RAID1 volumes -> C-drive and D-drive

2x300GB -> 1 RAID1 volume -> E-drive

I hope they upgraded all hardware drivers before they made it available because that was...

Thank you for your reply.

Having my concerns confirmed certainly counts !

Apparently our hosting company works at "least effort" basis and doesn't heasitate to charge big piles of $$ just to...

aren't you just killing your engine using all these cursors, UDF in in-clauses, row level nested views ( who knows what is in there ) ...

How about adding a group...

could be kind of application logging that has been implemented and enabled.

Could it be an insert on a cursor-ed object (ado recordset insert) ?

unlike the old syntax ( not using the keyword JOIN ) the placement of the on-clause predicates don't play a role in determining the left part of your left join.

...

+5 stars ( and that's just because that is the maximum supported over here ) :hehe:

Well said, Jeff :w00t:

the way you did it is grouping by minute ( not taking year/month/day/hour into account )

This is how I would do it.

SELECT

datepart(mi,[startDate]) as MI,

min(startDate) as startDate,

avg(duration) Duration

FROM ...

well, consider it as if you were to write the from part in a (long) single line

In English, we read it from left to right, correct ?

Hence a left...

I'm glad SSC republished your fine article, Gianluca.

Nice work, great descussions.

did you try :

, CASE WHEN ss.enabled IS NOT NULL THEN 'Schedule is enabled'

...

please check out the procedure described at msdn: How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005 : http://msdn.microsoft.com/en-us/library/ms143799%28v=sql.90%29.aspx

As documented in BOL: TRUNCATE TABLE (Transact-SQL)

Restrictions

You cannot use TRUNCATE TABLE on tables that:

Are referenced by a FOREIGN KEY constraint. (You can truncate a table that...