Hi Gail,

Clustered Index Scan

Please find the plan attached

Thanks,

Howard

You should look up "Parameter Sniffing". It sounds like this is what's happening. Basically, when a stored procedure's first executed, it uses the first parameters supplied to generate and store...

Yep, that makes sense.

Basically, in the simple recovery model, if you're doing a differential backup, all the data you're backing up must have had the full backup it's based...

Are you saying you ran a full database differential backup after running two individual filegroup backups and it gave this error?

This is expected functionality in the Simple recovery model, you...

You'd have to write something that uses sys.foreign_keys and sys.foreign_key_columns to find all the child tables, build delete statements with dynamic SQL and loop through them to delete.

It gets...

Hi,

There's nowhere near enough information for anyone to help you with this other than it looks like maybe you need to know about the DATEDIFF funtion and PIVOT (both of...

They are functional parts of the definition of objects, which...

I'm struggling to work out what your question is, could you clarify? These are questions about an application that uses a database engine rather than being about a database engine...

I'm not sure it's easily possible. I know they're based on SSIS (which does have an API you can interface with) but it's unlikely to be an easy task.

I'd say...

Why would you expect 3 results? All of your rows are either in the state of Nevada, or the county of clark. Do you mean to exclude rows where either...

A trigger on update will fire regardless of whether the update is actually making a change.

You cannot prevent the trigger firing, but you can change the logic of your trigger...

OK - I suspect it may be a combination of enabling TCP/IP and starting the SQL Browser Service then - if you're not entirely fed up of the problem, would...

Ok, for what ever reason, it looks like it cannot resolve your instance name back to where it's located.

In the case of a named instance, you must have either...

Is the SQL Server Browser Service Running?

Can you post the entire contents of SQLAGENT.OUT? I take it this is the RTM version of R2, not a CTP (just checking as the connect bug you linked to...