Viewing 15 posts - 36,871 through 36,885 (of 39,903 total)
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
Probably. Wehn you run sp_Start_job or click EM, you execute the stored procedure in your context, which executes the job.
If you let the schedule kick it off, that thread is...
December 17, 2002 at 8:33 am
Haven't tried this and not sure it should matter, but an interesting issue.
I did the client tools on my laptop, then personal later and it wouldn't let me do a...
December 16, 2002 at 3:52 pm
That's what we do. Most likely the network guys didn't think of it or couldnt' get it talking and chose the easy way out.
Steve Jones
December 16, 2002 at 3:49 pm
Viewing 15 posts - 36,871 through 36,885 (of 39,903 total)