Answer Posted / hari

Windows authentication is more securable compare to mixed
mode authentication.

How do I find my localdb version?

498

---

Does order by actually change the order of the data in the tables or does it just change the output?

686

---

What is table valued function and scalar valued functions?

497

---

How to update a field in SQL after ALTERING a row?

690

---

Is it safe to delete log files?

527

---

---

Who developed sql server?

535

---

What is the purpose of the model database?

603

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

540

---

What will be the maximum number of index per table?

592

---

What is in place upgrade in sql server?

524

---

What is indexing and its types?

532

---

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2020

---

What is data compression? : sql server database administration

550

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1579

---

What is acid properties?

597

---