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

Introduction 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 R

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:- End-Points The endpoints can be two applications running on different servers or instances, or they can be two applications running on the same server. Message A message is an entity that is exchanged between Server Brokers. A message must have a name and data type. Optionally, a message

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

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

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 Fragmentation. Splits. 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

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

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: - One-to-one Figure: - One-to-One relationship ER diagram One-to-many In this many records in one table corresponds to the one record in other table. Example: - Every one customer can ha