Category Archives : Sql Server Interview Questions

---

Sql Server Interview Question #12 :What are the different types of Collation Sensitivity?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged collation different sensitivity server sql on 12/18/2014 by Blog Admin.

Sql Server Interview Question: What are the different types of Collation Sensitivity?

---

Sql Interview question #11: Which TCP/IP port does SQL Server run on? How can it be changed?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged port server sql tcp/ip on 11/20/2014 by Blog Admin.

Sql Interview question #11 Which TCP/IP port does SQL Server run on? How can it be changed?

---

Sql Inteview Question #10 : What are catalog views?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged catalog server sql views on 10/27/2014 by Blog Admin.

Sql Inteview Question #10  What are catalog views? Solution

---

Sql Interview Question #9 : What is new in lock escalation in SQL Server 2008?

This entry was posted in Sql Server 2008 Sql Server Interview Questions Sql Server tutorials and tagged ddl dml lock escalation logon server sql trigger on 10/24/2014 by Blog Admin.

Sql Server Interview Question #9 What is new in lock escalation in SQL Server 2008?

---

Sql Interview question #8 : What is collation?

This entry was posted in Sql Server 2005 Sql Server 2008 Sql Server DBA Sql Server DEV Sql Server Development Sql Server Interview Questions Sql Server tutorials and tagged collation server sql on 10/23/2014 by Blog Admin.

Sql Server Interview question #8 What is collation? Solution Collation refers to a set of rules that determines how data is sorted and compared. Character data is sorted using rules that define the correct character sequence with options for specifying case sensitivity, accent marks, Kana character types, and character width.   Thanks for reading this […]

---

Sql Interview Question #7: What is a primary key?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged key primary server sql on 10/20/2014 by Blog Admin.

Sql Interview Question  What is a primary key?

---

Sql Interview Question #6: What are pessimistic and optimistic locks?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged locks optimistic pessimistic server sql on 10/18/2014 by Blog Admin.

Sql Interview Question What are pessimistic and optimistic locks?

---

Sql Interview Question #5: What is OLTP (Online Transaction Processing)?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged oltp online processing server sql transaction on 10/17/2014 by Blog Admin.

Sql Interview Question  What is OLTP (Online Transaction Processing)?

---

Sql Interview Question #4: What is the difference between an update lock and exclusive lock?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged difference exclusive lock server sql update on 10/16/2014 by Blog Admin.

Sql Interview Question What is the difference between an update lock and exclusive lock?

---

Sql Interview Question #3: What are different types of collation sensitivity?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged case collation kana katakana sensitivity width on 10/15/2014 by Blog Admin.

Sql Interview Question What are different types of collation sensitivity? Solution

---