Forum Replies Created
Viewing 15 posts - 36,316 through 36,330 (of 39,903 total)
-
RE: Documentation
-
RE: Do you think education matters?
You can't measure it. In fact, you can't measure many things. Your decision to hire, or the decision to hire you has a lot of emotion involved. I mean A...
-
RE: 6502
-
RE: How much do you earn?
Don't despair newbies!! The $$ will come, but I know that I cut my teeth on many projects that were fu...err... designed by non technical people and I learned a...
-
RE: Hyper-threading
I saw that one. Was concerned about W2K server performance. Most of the MS information is now focusing on W2K3, so I thought I might be missing something.
Steve Jones
-
RE: Server Performance
hurcane and Randy are on the right track. We tagged this late last night and I'll be writing it up further in an article, but it was network, but not...
-
RE: Trigger to Update two fields in table
create trigger mytrigger on mytable for update
as
update mytable
set lastuser = suser_sname()
, lasttime = getdate()
from inserted
where inserted.pk = mytable.pk
Steve Jones
-
RE: Server Performance
same, same, same. Tempted to rebuild indexes. Update stats is a good idea. Will try later.
Steve Jones
-
RE: Server Performance
Execution plan on both is clustered index scan.
sp_configure is the same, all values
memory usage is about the same on both, 1,716,328 on one, 1,717,068 on the slower one.
got me stumped....
-
RE: Hyper-threading
Thanks for the link. That is interesting. I thought people were saying that performance had decreased in some benchmarks, but I haven't been able to find anything.
Steve Jones
-
RE: EMAIL in TRIGGER
bad idea, imho. Insert the data into some table with a timestamp and then have some job come along every minute and pick up the data and send the email.
Steve...
-
RE: Do you think education matters?
Thinking outside the box, having a "feeling" for the server, seeing the forest for the trees. These are tough things and I'm not sure how much you can learn about...
-
RE: MS SQL Server 2000 vs Oracle
Not much of an Oracle guy, seems cumbersome and complex (unnecessarily). That being said, it's a more mature product and I'd guess it will scale better than SQL Server. However,...
-
RE: Too many messages on opening and closing data file
Check the database properties. Probably set to auto close.
http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp
Steve Jones
-
RE: I suggest not using black-on-black for registratio
I see this sometimes in Mozilla, rarely in IE. It's a bug somewhere between Snitz and the ad server I suspect.
Apologies
Steve Jones
Viewing 15 posts - 36,316 through 36,330 (of 39,903 total)