SQL Server interview question notes: - Raise error
Point 1:- RAISERROR is used to raise error / warning back to the application or a catch block.
Point 2:- Syntax of RAISERROR is as below
RAISERROR (@Messageid -- Error message number stored in Sys.messages table
@ErrorSeverity, -- Severity ( 0-25)
@ErrorState -- State
@ErrorMessage, -- Error message string
Point 3:- You can raise system error message or user defined error message. For user defined error messages it should be greater than 500
11 Important Database designing rules which I follow
Rule 1:- What is the Nature of the application(OLTP or OLAP)?
Rule 2:- Break your data in to logical pieces, make life simpler
Rule 3:- Do not get overdosed with rule 2
Rule 4:- Treat duplicate non-uniform data as your biggest enemy
Rule 5:- Watch for data separated by separators.
Rule 6:- Watch for partial dependencies.
Rule 7:- Choose derived columns preciously
Rule 8:- Do not be hard on avoidingredundancy, if performance is the key
SQL Server interview questions: - Can you explain the essential components of SQL Server Service broker?
An SQL Server interview questions asked in the interview. So do read the following answer before going for an interview.
Following are the essential components of SQL Server:-
The endpoints can be two applications running on different servers or instances, or they can be two applications running on the same server.
A message is an entity that is exchanged between Server Brokers. A message must have a name and data type. Optionally, a message
SQL Server interview questions: - What do you mean by architecture of Notification Services?
This is the SQL Server interview questions which more of Database administrator (DBA) oriented. Have a look before going for interview. So one can start answering this question as follows.
Detail sections in SQL notification services:-
Notification Service application: - It’s a simple user application which will be used to add subscription to the subscription database.
Event providers: - All events reside in Event providers. There are two event providers which are provided by def
SQL Server interview questions: - Explain stateless and stateful load balancing?
Following way you can answer this SQL Server interview questions .
Stateless load balancer
Stateless load balancer uses the hashing algorithm. It takes packet from the client and selects fields from the packet to be hashed. For instance from each client it can take IP address and port number and hash them in to an integer between 1 to number of servers. You can see from the figure we have four servers. So the load balancer takes the IP address and port and hashes them with a number b
SQL Server interview questions: - Elaborate Fragmentation in SQL Server?
This is the SQL Server interview questions which are asked during the interview not so frequent. But still go through it once before going for the interview.
Speed issues occur because of two major things
Splits have been covered in the first questions. But one other big issue is fragmentation. When database grows it will lead to splits, but what happens when you delete something from the database…HeHeHe life has lot of turns right. Ok let’s say you
SQL Server interview questions: - Define publisher, distributor and subscriber in “Replication”?
This is the most expected asked SQL Server interview questions during the interview by the interviewer.
Publisher is the one who owns the database and is the main source for data. Publisher identifies what data should be distributed across.
Distributor is a bridge between publisher and subscriber. Distributor gathers all the published data and holds it until it sends it across to all subscriber. So as it is a bridge who sits in between publisher and subscriber, it supports multiple pu
SQL Server interview questions: - Show us relationship existing in database designing.
This is one of the most favorite SQL Server interview questions asked by the interviewer during the interview.
We have tried to keep answer as simple as we can. So starts the answer as, basically there are three major relationship models: -
Figure: - One-to-One relationship ER diagram
In this many records in one table corresponds to the one record in other table. Example: - Every one customer can ha