We might need a new forum for this technology! Ive taken on a new sql2008 client who is encountering some recent performance problems, Mostly the...
Switched partitions dont support replication but are they supported on mirrored databases, im guessing not but would like a definitive answer ?
I have a sql2008 reports server running on win 2003 and sql server 2008 (sp1) and a development machine running windows 7. I cant deploy reports...
When a sql 2005 database has a shared folder icon in studio what is it indicating ? is this an indication db mirror is enabled ? Colin
Any one now how to create a percent of total column with areport builder report, or as a calculated value in the model? I can manage it in a normal...
Anyone got any pointers/comments to replicating databases with full text indexing enabled. Does each server need to maintain its own Full text index...
The following script creates and starts a trace for long running sql on our server with a max of 5 20mb rollover files, however if the server has...
thanks but none of these return the value im after "current column value '272382'" in my case the Last row in the table has a higher value than the...
Checking identity information: current identity value '270000', current column value '272382'. DBCC execution completed. If DBCC printed error...
we have two VM Environments and 4 Enterprise 2005 Licenses purchased in Jan before ms changes to virtual licensing in June. can we assume the June...
Im attempting to load test a peer 2 peer replication using sql2005 enterprise and thought I could trace a production day using profiler and replay...
is there a method to estimate how long index creation will take on very large tables. (in most cases the index would be complete before the calc was...
Im researching Peer to Peer for implementation at a client and one of the highlighted risks so far is the lack of information on resolving any...
As an example I have a sample release script that executes fine on the publisher but with p2p replication turned on fails to apply fully on the...
Red gate have confirmed it as not currently supported but are keen to provide replication support in the future. Apex simply suggested posting it as...
Im a great fan of Red-gates Product Line but sql compare wont yet create difference scripts with replication dependancies like not dropping objects...
Tried again with different server( x86 ent edition 9.0.3042), same build, new database,New Table, new Index and new maintenance plan. and got the...
Cheers OLA, Yours is correct which raises the question Why is mine is incorrect with the same build number (im using x86 enterprise) there must be a...
Satya, I would like profiler to script the code out as single quotes as we have multiple date parameters in the queries we are profiling. we also...
slq server 2005 build 3042 Our Db grew from 50GB to 200Gb overnight. It turned out that the cause was some weird behavior from the SSIS rebuild...
Separate names with a comma.
