This week has been very interesting week. I have asked few questions to users and have received remarkable participation on the subject.
Q1) SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)
Q2) SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
Keeping the same spirit up, I am asking the third question over here.
Q3) When to use User Defined Function and when to use Stored Procedure in your development?
Earlier this weekend I have presented at Bangalore User Group on the subject of SQL Server Tips and Tricks. During the presentation I have asked a question to attendees. It was very interesting to see that I have received various different answer to my question. Here is the same puzzle for you and I would like to see what your answer to this question.
I was recently attending a small meeting where I was asked if I can share few things to be considered when designing SQL Azure database. Today I am sharing the same notes over here.
SQL Server has a feature which copy database from one database to another database and it can be automated as well using SSIS.
A very common question which I often receive is What is SQL Azure?
I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can be scheduled in SQL Server Agent Job.
First of all – I must confess that I was not aware of this feature till I noticed it today. At home, I have multiple monitors, but when I am traveling, I have single laptop along with me. It is often that when I am working with SQL Server I have to refer web for information on the subject I am working on. Let us understand about SSMS Browser in this blog post.