From the diagram, the ETL brings in your data from your own operation system(s) and from the outside world. This would be a good place to make sure the data...

I don't think the index is as bad as it sounds. Without a good index a process has to lock the whole table (on a table scan) instead of taking...

This is the type of problem that MDX handles quite well, if the user has an OLAP cube to query from. A date dimension and a fact table is all...

So I understand you want a different record set for every state? You can dump all the data into one table and create a procedure that pulls the data by...

Hi

So from your latest post, I gather you have a synonym to a remote table? That is, it points to a table on another database in the same machine or...

I think you need to spend a little time ensuring you have set up the mail profile and account correctly. You were given a couple of links earlier for setting...

I assume you have turned on database mail in the surface area configuration (or through a script). Have you created a mail profile?

select [name] from msdb..sysmail_profile

HI -

You can build a date hierarchy in a SSAS cube. You need a date dimension table, which is essentially a calendar table, as Jeff mentioned. From there as...

I think the reply from frfernan is your best bet. To add to that:

You need not code an exact date, You can do like

SELECT lr.*

FROM lab_results lr

...

I'd be interested in knowing if there is some activity on the export server that is using up CPU time, like a hung application not related to the database service....

You can also start a Profiler trace to get more information with events on that view object. There are a couple of event categories that may be worthwhile to look...

Quick correction to my prior post. Use the '?' as the place holder when using direct input. But you can still give the parameter a friendly name in the Parameter...

In addition, you can use the long data type in case you experience any issues there. Also you can give your variable inside the task a more friendly name

INSERT INTO...

An advantage of a for each loop is being able to count how many files you imported from with a script task in the same loop. I didn't see that...

Hi - Maybe I misunderstood but I read you need all five variables set to 1 before the next task in question should execute. In your code I see all...