I have a huge table which is accessed frequently for reports. Also data is getting inserted in this table frequently. I feel that data insertion is...
sp_trace_create can be used to create the trace on a trace file. Which SP can be used to create the trace in a TABLE? I think, therefore I am
Is there a way to turn off replication temporarily? In sybase i can do the following... SET replication OFF GO -- do the activities which need not...
After installing SQL2K, i have renamed my Win2k server name. When i execute the following query i get the old server name. SELECT @@SERVERNAME...
When i can disable the replication trigger using EM, why not i can't do it using T-SQL? I think, therefore I am
I want to delete some records from a table which is in merge replication. I don't want these records to be replicated to the subscribers. I am...
I have a table like following col1 col2 col3 -------------- c1 1 a c1 1 g c1 1 c c2 2 d c2 2 j i need the output as...
I have merge replication setup on my servers. 1. How to make merge replication one way? 2. How log shipping is better than merge replication? I...
I have setup log shipping, but my restoring job at the secondary server is not working. If i try restore the logs manually , it works fine. Any help...
How to find the EDITION for ANALYSIS SERVICES? I think, therefore I am
I need to transfer a huge amount of data from one server to another server locates across the countries over a narrow bandwidth. 95% of the space is...
Is there a single query? I think, therefore I am
How to find the list of all the USER CREATED OBJECTS on a DB server? I think, therefore I am
Where is the add-in manager? Unable to find it.... I think, therefore I am
How to script the cubes in analysis services... I think, therefore I am
I have implemented Performance counters on the productions DB. What is the effect of these counters on the server performance? Is there a counter...
Thanks a lot. This is a nice article. Wondering about that for a long time... I think, therefore I am
How to check at perticular moment whether it is on or off? I think, therefore I am
I want to check whether SET NOCOUNT option for my db server is ON/OFF? What is the T-SQL command? Thank You. I think, therefore I am
When to go for Merge replication and when for Transactional replication? I think, therefore I am
Separate names with a comma.
