Viewing 15 posts - 16 through 30 (of 91 total)
Could try some third party odbc drivers?
April 25, 2006 at 9:01 am
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...
April 7, 2006 at 5:32 am
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...
April 6, 2006 at 7:52 am
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...
March 30, 2006 at 6:24 am
If the performance isn't good enough for your setup then don't use it, theres plenty of alternatives.
March 30, 2006 at 1:51 am
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...
March 29, 2006 at 4:49 am
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?
March 23, 2006 at 3:41 am
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...
March 17, 2006 at 10:51 am
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!),...
March 17, 2006 at 6:18 am
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...
March 16, 2006 at 4:41 am
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...
March 9, 2006 at 6:55 am
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....
March 7, 2006 at 3:47 am
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...
February 24, 2006 at 7:50 am
Error reads like MOM can't attach to server/db to ascertain correct status
January 27, 2006 at 4:53 am
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...
January 20, 2006 at 5:08 am