Monthly Archives: October 2009

Consider this while doing any UPDATE

Trigger: When you create trigger for insert and delete we will get two reference table as “inserted” and “deleted” respectively now what if we create a trigger for “update” on trigger, your answer might be  we will get reference table … Continue reading

Posted in Computers and Internet | 1 Comment

Replication Setup:

  I saw too many questions on forum asking step by step process of configuring replication I have these links in my favorites so though consolidating it. For Sql Server 2000: Snapshot Replication setup: By Alexander Chigrik  http://www.databasejournal.com/features/mssql/article.php/1458491/Setting-Up-Snapshot-Replication-A-Step-by-step-Guide.htm Transaction Replication … Continue reading

Posted in Replication | Tagged | Leave a comment

Transaction isolation level

We should be aware of some information about Isolation level. As the transaction is depends on isolation level the level. Sql server has following Isolation levels: 1. Read Uncommitted (No Lock) 2. Read Committed (Blocking) 3. Repeatable Read (Phantom) 4. Snapshot  … Continue reading

Posted in Basic, Computers and Internet, Isolation Level, Lock/Blocking | Tagged , | 7 Comments

Tricks and issues Part 1

Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see the comments on his Blog. Great job and thank you Pinal for having such a wonderful site and sharing valuable … Continue reading

Posted in What I learned today | Tagged , | Leave a comment

Some useful commands and sp for Transaction Replication

This blog is having some useful commands we use for replication and troubleshooting. >>Some useful commands and stored procedures How it works: Log reader agent stores the command and transaction into following tables. 1.      distribution.dbo.MSrepl_Commands  eg. SELECT * FROM distribution.dbo.MSrepl_Commands  … Continue reading

Posted in Replication | Tagged | Leave a comment

Logins no longer exists.

Today while checking the logins, just want to clear/clean logins which are no longer exists on NT domain. To get the logins which are no longer exits run the following: EXEC master.dbo.sp_validatelogins http://msdn.microsoft.com/en-us/library/ms181728.aspx It will show you the list of … Continue reading

Posted in What I learned today | Tagged | 5 Comments

Table Variable and Temp Table

  Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I would like to keep this blog as my reference to this so blogging about it. http://www.sqlservercentral.com/articles/Temporary+Tables/66720/ This blog  explains … Continue reading

Posted in What I learned today | Tagged | 1 Comment

Network backup Access via Query Analyzer

Hi, Today while working on query analyzer found very interesting thing about security. My sql server A is running with service account which is same as service account of server B and having all access.and I am login with my … Continue reading

Posted in Computers and Internet | Leave a comment

Blogging

Hi, Yesterday while talking to my friend, he reviewed my blog and suggested that I was having so many spelling issues in my blog… so was working from morning to correct that and finally feels its corrected. I installed Windows … Continue reading

Posted in Computers and Internet | Leave a comment

Reindex and Update stats.

Today I was reading blog by Ben Nevarez it is great… (I am impressed with ben now a days) that’s why Kalen always ask him for reviewing his book (all INSIDE books reviewed by Ben.)   http://sqlblog.com/blogs/ben_nevarez/archive/2009/10/06/rebuilding-indexes-vs-updating-statistics.aspx   update statistics … Continue reading

Posted in What I learned today | Tagged , , | Leave a comment