Viewing 15 posts - 406 through 420 (of 576 total)
I don't believe adding a column to a table with existing data can cause any level of Fragmentation! I just had a thorough look in BOL and some other info...
July 1, 2004 at 10:43 pm
Scan Density [Best Count:Actual Count].......: 99.98%.
This means that there is very very very very little fragmentation!
Could you please elaborate on what you are trying to say?
July 1, 2004 at 5:13 pm
What do you mean "when it runs for the first time"?
If you have set it up to NOT perform a Snapshot, then it shouldn't be doing it!
June 30, 2004 at 10:47 pm
SELECT TOP 10 Issue.IssueName, COUNT(Issue.OccasionID)
FROM Issue
GROUP BY Issue.IssueName
ORDER BY Issue.IssueName DESC
June 30, 2004 at 6:58 pm
That all depends on how you Scripted the Replication process! Did you script the jobs as well? If you didn't, thats why it failed.
June 30, 2004 at 5:13 pm
I will assume that the SQL Server that you generated the Replication script from is the same server that you are executing the script!
June 29, 2004 at 5:39 pm
I use Visio 2002 Enterprise Architect!
June 28, 2004 at 11:07 pm
This means that Shared Locks will not be placed on rows that are read from the query. In addition, you will be allowing dirty reads that may cause your query...
June 28, 2004 at 11:06 pm
By default Merge Replication will place rowguid columns on all Tables that are in a Publication and you cannot stop that because SQL Server will create triggers &/or Stored procedures...
June 28, 2004 at 10:53 pm
UDF's work like cursors! I guess it depends on how quickly you want the process to finish!
June 28, 2004 at 5:35 pm
Problems with installing Outlook on a SQL Server? What a load of rubbish!
I have been a SQL Server DBA for 5 years and have followed the process of installing Outlook...
June 28, 2004 at 5:32 pm
You should be able to register with the netbios name of the server. This will not affect anything!
June 28, 2004 at 5:27 pm
I can't see a problem with using Merge Replication for this requirement. Just 1 question though, is this going to be a regular process or just a once off task...
June 28, 2004 at 5:25 pm
If you do not want to use a third party product then you can use DTS.
June 28, 2004 at 5:23 pm
You will probably be able to do this in one of the Schedule tables in the MSDB Database, but I WOULD NOT RECOMMEND UPDATING SYSTEM Databases.
You will probably be safer...
June 27, 2004 at 8:50 pm
Viewing 15 posts - 406 through 420 (of 576 total)