Have you checked the Stats for the Table?

Check for Pagefile, Recyclebin and all temp direcotries created when Installing any programs.

I would not want such a high Recompilation in my DB. That would mean locking the Cache to recompile a SP. Less locking of cache to recompile the better. Thats...

Do interviewers ask these questions? It has been a very very long time since I have gone for an interview... (Thank God for that). When I interview for post, I...

Within the cache...

I was looking up at the articles about L1, L2 and L3 caches. Yes, like Gail said, Hyperthreading will make the L Caches get cleaned out faster thus making it...

I did write an article about Row level versioning that uses the SNAPSHOT Isolation. For basic idea you can take a look at that.

http://www.sqlservercentral.com/articles/SQL+Server+2005/62464/

Please do let me know the vendors name sp that I know that we will never make bussiness ventures with them... 😀

Cant you trace the Dead locks by adding the...

Vikas, You were on the right track. What you wrote is the way to go.

drop the subscription only for the article that refers to your table.

This will make sure that...

Brian, I like this way better than my idea..:-)

I think even a db_owner is an overkill.

What I would suggest is to create a Role with the ddl_Admin as the rights to that particular DB and add the...

The Main problem with Snapshot is that it will cause dead locks. You want to create a Subscriber using Snap shot replication? That might work if you have a very...

Sorry I was out for Lunch. The issue is that when you have the distributor in your main production box, You are going to get more IOs. This would make...

Glad to be of help. Make sure you test it out throughly and script those things out. And then look at the scripts. Then you will learn how to fine...

What I usually do is use Scripts. I set up the distributor with the GUI. And after that it is all Scripts I use.

Then I know what I am...