Viewing 15 posts - 36,691 through 36,705 (of 39,720 total)
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
Generally you want to follow Scorpians advice, but I've put both on a single server.
The things you do want to do, however, is not limit your flexibility. Don't connect with...
December 16, 2002 at 3:46 pm
I would hire you with or without the cert as a junior. Doesn't mean much to me, though it does show some initiative.
Steve Jones
December 16, 2002 at 12:51 pm
They are listed with all other pathches, jsut not included in SQL patches.
MS02-40 is one.
Steve Jones
December 16, 2002 at 11:39 am
Viewing 15 posts - 36,691 through 36,705 (of 39,720 total)