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...
2009-10-09
1,943 reads
Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...
2009-09-29
1,650 reads
Hi,Want to discuss on DR plan or Backup restore plan for transactional replication (here I will discuss on PUSH T...
2009-09-14
1,691 reads
Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...
2009-09-08
726 reads
Hi All,Continue on Transaction replication discussion: Today I would like to share some of the important ways of handling/troubleshooting replication...
2009-09-08
659 reads
Just saw the the answer by michael Hotek for how log reader works on replication: looks very great:http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d2d2e1c6-01ee-439b-93e8-e31c77c0cd28/Thanks Michael Hotek...
2009-09-03
817 reads
Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...
2009-09-03
749 reads
Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...
2009-09-02
627 reads
Reading another great book ( I know its old but good book)...Inside Microsoft sql server 2005: T-SQL QUERYING....by Itzik Ben - Gan.
2009-08-30
1,591 reads
Hi,This script is very helpful, specially for sql server 2000. I made some changes into this.Thanx to T.Pullen for this...
2009-08-28
1,902 reads
By Brian Kelley
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...
By Steve Jones
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
I have an Access database with a SQL backend with tables, views, SP's. I...
Good morning, Once again, I find myself Sr. DBA for a company. As I...
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers