Viewing 15 posts - 36,676 through 36,690 (of 39,720 total)
Good points. I might also add that more developers need to learn humility and learn to detach themselves.
I too often find developers who commit to a plan without being willing...
December 20, 2002 at 9:48 am
I do what Antares suggested when I want to track changes.
Triggers on system tables are not guarentted to fire.
Steve Jones
December 19, 2002 at 3:55 pm
Not a bad solution. I've done something similar, but I let each server query itself and store the results in a table. Then I have a master server that queries...
December 19, 2002 at 3:52 pm
The formats are different, but I'm not sure if that was your issue.
I generate a unique filename each night so I always know which backup I've got stored in the...
December 19, 2002 at 11:31 am
No info, but with a buffer problem like this, I'd call PSS. Perhaps take another backup, try to BCP out the data in the table, drop, rebuild the table, then...
December 19, 2002 at 9:54 am
Was wondering about that post.
I think this is where what we do is more of an art than a science. Each work is unique (to a large extent) and works...
December 19, 2002 at 9:50 am
I track changes:
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve Jones
December 19, 2002 at 9:44 am
Two different things. Logically. The PK is the unqiue identifier for the data row. A unique index preseves uniqueness in the column.
Physically they are implemented the same.
Steve Jones
December 19, 2002 at 9:40 am
I concur with Scorpian.
Steve Jones
December 19, 2002 at 9:36 am
I'm not sure how this can be done. If dbcc errorlog doesn't work, then you may just need to cycle the server.
Sorry, don't have a v6.5 server to test with.
Steve...
December 19, 2002 at 9:30 am
I've seen that too, though it's changing. More and more I'm seeing tech pros paid more than their manager. Comes a limit, however, since managing entails more responsibility at some...
December 18, 2002 at 4:52 pm
Should be able to sp_configure 'allow updates to system tables', and then reconfigure and then change the values manually.
Steve Jones
December 18, 2002 at 4:49 pm
Let us know how it goes. Be interested to hear if you do get some good results either on the app or looking at NT v 2K.
Steve Jones
December 18, 2002 at 1:19 pm
Not anything specific. Some articles on this site that touch on it, some better than others.
If they suspect slowness, run Perf mon and look for CPU spikes, cache hit ratio...
December 18, 2002 at 12:52 pm
Viewing 15 posts - 36,676 through 36,690 (of 39,720 total)