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

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

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

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

Blogging

Hi,
Yesterday while talking to my friend, he reviewed my blog and suggested that I was having so many spelling...

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

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

Impact of uninstall instance on replication.

Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...

Transaction Replication Backup/Restore or DR

Hi,Want to discuss on DR plan or Backup restore plan for transactional replication (here I will discuss on PUSH T...

A history lesson