Answer Posted / senthilkumar

Physical Properties of tempdb
The following table lists the initial configuration values of the tempdb data and log files. The sizes of these files may vary slightly for different editions of SQL Server.

File Logical name Physical name File growth
Primary data
tempdev
tempdb.mdf
Autogrow by 10 percent until the disk is full

Log
templog
templog.ldf
Autogrow by 10 percent to a maximum of 2 terabytes

Explain sql server authentication modes?

1083

---

What is transaction server implicit?

951

---

Explain Geometry datatype in sql server 2008 with example

928

---

Tell me about joins in database system and explain each in detail.

1009

---

What happens if null values are involved in bitwise operations?

971

---

Explain the disadvantages of cursors?

1063

---

Explain what is meant by replication of database?

967

---

What happens if null values are involved in string operations?

926

---

Does union all remove duplicates?

1022

---

Which are the olap features?

915

---

Comment,Datatypes are unlimited

2028

---

How to loop through result set objects using mssql_fetch_array()?

1028

---

How to create a Master database in SQL server ?

1031

---

Write a SQL command to insert and update only a particular field?

1049

---

How to create new databases with "create database" statements?

965

---