Viewing 15 posts - 36,316 through 36,330 (of 39,717 total)
A nice suggestion and one that I know people try to follow, but it can get difficult. I know as an author I often am trying to solve a particular...
May 2, 2003 at 1:34 pm
If you open a command prompt from the source to the destination and do a dir, do you have enought space?
Steve Jones
April 30, 2003 at 11:35 am
Actually it should import in row order if there is no clustered index. Are you expecting to "select" the data and get it back in this order? There is no...
April 30, 2003 at 9:35 am
Not a bad idea, though I suspect only a few of you (Antares) would be likely to spend the time to solve it. Course I could be wrong, but it's...
April 30, 2003 at 9:29 am
I hate this. IMHO, it's more of a pain, especially when you are on vacation or need some remote hands. Just my experience, but I tend to allow local admins...
April 29, 2003 at 9:46 am
Is the data a big deal? If not, use backup/restore. This is the simplest, cleanest and easiest.
Alternatively, you can script this with SQL-DMO and access the generate script for the...
April 28, 2003 at 1:01 pm
Hmmm, that's an interesting one. I suspect the only way is to block 1433 at the NIC level using the Windows networking setup. Use the IP config for the nIC,...
April 28, 2003 at 12:59 pm
Are you running the application terminal services or the remote admin? We run remote admin here and it doesn't impact very much. Running app mode will impact more as the...
April 28, 2003 at 10:08 am
You can also move on a backup and restore, but I would follow Allen's advice if you just want to move an existing db.
Steve Jones
April 25, 2003 at 10:18 am
Is there a reason you can't schedule it to run every minute?
You could do an xp_cmdsheel and "dtsrun" it, but I wouldn't recommend it. If you schedule it, then you...
April 24, 2003 at 11:48 am
Sorry, you're right. For some reason I misread your post.
But the last posts isn't right. Your W2K std will use all 4 CPUs, but the first virtual or logical processor...
April 24, 2003 at 8:44 am
you can set showplan_text on and post that. I'd be intersted to see as well. Pls include table DDL, insert trigger, indexes.
Steve Jones
April 23, 2003 at 9:23 am
Incorrect, the BIOS should enumerate:
CPU #1, Logical #1
CPU #2, Logical #1
CPU #3, Logical #1
CPU #4, Logical #1
CPU #1, Logical #2
CPU #2, Logical #2
CPU #3, Logical #2
CPU #4, Logical #2
http://www.microsoft.com/windows2000/docs/hyperthreading.doc -...
April 23, 2003 at 9:20 am
Thanks. It was one of those little trivia things, but still it might help someone.
Steve Jones
April 23, 2003 at 9:15 am
This isn't a SQL Server thing, it's a SQL thing. The join clause is used first to pick the rows, at which point the rows with Master(5) and null details...
April 23, 2003 at 9:14 am
Viewing 15 posts - 36,316 through 36,330 (of 39,717 total)