Very awesome. I'll try it out, Thanks!

Else, I found out the ssis package first import the data into a table that has raw data, meaning no constraints defined, then import from raw table to the real...

You have to touch everything that depends on that data stream so that it knows what to do with that new column.

SSIS has an XML source and XML task. THe XML task can validate your data, merge it with another xml set and even do comparisons between the sets (You would...

Hi,

What provider did you use when creating your link?

Not sure if this is still an issue for you... other options are using the fast load option in a OLE DB destination. Not sure if there are constraints on...

I would be interested in seeing the solution.

Wouldn't "SELECT CURRENT_USER, ORIGINAL_LOGIN(), SESSION_USER, USER, USER_NAME(), SYSTEM_USER" return the general user account ? If this is a scheduled job created...

You would need a helper dataset query that went something like :IF (@client=1)

begin

select @datefrom = dateadd(m, -6, getdate() )

You pass the results to the master dataset ...

My advise here is to build a more general stored procedure that brings in all the columns you need at a granular (lowest common factor) level. I assume you mean...

Was this message the result of a server trigger, has this been ruled out? To remove permissions, one would employ the REVOKE command.

Try the default trace to see what ran prior to your reboot.

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

One thing that slows things down is casting in the where clause. I see this in query 2.

plus I also see in the WHERE clause -->

Entitlement.EntitlementId IS NULL ...

You can also include the percent/ratio in your sql query and pass it as a column to the report via the result set.

Example ::

USE ADVENTUREWORKS2008R2;

Go

SELECT

personType, count(*) as Total,...

I would say that a SQL Server job does not roll back the preceding steps when you encounter a step that fails. You can add all your SP calls to...

To find tables to remove .. I am assuming you want those less/most used to be flagged somehow?

This tells you the tables most accessed

SELECT

t.name AS 'Table',

SUM(i.user_seeks...