Viewing 15 posts - 36,181 through 36,195 (of 39,771 total)
nicely put.
It's not that developers cannot be trusted, it's that they must earn trust. And controls must be implemented, especially now iwth the Sarbannes-Oxley act. Stupid mistakes that impact the...
June 26, 2003 at 11:58 am
Database Theory - so much stuff out there, none I recommend. This is a pain to search out on the web. I'd recommend books by Chris Date for this.
http://www.microsoft.com/sql/evaluation/anniversary/timeline.asp
What kind...
June 26, 2003 at 11:49 am
I still diasgree with allowing developers to schedule and run packages. In the real world, developers are not conservative by nature, not giving to performing good tests.
Therefore having them schedule...
June 25, 2003 at 10:21 am
June 25, 2003 at 10:09 am
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...
June 25, 2003 at 9:44 am
June 25, 2003 at 9:26 am
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...
June 25, 2003 at 9:20 am
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
June 25, 2003 at 9:16 am
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...
June 25, 2003 at 9:13 am
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
June 24, 2003 at 6:28 pm
same, same, same. Tempted to rebuild indexes. Update stats is a good idea. Will try later.
Steve Jones
June 24, 2003 at 6:26 pm
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....
June 24, 2003 at 12:27 pm
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
June 24, 2003 at 11:38 am
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...
June 24, 2003 at 11:36 am
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...
June 24, 2003 at 11:34 am
Viewing 15 posts - 36,181 through 36,195 (of 39,771 total)