Forum Replies Created
Viewing 15 posts - 36,136 through 36,150 (of 39,720 total)
-
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
-
RE: SSWUG and PASS
Not sure about SSWUG (biased as well).
PASS conference is a good place to learn and meet people, not sure about the added value of the association.
Steve Jones
-
RE: Turn on the MS SQL Server counters for Performance
Run performance monitor. Start | Administrative Tools | Performance.
Steve Jones
-
RE: SQL and IIS on the same Box?
I'm sure Mr. Poole might give Andy, Brian, and myself a small tap on the noggin. We indeed run IIS and SQL on one box, more a matter of economics...
Viewing 15 posts - 36,136 through 36,150 (of 39,720 total)