Interested to Buy Any Domain ? << Click Here >> for more details...
Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?
1 3240i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
1903can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)
2 4617
What are the different types of backups avaialabe in sql server 2005?
What are data regions?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is sql server management studio? : sql server management studio
What do you mean by 'normalization'?
What is the recursive stored procedure in sql server?
between cast and convert which function would you prefer and why?
What is the difference between an index and a unique index?
What is an execution plan? When would you use it?
Do you know what are the ways available in sql server to execute sql statements?
What is db stored procedure?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Why should one not prefix user stored procedures with ‘sp_’?
What is the current limitation of the size of SQL Azure DB?
Write the SQL query to drop, truncate and delete table.
