Viewing 15 posts - 36,436 through 36,450 (of 39,817 total)
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
April 22, 2003 at 10:24 am
Dave,
Apologies if someone snagged your email from here, but as Andy mentioned, we do not sell our emails. All information presented to advertisers is aggregated, so 20% of DBAs do...
April 22, 2003 at 10:21 am
This looks ok. When you say the backup folder is being appended, what does that mean? Can you give an example?
Steve Jones
April 22, 2003 at 10:16 am
You can use DTS to export the data and xp_sendmail or the mail task to then mail it.
Steve Jones
April 22, 2003 at 10:12 am
Note those extensions are defaults. You can call them anything you want.
Steve Jones
April 21, 2003 at 2:20 pm
you don't, but it doesn't make sense otherwise. You need something that is "grouped", which is the sum of something, count, etc.
Steve Jones
April 21, 2003 at 2:01 pm
No, this is by design. if you need to keep memory for your apps, limit sql to some amount.
Steve Jones
April 21, 2003 at 1:55 pm
I have not, though I know they are there. The single valued functions appear to come from the table.
Steve Jones
April 21, 2003 at 1:52 pm
With a 1GB box, I'd suspect SQL will get up to 800-850MB of RAM. That's normal as Brian explained.
Steve Jones
April 21, 2003 at 8:53 am
The BAK extension is usually a full backup. It contains the data and schema, not the mdf and ldf files.
Not sure why your backups are not being deleted. Which version...
April 21, 2003 at 8:51 am
This is in the wrong forum. I'd post this in the T-SQL forum
Steve Jones
April 17, 2003 at 5:43 pm
Viewing 15 posts - 36,436 through 36,450 (of 39,817 total)