I have implemented Merge Replication with 1 publisher and 1 subscriber. I ran DBCC Reindex on the Publisher to Rebuild the indexes for the tables in...
I ran Sql profiler and got the following results for a stored procedure CPU of 3126; Duration of 1344 How do i interpret the above results. also what...
In the Process Info page of Activity Monitor in SQL Server Management Studio, a ProcessID is being blocked by itself. What is the reason or cause of...
Using the Process Info Page of Activity Monitor in SQL Server Management Studio, I can discover which Process ID has been Blocked another Process ID....
I have Two Database that exist on Two seperate servers. The two database contain same schema and contains tables and columns of same name. Some...
I need a script that returns the last identity value generated for each table in a database that has an identity column. I am using SQL Server 2005....
I want to Detach a publisher database running Transactional Replication, then move the .ldf (log files) to a different drive. I want to ensure that...
Is there a Tool/Utility/StoredProcedure/Query/View that can tell me the last time the data in a particular table was changed? That change can be the...
What SQL statement can i run to return a list of new tables or columns that exist in the Sales Database on Server A, which do not exist in the Sales...
In Merge Replication, how do you verify that all Records added at the Publisher is replicated/propagated to the Subscriber and all records added at...
I have a Column called SaleID in some tables in a Database.The SaleID column has the int datatype. I need a stored procedure that returns the next...
How do I update the OrderGUID column in Table B with Values from OrderGUID column in Table A. I have already populated the OrderGUID column in Table...
What is the best Method or Methods to test for GUID primary key performance vs identity column Primary key performance in SQL Server 2005. I am...
Separate names with a comma.
