Viewing 15 posts - 1,531 through 1,545 (of 5,103 total)
October 2, 2007 at 4:00 pm
could you suggest few procedures of how to check the index fragmentation and file fragmentation?
also, the deadlocks errors : error:1205, severity 13 occurs atleast 200 times a day in the...
October 2, 2007 at 3:53 pm
I have not done it for that many on the same server but I know people who has done it for over 200+. So you are not anywhere near the...
October 2, 2007 at 2:02 pm
the snapshot agent is the one that posts the "snapshot generated" on the distribution DB and from there is picked up by distrib.exe
October 2, 2007 at 1:37 pm
SQL Noob (10/1/2007)
no can do, i get an error about the db being part of the replication or something like that
if the subscribers are "pull" subscribers I know for a...
October 2, 2007 at 1:35 pm
ALTER TABLE bvc_Affiliate
ALTER COLUMN [DisplayName] NULL -- allow nulls
ALTER TABLE bvc_Affiliate
ALTER COLUMN [DisplayName] NOT NULL -- do not allow them
October 2, 2007 at 9:09 am
Nothing without study is easy but once you get to practice and get your feet wet with the documentation is easy to handle. In this case you just set up...
October 1, 2007 at 4:22 pm
because you are already in the undocumented world you should try:
select [Object Name], [Index Name]
from ::fn_dblog(null, null)
Note that ::fn_dblog is also undocumented and probably a wrapper of...
October 1, 2007 at 4:18 pm
Handles are Windows tools to manage limitted OS resources like bitmaps, brushes, Fonts, etc... It does happes that Handles are a limmited pool also and when you load many apps...
October 1, 2007 at 4:09 pm
Definitely possible. Do the tables overlapp ? If they don't then is pretty easy. If they do you should worry about PK collisions and reinitialization issues.
Cheers,
October 1, 2007 at 3:53 pm
There are definitely many "details" different but if you master the core on 2000 there is nothing that prevent you from quickly use the new features.
October 1, 2007 at 3:50 pm
These situations are tough and you should definitely learn from them.
Life is not Back or White there are a bunch of grays and you should balance your attitude. I...
October 1, 2007 at 3:48 pm
this is just another reason to get rid of cursors ... 😀
October 1, 2007 at 3:31 pm
Erm ...
waittime is in MILLISECONDS ...
select 2147483647 / (1000*60*60)
-- 596 Hrs
October 1, 2007 at 3:29 pm
Great, glad it worked for you.
Unfourtunately can't help you on the "how it happened" 🙂 someone must have setup replication in it at some point but is up to you...
October 1, 2007 at 3:25 pm
Viewing 15 posts - 1,531 through 1,545 (of 5,103 total)