The only book I could find is for SQL 2000. Mostly the same, but a good book. A Guide to SQL Server 2000 Transactional and Snapshot Replication. By...
I am developing a transactional replication plan. I have one table that most of the time I do not want to replicate deletions. There is an...
That's what I was afraid of hearing. I tried adding the column via EM and it timed out. From what I can figure out thus far, the only way I am...
I have a large table (130 million rows) that is highly available. I need to insert a new column (identity) to create a primary key. When I add the...
Parameter sniffing may have something to do with it. I will investigate further. I may have to force the stored proc to recompile with each...
I will revisit my testing. I did first use the Estimated Execution Plan to determine the differences. Without the FORCE ORDER hint the plan as...
I have a stored procedure that used to have the FORCE ORDER hint. Because the query was running way too long I removed the hint. This worked great...
Separate names with a comma.
