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

1120

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1042

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

1000

---

how can you check the level of fragmentation on a table? : Sql server administration

1041

---

what stored procedure would you use to view lock information? : Sql server administration

1024

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1061

---

what stored procedure can you use to display the current processes? : Sql server administration

1057

---

what information is maintained within the msdb database? : Sql server administration

1017

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1030

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

1030

---

can a table be moved to different filegroup? : Sql server administration

1021

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1135

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1305

---

What is the difference between a fill factor of 100 and 0?

1031

---

A trigger can reference objects outside the current database? State true or false.

1061

---