Yes Eric, it is worth experimenting to find the performance issues before saying yes or no. I would triple (0r based on growth rate) the data in some large tables...

Thanks Ed, that helps a lot

I believe it is a freeware?

If yes, I can check with my org to install on Dev db.

My company has central database server and all other database servers subscribe to that central server to keep a local copy (nightly replicated). That way I dont need to use...

For .NET or Java, we have better tools for writing unit tests. Do we have good unit testing tools for SQL?

Good One and thanks for sharing.

Recently, I was trying to simplify the process of accessing data for users in my org. My company uses two OLAP servers at two different sites for performance sake. I...

I am developer and often put my quick observations in excel and do some formatting to make it look better. Then I copy this into the email. I do this...

Thanks e4d4. I have not tested a scenario to write data using SP call from app. But I will test and post results.

My other test that I said earlier...

That is very funny SQL. Million likes to below86 :-):-)

I agree that individual should feel comfortable irrespective of formal or casual wear.

Thanks Bob, This is interesting statistics to look on.

For me, local server (on west coast) ping time =1ms and remote server (on east coast) ping time=71ms.

Should we consider 70ms...

In USA, I worked at different client locations. My general perception is that more of west coast companies allow to wear casuals and more of east coast companies have formal...

Thanks Gail.

I am planning to do a vb test and the only functionality it is to read and write to database recursively. I will do this with connection string...

Nice article. Yes, we never know till we meet new buddies. Being technology ppl, the new friendships can make us rich both mentally n financially