isn't it more efficient to process the load all in the SSIS pipeline?

if you are just calling stored procedures from the SSIS package then you might as well...

I didn't have time to build a test table but I think something like this would work:

WITH Summary AS

(

SELECT

SERVERIP,

COUNT(*) AS [COUNT]

FROM

VID_SERVER

GROUP BY SERVERIP

WHERE BASESCORE >=...

If the time it takes to backup and restore is unacceptable perhaps you could increased the speed of backup by splitting it into mutiple files and if you have multiple...

adding additional files allows SQL to use more "workers" to allocate new pages as objects are created/dropped in the tempDB. On a busy system there can be a lot...

Insert the key into the fact table from your dimension table joined to the incoming data.

This works for me:

SELECT CAST(CAST(@InitiationDateTime AS DATE) AS DATETIME) + @SheduledTime

As pointed out previously there are several versions. I always assumed that Rudolph only participated during the "foggy christmas eve".

If the table\index fits on less than 8 pages then reindex procedures will ignore it because it is on a mixed extent.

You're welcome. I think I read somewhere that this is the go forward method of using linked servers that the "openquery" method would be depricated at some point,...

Try this:

EXEC ('set fmtonly off; set nocount on; DBCC Showfilestats WITH no_infomsgs') at [Nameoflinkedserver]

If you are using windows authentication it sounds like permissions on a double hop. Are you running this in your local laptop/desktop connected to a SQL server where there...

This probably falls under the Kerberos "Double Hop" problem. When you log into a server (connect with a client application) the server authenticates your login with the active directory....

Silly question, is the Login added to the server with permissions to connect to a database(s)?

Without creating the objects this might be a guess but I think this part of your query:

(SELECT SUM(dbo.ART_Exp_Records.Exp_Csm_Value)

FROM dbo.ART_Exp_Records INNER JOIN

dbo.ART_Exp_Sheets ON dbo.ART_Exp_Records.Exp_Sheet_ID = dbo.ART_Exp_Sheets.Exp_Sheet_ID

GROUP BY dbo.ART_Consortiums.Csm_ID, dbo.ART_Exp_Sheets.Sheet_Year,

dbo.ART_Exp_Sheets.Sheet_Month,...

http://www.kimballgroup.com/