Viewing 15 posts - 36,736 through 36,750 (of 39,771 total)
I'm not sure how this can be done. If dbcc errorlog doesn't work, then you may just need to cycle the server.
Sorry, don't have a v6.5 server to test with.
Steve...
December 19, 2002 at 9:30 am
I've seen that too, though it's changing. More and more I'm seeing tech pros paid more than their manager. Comes a limit, however, since managing entails more responsibility at some...
December 18, 2002 at 4:52 pm
Should be able to sp_configure 'allow updates to system tables', and then reconfigure and then change the values manually.
Steve Jones
December 18, 2002 at 4:49 pm
Let us know how it goes. Be interested to hear if you do get some good results either on the app or looking at NT v 2K.
Steve Jones
December 18, 2002 at 1:19 pm
Not anything specific. Some articles on this site that touch on it, some better than others.
If they suspect slowness, run Perf mon and look for CPU spikes, cache hit ratio...
December 18, 2002 at 12:52 pm
Great article and interesting discussion.
ckempste, second vote for your article. Not entirely sure what you were leaning towards on the first post, but I'd be interested to hear more.
I've...
December 18, 2002 at 12:48 pm
Backup / restore or some custom/complex/DTS packages. No other real way.
Steve Jones
December 18, 2002 at 10:52 am
Not sure of what there is specifically for SQL, but the IO routines, memory management, overhead for perfmon, and other utilities, run much better on 2000 than NT.
Plus there...
December 18, 2002 at 10:16 am
Don't have any of those.
My NT4 (SP6), SQL 7, SP3 box doesn't do this.
Steve Jones
December 18, 2002 at 10:09 am
Antares is correct. I used to run into this problem with 6.5. The only solution I had was to create new dbs on 65, single device, and bcp out bcp...
December 18, 2002 at 10:05 am
select into, a few other things don't work with a table var.
table var in memory, temp table in tempdb. Resource issues.
Not sure that a var avoids locking a table or...
December 17, 2002 at 9:00 pm
You can set the mdf as the default and recompile stored procedure and views to move them.
For tables, create a clustered index on the mdf.
Steve Jones
December 17, 2002 at 8:58 pm
No, but you could script the entire db and rerun the script in a new db. Pretty simple.
Steve Jones
December 17, 2002 at 8:57 pm
Are you trying to "repair" errors? This has some bugs. I wouldn't do it, just check and manually repair (or page out) if you find errors.
Steve Jones
December 17, 2002 at 4:06 pm
Viewing 15 posts - 36,736 through 36,750 (of 39,771 total)