Viewing 15 posts - 39,121 through 39,135 (of 39,456 total)
Thanks for the info, however beaware that he can change the design of the cube and mis-represent data. Be sure someone reviews the code and application before distributing the data...
October 29, 2001 at 10:35 am
October 29, 2001 at 10:33 am
October 29, 2001 at 10:31 am
October 29, 2001 at 10:21 am
I'm not sure this is a worst practice for a couple of reasons. I tend to agree that a complete DB is a bad idea in almost all cases, especially...
October 29, 2001 at 10:18 am
try dbss freeproccache to remove all query plans, then recompile the sproc (or sp_recompile.
Are you sure this is the exact same code? I might try recompiling the actual code to...
October 26, 2001 at 4:19 pm
October 26, 2001 at 4:17 pm
If you are on RAID, I wouldn't worry. You can add drives and with most modern RAID controllers, expand the size on the fly, though the rebuild takes time.
Steve Jones
October 26, 2001 at 4:16 pm
It's also table specific. Only one table at a time, so be sure to turn it off when you are done.
Steve Jones
October 26, 2001 at 4:14 pm
October 26, 2001 at 4:12 pm
David, thanks for the link. I think this will be your problem. This is one of the drawbacks of multiple files in a database.
Steve Jones
October 26, 2001 at 4:11 pm
MSMQ is nice if you are concerned about load and want to separate your stuff from the SQL Server. Also, it reduces dependencies and integrates better with some systems (Tuxedo,...
October 26, 2001 at 1:56 pm
Currently, I've seen single databases at collegues sites with single files over 13GB with no issues. I used to manage a v6.5 database that was 15GB with no issues from...
October 26, 2001 at 1:53 pm
If you really want to change it, and I HIGHLY recommend against it, you can right click on the server in Enterprise Manager , select properties, and choose the "Memory...
October 26, 2001 at 10:54 am
also need to match up the logins with the users once you are finished.
from the db, run "sp_change_users_login 'auto_fix'
Steve Jones
October 26, 2001 at 10:48 am
Viewing 15 posts - 39,121 through 39,135 (of 39,456 total)