venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL Server Interview question - Part 2
http://venkattechnicalblog.blogspot.com/2008/09/sql-server-interview-question-part-2.html
Welcome to SQLServer MVP Blog. SQL Server Interview question - Part 2. Normalization is the basic concept used in designing a database. Its nothing but, an advise given to the database to have minimal repetition of data, highly structured, highly secured, easy to retrieve. In high level definition, the Process of organizing data into tables is referred to as normalization. What is a stored procedure:. What is the difference between UNION ALL Statement and UNION? Example for Stored Procedure? Sp who2 R...
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -4 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech
http://venkattechnicalblog.blogspot.com/2014/05/sql-server-interview-questions-2014_5476.html
Welcome to SQLServer MVP Blog. SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -4 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech. SQL SERVER INTERVIEW QUESTIONS 2014- SET 4 By. The Asia, India &. Book Of Record Holders ]. SQL Server Interview Questions 2014. Gives you the interview tips for SQL Server. SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS. 1 Explain the following. Collation is a type of sort order. There are mainly three types of sort orders, namely:. I) Dictionary case sensitive.
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL Server Interview questions
http://venkattechnicalblog.blogspot.com/2008/09/sql-server-interview-questions.html
Welcome to SQLServer MVP Blog. SQL Server Interview questions. What is the significance of NULL value and why should we avoid permitting null values? Null means no entry has been made. It implies that the value is either unknown or undefined. We should avoid permitting null values because. Column with NULL values can't have PRIMARY KEY constraints. Certain calculations can be inaccurate if NULL columns are involved. What is SQL whats its uses and its component? SELECT to get rows from tables. Straight fo...
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -6 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech
http://venkattechnicalblog.blogspot.com/2014/05/sql-server-interview-questions-2014_7867.html
Welcome to SQLServer MVP Blog. SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -6 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech. SQL SERVER INTERVIEW QUESTIONS 2014- SET 6 By. The Asia, India &. Book Of Record Holders ]. SQL Server Interview Questions 2014. Gives you the interview tips for SQL Server. SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS. 1What is the difference between a “Local Temporary Table” and “Global Temporary Table”? Dynamic Management Views (DMVs). Are functions that give y...
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL Server interview questions
http://venkattechnicalblog.blogspot.com/2008/09/sql-server-interview-questions_11.html
Welcome to SQLServer MVP Blog. SQL Server interview questions. Some more SQL Server interview questions:. What are the authentication modes available in SQL Server? Three types of authentication available,. 1 Windows authentication - SQL Server authenticates based on the login windows user. 2 SQL Server authentication - A specific user leve authentication will be available to login into SQL Server. 3 Mixed mode authentication - It's a combination of windows and SQL Server authentication. Rebuilding index...
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -7 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech
http://venkattechnicalblog.blogspot.com/2014/05/sql-server-interview-questions-2014_721.html
Welcome to SQLServer MVP Blog. SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -7 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech. SQL SERVER INTERVIEW QUESTIONS 2014- SET 7. The Asia, India &. Book Of Record Holders ]. SQL Server Interview Questions 2014. Gives you the interview tips for SQL Server. SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS. 2 What are synonyms? 3 What is LINQ? Tools to create classes (usually called entities) mapped to database tables. The DataContext class, with feature...
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL Server Interview Questions
http://venkattechnicalblog.blogspot.com/2008/09/sql-server-interview-questions_27.html
Welcome to SQLServer MVP Blog. SQL Server Interview Questions. Database management system is considered as the system to store the data for easy retieval and the data were relatively stored as a group. Whereas, Relational database management system will include a relationship between tables (using constraints). The relationship will be based on their logical relations. Considering,. SQL Server Vs MS access:. I used to see this question acess vs sql server,. SQL Server is a RDBMS and works as a Server lev...
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL Interview questions
http://venkattechnicalblog.blogspot.com/2008/09/sql-interview-questions.html
Welcome to SQLServer MVP Blog. Below are some of the maximum capacity for SQL Server 2005: (Frequently asked interview questions in sql server). Maximum Number of tables : No restrictions (Until your harddisk size you can create tables). Maximum bytes per row in the table : 8060 bytes. Maximum tables in a select statment - 256. Maxiumu references per table - 253. Maximum rows in the table - Unlimited (Depends on the storage). Maximum columns per base table : 1024. Bytes per Group by or Order by = 8000.
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -10 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech
http://venkattechnicalblog.blogspot.com/2014/05/sql-server-interview-questions-2014_8013.html
Welcome to SQLServer MVP Blog. SQL SERVER INTERVIEW QUESTIONS 2014 BOOKLET -10 By Mr.J.Venkatesan Prabu - Managing Director of Kaashiv Infotech. SQL SERVER INTERVIEW QUESTIONS 2014- SET 10 By. The Asia, India &. Book Of Record Holders ]. SQL Server Interview Questions 2014. Gives you the interview tips for SQL Server. SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS. 1 When setting Replication, can you have Distributor on SQL Server 2005, Publisher on SQL Server 2008? Row compression and Page compression.
venkattechnicalblog.blogspot.com
Welcome to SQLServer MVP Blog: SQL Interview Questions
http://venkattechnicalblog.blogspot.com/2008/09/sql-interview-questions_27.html
Welcome to SQLServer MVP Blog. Local and Global Cursor :. While declaring the cursors, we can specify a cursor as Local or Global cursor. Local Cursor will exists for the particular object and it cannot be reference by an external object. By default, cursors are Local. If we need to make it as global and can be accessed by all the objects. We need to specify it as global. If the cursor is declared as Global, it can be accessed by all the objects in the existing connection. Red color is the subquery.