Viewing 15 posts - 36,511 through 36,525 (of 39,903 total)
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
You can also use the Dynamic Properties task to change the target file based on a select select, which could build the file name.
Steve Jones
April 23, 2003 at 9:05 am
One note, if the log was this big initially, then you can't shrink below the initial size.
That being said, shrink it and see, you may need help and there's a...
April 23, 2003 at 8:59 am
Agree wtih Andy. Can't do it if they are sysadmin. I doubt they need sysadmin access, most apps don't. I'd lean on them to use a regular user.
Steve Jones
April 23, 2003 at 8:51 am
Setup a job to copy and or email them. Give them access to the new location. Could easily be another server. You could even automate this to run every hour.
Steve...
April 23, 2003 at 8:43 am
The search includes the forums. Doesn't break them out as a separate item though. Try searching for "oracle" and you'll see.
Steve Jones
April 23, 2003 at 8:40 am
create trigger mytrigger for insert on mytable
update mytable
set field2 = i.field1
from inserted i
where i.mypk = mytable.mypk
Steve Jones
April 22, 2003 at 10:54 am
Windows 2K and SQL 2K do not understand hyperthreadind. To them it looks like extra CPUs exist, and since Std has a 4 CPU limit, that is why you cannot...
April 22, 2003 at 10:52 am
Pls do not cross post. Answered in "General"
Steve Jones
April 22, 2003 at 10:26 am
Viewing 15 posts - 36,511 through 36,525 (of 39,903 total)