Viewing 15 posts - 39,136 through 39,150 (of 39,466 total)
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
If you are really concerned, do a backup at the beginning of the hour, right before the time change, and then one later.
Steve Jones
October 26, 2001 at 10:33 am
October 26, 2001 at 10:31 am
Also, Queue can be either MSMQ or just a table in SQL Server that holds the status about what you are trying to process.
Steve Jones
October 26, 2001 at 10:30 am
BCP can be tricky and requires exact formats. You might try experimenting with the format files, or even extract a row from your table with BCP and save the format...
October 26, 2001 at 10:27 am
Viewing 15 posts - 39,136 through 39,150 (of 39,466 total)