Viewing 15 posts - 961 through 975 (of 1,348 total)
our devs would write code in 2000 which would look like
select col1, col1 from some_table order by col1
why they did this, no one knows. but it broke in sql 2005...
December 18, 2007 at 7:10 am
if you have EMC SAN's just use SRDF. we mostly go R/O when we have several hours of downtime and R/W when there is a few days, like when we...
December 18, 2007 at 7:08 am
why not just use SQL 2005 AS?
December 18, 2007 at 7:01 am
in my experience with SP2 you have to reboot both nodes since it will upgrade files on both nodes and the shared SQL files on the shared storage. it's pretty...
December 18, 2007 at 6:56 am
stupid auditors strike again
one of the recommendations they told us to implement is to require MS DTC for everything. changed it on a few servers on Friday and now replication...
December 17, 2007 at 8:59 am
if you are running windows 2003 you can check out the new http based replication. i forgot the exact name of it and you might need to set up IIS...
December 17, 2007 at 7:50 am
Matt Miller (12/15/2007)
December 17, 2007 at 7:49 am
GSquared (12/12/2007)
December 14, 2007 at 10:03 am
can you install SP2 again?
we had a similar issue and if you to the control panel and rerun sql setup there is a repair option that will allow you...
December 6, 2007 at 12:11 pm
local security policy on the server in the user rights assignment
add the account that SQL is running under
December 4, 2007 at 1:51 pm
so far we haven't secured SQL against anyone, but hopefully we will do it on some servers. we are also going to look at forcing people to use their local...
December 4, 2007 at 1:47 pm
Philip Horan (11/28/2007)
November 29, 2007 at 7:53 am
Philip Horan (11/27/2007)
Redundant Fans / PSU / Processor.........
Each server has 8 HDD Bays. 2 Xeon QUAD Core...
November 27, 2007 at 4:11 pm
the old one was, but the new 64 bit one is nice. we combined several distributors to make this new one and it's faster than the old two combined
November 27, 2007 at 11:29 am
this is a monthly process so i was hoping to speed it up while keeping it only as SQL replication and not dropping the replication. table is close to 300...
November 27, 2007 at 10:58 am
Viewing 15 posts - 961 through 975 (of 1,348 total)