Please read the Introductory Post before continuing reading interview questions and answers. What are the basic functions?
Interview Questions and Answers – Frequently Asked Questions – Day 6 of 31
Please read the Introductory Post before continuing reading interview questions and answers. Some more questions are included in the blog.
SQL SERVER – Find Details for Statistics of Whole Database
I was recently asked is there a single script which can provide all the necessary details about statistics for any database.
SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator
Today is Monday let us start this week with interesting puzzle. Yesterday I had also posted quick question here: SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers
SQL SERVER – BI Quiz Hint – Performance Tuning Cubes – Hints
I earlier wrote about SQL BI Quiz over here and here.
SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor
Microsoft SSIS Balanced Data Distributor (BDD) is a new SSIS transform.
SQL SERVER – Question to You – When to use Function and When to use Stored Procedure
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?