Viewing 15 posts - 391 through 405 (of 575 total)
How did you try to export the data with a scheduled job? I mean BCP etc......
July 6, 2004 at 9:22 pm
Some sample code from you would make this easier however, it goes something like this;
UPDATE Table SET Column = T.Column
FROM TempTable T INNER JOIN Table X ON T.Pkey = X.Pkey
WHERE...
July 6, 2004 at 7:23 pm
SELECT ColumnA, ColumnB
FROM TableX A
WHERE NOT EXISTS( SELECT * FROM TableY B WHERE A.SSN = B.SSN)
OR
SELECT ColumnA, ColumnB
FROM TableX A
WHERE A.SSN NOT IN ( SELECT SSN FROM TableY)
July 6, 2004 at 6:41 pm
I'm sure other who have VLDB's will add to my list!
(A) Maintenance! For VLDB's, you will have to find a window of opportunity to perform Database Maintenance as it will...
July 6, 2004 at 5:55 pm
It's possible that the Mapi.DLL could be corrupt! Don't take my word for it, I'm just going throught he elimination process in my mind and scene as though you have...
July 6, 2004 at 5:50 pm
Am I missing something here? Correct me if I'm wrong but to solve this, wouldn't you just have to increase the VARCHAR(36) Column to VARCHAR(38) or perhaps VARCHAR(40) to be...
July 6, 2004 at 5:42 pm
If you have placed UniqueIdentifier COlumns on all your tables then Merge Replication will not duplicate that! However, it will put UniqueIdentifier Columns on your lookup tables as well. Don't...
July 6, 2004 at 5:38 pm
More info is needed! Was there any errors? Show us your code!
Shouldn't you be able to just update the row from Access to SQL Server via Linked Tables within Access?
July 5, 2004 at 11:19 pm
The Index is corrupt!
Perform a consistency check on the Database and then either perform a DBCC DBREINDEX or DROP it & Re-Create it, then perform the delete operation again!
July 5, 2004 at 7:34 pm
Landrake,
Avg. Pages per Extent........................: 8.0
Implies that there are 8 Pages per Extent. This means that the data is contigious.
July 4, 2004 at 8:37 pm
Please give us some more info to work with!
Example; What SQL Server version, At what stage is the SQL Mail process slow etc....
July 4, 2004 at 7:38 pm
How critical is it to update the aggregations on the other Tables ? Example; RealTime, every 1 hour etc...
July 4, 2004 at 5:42 pm
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
Viewing 15 posts - 391 through 405 (of 575 total)