in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

---

What is a covered index?

0 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

What methods do you follow to protect from sql injection attack?

0 Answers  

---

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,

---

How to connect to a sql server using odbc_connect()?

0 Answers  

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

What are the requirements for sql server 2016?

0 Answers  

---

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---