Which came first, the drinking or the job?

Interesting. I've never heard it referred to as a link or bridge table (except in data warehousing), but instead I've always heard it referred to as an association table...

The toughest and most confusing databases I have worked on are those that do not use Identity, and instead relate to tables based on natural keys. Not only does...

Usually at lunch or near end of day when other people have left for about 30 minutes. Or during employee break time for those that run 24/7. Never...

In trying to figure out my processing from BIDS issue, I decided to delete the SSAS database through Management Studio. I then tried to deploy throughtBIDS....and it worked now.

I...

Successs. Here's the deal:

1. Refresh and reconnect did not work for me, nor did opening and closing BIDS.

2. When I processed the dimensionn from Management Studio, then things worked....

I'm having a similar issue.

I added 1 record to my dimProductLine dimension table.

I process the dimension, but the new record does not appear in the list of members.

So I look...

Yes, I think it is very important for a DBA to have influence on how many hours they work. That was part of the negotiation when I got my...

After further review, I'm able to edit the servername property after I delete the OLE DB Source objoect from my package. That seems to be the trigger. That object...

There is no config file yet---I haven't gotten that far. I just want to change the server name so that I can test this in BIDS. ...

I found that a department was running reports for a very large date range, so, this brought our normally 7GB- 10GB database up quite a bit. We basically want...

I have the same issue, the tempdb mdf file will not shrink even though I have attempted all known commands to do so. A reboot did not change the...

I can't say I spend any time on enforcing referential data integrity since I moved from Access to SQL years ago. I've never had a problem in 10 years....

I found that the error was occuring in a place I didn't expect. In the Excel Source task, the Input and Output Properties did not have matching data types....

Hope this helps, it worked for me:

Instead of using Point destPoint = new Point(0, 0); for portrait, use the same code

that is needed for landscape, which is an array...