Answer / tauseef

unique identifier data type size is 16 bits.
while creating table we have to create unique identifier
datatype column. it will create unique identity column
with 32 charcters and not 16 characters

Answer / ranjit kumar routhu

unique identifier data type size is 16 bits.
while creating table we have to create unique identifier
datatype column. it will create unique identity column
with 16 charcters
ex: create table a( id uniqueidentifier default newid
(),....),newid() generates new 16 unique charcter values

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

What are “phantom rows”?

0 Answers  

---

---

How to use transact-sql statements to access the database engine?

0 Answers  

---

What are relationships and mention different types of relationships in the dbms

0 Answers  

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

What are built in functions?

0 Answers  

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  

---

Explain indexed views?

0 Answers  

---