I've never tried a database diagram but it might be useful in this case to visualize the entity relationships.

There may also be triggers in place doing writes somewhere.

You can have two jobs running simultaneously and importing to the different tables. If the data resides on different machines you would need to connect via linked server objects. So...

You can go with the one data warehouse approach. I would employ the use of schemas to denote where the information comes from. Example, china.orders will be the same as...

Do you need to get the week start and end dates, or the week number in the year? Have you considered the use of a calendar table? Keep in mind...

Not sure. I think count returns an integer and the largest number that can return is 2,147,483,647. Do you have some more information on your query that can help?

Extra comma's where? Do you mean there were extra fields in the text file that had empty string values? Else the purpose of the double quotes is to denote any...

Something interesting would be the new challenge of keeping up with the many views that can now be created against a single table. Such as to display one set of...

CASE

WHEN l.GNLFSMID IN (127)

THEN SUM(l.GNLBalanceBase) OVER (PARTITION BY l.GNLCOAID)

ELSE '0'

See if this might help,...

Are the datasets in the reports using stored procedures or is the sql typed in directly? The former will be faster. If they are procedures... are they also slow when...

I think if this is your code you may have a clue with isolating where the problem may be rather than providing a entire code dump. But I did find...

Visit Books Online and go down the SSIS tree. There are descriptions for every control flow item in there. Once you have a feel for that item start tinkering with...

You wont need to create a config file for the master...

Try

dbcc opentran

to look for any open transaction. If nothing, you can try issuing a 'checkpoint' command on the database to commit data in the systems memory.

mmartin1 (7/21/2013)This issue may have more than meets the eye. Depending on the exact work that you do and the money you make, the company may be able to say...