I had the same problem and the only way I was able to resolve it was to click the Build Query button to go into the query builder. Then click...

Who cares about performance on small tables. Performance only becomes an issue on large tables. I'd like to see a comparison with tables of 1 million and 100 million rows.

I don't think the ItemQuantity, KitQuantity is a good idea because the same product could be part of multiple kits and you would not be able to distinguish between sales...

Actually, you don't need to duplicate records on the first version. You can create the current-version record at the time the first SCD split occurs. The first record would have...

I would like to have ability to create sub-folders in the Jobs area of SSMS so that i can organized jobs rather than have all jobs in one long list....

Also, I can't make a subscription for a report with dependant parameters because the dependent parameters are disabled even after picking a value for the parent parameter. In the subscription...

Furthermore, After I select all the parameters (clicking apply after each) and the report displays, if I then go back and change the first parameter (which should invalidate the other...

In my case SQL 2005 SP2 fixed the problem.

Apparently SP2 fixes the problem. I haven't had any more hangs since applying SP2!

Omhoge, Do you have SP2 installed?

In my case, I don't have SP2 installed yet. I plan to install it this weekend. Then I will test to see if the problem...

I also have a package that inexplicably hangs (on 64 bit server). It hangs intermittently even in the designer. My package is simple, with one dataflow that reads data from...

I'm not sure I understand your question, but it sounds like you need help with the sql procedure to make use of the multi-value parameter.

I usually do this by making...

I also tend to prefer to make disk-based native backups first then backup those to tape. It is always less hassle to restore from disk than tape. In the past...