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...
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...
How to find the list of all the USER CREATED OBJECTS on a DB server? 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...
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
I am using DTS to import a large amount of data. My recovery model is SIMPLE. If i use bulk logged recovery model will my import speed increase?...
Since for the large tables count(*) is taking considerable time, following query was suggested to me by a friend. select max(rowcnt) from sysindexes...
How to check whether the sql2k server is functioning at its best? I was asked by my management how i am sure that our production DB is funstioning...
What is the single most difference between Logshipping and replication..? I think, therefore I am
Someone has deleted my production DB at 5pm. (lets say..). I need to recover everything till 4.59pm... what are my options...I think RAID will not...
Separate names with a comma.
