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

What are the advantages of sql azure?

140

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1916

---

What is a file group?

1092

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1064

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2752

---

Explain the ways to controlling cursor behavior?

919

---

How do you delete duplicate records in sql server?

1058

---

Explain the rules for designing files and file groups in sql server?

988

---

Explain the categories of stored procedure?

937

---

What is a database table?

971

---

What is the full form of ddl?

928

---

what are the important architecture components of SSRS?

140

---

Explain different types of collation sensitivity?

982

---

What are four major operators that can be used to combine conditions on a where clause?

1054

---

What is sql or structured query language?

1153

---