Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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 “updated” :-) …. NO their is no updated table in… Read more

0 comments, 586 reads

Posted in Vinay Thakur on 30 October 2009

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 setup:

This is by Alexander Chigrik at database journal you can… Read more

0 comments, 549 reads

Posted in Vinay Thakur on 28 October 2009

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 information.

Found following information helpful to me today (*as I…

Read more

0 comments, 234 reads

Posted in Vinay Thakur on 23 October 2009

Some useful commands and sp I use for Transaction Replication:

I write several blog  about replication and mansion commands and stored procedure related to transaction replication, but I would like to dedicate one blog (series of blogs) which should have all these information.

>>Some useful commands and stored procedures

How it works:

Log reader agent stores the command and transaction…

Read more

0 comments, 532 reads

Posted in Vinay Thakur on 23 October 2009

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 

--- commands for all transactions for replication for seqno or… Read more

0 comments, 2,557 reads

Posted in Vinay Thakur on 23 October 2009

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 SID and logins which are not exists. And then after…

Read more

0 comments, 184 reads

Posted in Vinay Thakur on 22 October 2009

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 everything about this as well as provide us some good links. Read more

0 comments, 220 reads

Posted in Vinay Thakur on 16 October 2009

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 credential to server A, I am not having any access… Read more

0 comments, 251 reads

Posted in Vinay Thakur on 14 October 2009

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 Live Writer to write a blog… hope now on I…

Read more

0 comments, 165 reads

Posted in Vinay Thakur on 13 October 2009

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.)
 
 
update statistics and rebuild index: the rebuild index will rebuild the index statistics as…

Read more

0 comments, 281 reads

Posted in Vinay Thakur on 9 October 2009

Select count(*)

 

Today I was reading(I always read Paul Randal).

http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx

I learned that whenever you query select count(*) it will select the the best plan... as

if no index ---no option -table scan

INDEX: choose the smallest possible index(if has multiple index) to achieve the lowest I/O cost.

you can… Read more

0 comments, 720 reads

Posted in Vinay Thakur on 9 October 2009