Viewing 15 posts - 39,271 through 39,285 (of 39,605 total)
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
what does he need to do? you can manage roles in the Analysis Manager.
If he needs to create cubes, he may need these rights, but I'd create it for him,...
October 26, 2001 at 10:46 am
Viewing 15 posts - 39,271 through 39,285 (of 39,605 total)