Answer / Asheesh Kumar Pandey

SQLCMD doesn't have built-in functionality for verifying usernames. You can check if the username exists in the database by running a SELECT statement using the 'sp_login' system stored procedure.

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

1 Answers  

---

What does truncate do?

1 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

What is a performance monitor?

1 Answers  

---

What is a cube? : sql server analysis services, ssas

1 Answers  

---

How can you append an identity column to a temporary table?

0 Answers  

---

Do comments need to go in a special place in sql server 2005?

1 Answers  

---

How do I save a stored procedure in sql server?

1 Answers  

---

What is an active database?

1 Answers   HCL,

---

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

1 Answers  

---

How do I install sql server?

1 Answers  

---