Could try some third party odbc drivers?

Just a couple of things I've found useful. If you have to loop generally it's quicker to use a while loop selecting each record individually rather than a cursor. Also if...

I just excluded the sql server root directory and subfolders and as mentioned before sourcesafe on checkout, not on checkin. The issue with pdf appears to be a bug with...

the collation of the column userinfo is different from the default you need to cast it to the same collation. If the difference in collation isn't by design you can change...

If the performance isn't good enough for your setup then don't use it, theres plenty of alternatives.

I'm quite new to this myself having been working on AS for the past year and a half so I'll do my best to help: Could profile building the shared...

Could try scheduling report snapshots over night and making them valid for 24 hours if its not so important theyre completely up to date? Have you looked a potential bottlenecks?

I have no idea, I just recall when first installing it we had rs on the same server as sourcesafe running the sample reports and it was pitifully slow. Only...

I found this too and it turned out to be the virus checker, exclude the SQL Server folder (probably a good idea after McAffee decide SQLServer.exe sp4 was a virus!),...

Filtering list of accounts:-

1) create mdx to bring back sample interested in and drillthrough to underlying cube data, filter this by exclusion list in second recordset or file stream and return...

Yes it was 4.2, not sure whether it supported nullable fk's though (ie with nocheck) as erwin produced triggers in this situation.

DRI does have a performance hit. Agree with everything...

Its hard to believe that SQL6.5 didnt have foreign keys..personally I think if you lock down the database as much as possible your helping the programmer write good quality code....

try adding a table grouped by companyid and goal. Sum in the group header the max value for the group. Stick the table in a footer field, hiding blank fields. link...

Error reads like MOM can't attach to server/db to ascertain correct status

Thinking about it if you are inserting in a batch wouldn't sql server allocate a batch of keys, so you only need the recordcount and the scope identity? Have you played...