LOL.. got to love...

Jayanth_Kurup (1/15/2013)

---

To start off make sure the indexes and stats are up to date.

There seems to be parrallelism , do u have proper indexes defined?

There also seems to be Page...

See this: http://dataqueen.unlimitedviz.com/2012/05/importing-data-from-active-directory-using-ssis/

Do you mean having a table that contains the complete connection string (i.e. including user name and password)?

Right-Click tempdb in SSMS and select files:

User error... No fix to report lol

Didnt read full instructions. MS Baseline Configuration Analyzer needs to be installed first.

Then after you install SQL Server BPA, it gets added to the...

Sorry.. I fixed the problem!

Shouldn't there be a Ticket dimension table with attributes that describe the type of ticket?

Not entirely sure the Queue dimension table is appropriate to be honest.

What's the purpose of the Queue dimension table?

SSIS is great for performing ETL, so yes, if you have the knowledge and you're comfortable developing packages then go ahead and use...

Can you double check to make sure that the SQL Server service account has access to the network share?

Sorry to say that you went for the wrong option!

B) de-normalization speeds up data...

there is constraint on the table which doesn't allow this column to be NULL. This is to maintain referential integrity. You're attempting to insert a value in one column so...

Ag_id is likely to be the primary key of the table you're trying to insert into. This is the error you posted earlier:

Cannot insert the value NULL into column 'ag_id',...

insert into agency_deplo_plan (deplo_plan_name)

select act_pln

from AGENC;

Error:

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column 'ag_id', table 'elPaso.dbo.agency_deplo_plan'; column does not allow nulls. INSERT...

Are you sure this is all the code? The error doesn't tie up with the code:

declare @nCount int

select @nCount = COUNT(*) from agency_deplo_plan

if @nCount = 0

BEGIN

insert...