How are you determining normal execution time for a job?

Those jobs shouldn't have anything in sysjobactivity if they aren't running. Why not just have your query return jobs outside your threshold by doing:

SELECT

j.job_id,

...

It's been awhile since I've used a lookup transform, but is sounds like you need to have the data types match on the join columns. So either have them...

There are several options:

1. Server-side trace to see what is really happening in SQL Server

2. Add error handling in the trigger/proc to log any errors.

3. Disable the trigger, run the...

I've never run the Upgrade Wizard, but my guess would be that this is just a message carried over from SSDT if you open a package/project in SSDT. I...

It's not in system_health. You can possibly get it from the Default Trace looking for the Object:Altered event and ObjectType of 16964 which is Database. It doesn't give...

You need to convert the year column being brought in from access from text to string. Text is a binary type, not a string type.

There isn't...

And the answer is?

mortonsoft (7/14/2014)

---

GilaMonster (7/9/2014)

---

Jack Corbett (7/9/2014)

---

1. Scaling - ORM tools still aren't very good at complex SQL (multiple joins, outer joins, etc...) so you need to evaluate every query...

Duplicate post, please post answere here, http://www.sqlservercentral.com/Forums/Topic1591742-1632-1.aspx

You need to make sure you set security at the level you want the user to see. If a user has Browse permissions at the report server level they...

Short answer, yes.

Long answer, you can keep the existing work in package deployment and new work in Project deployment. We are doing the same thing where I'm at now....

How are you loading the data?

Is all the data going to one table or to multiple tables?

Are the tables heaps or do the have clustered indexes?

Don't put the user in any fixed database roles and then run something like:

GRANT SELECT ON schema::dbo TO ;

which grants select only on all objects in the dbo schema. ...