How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?
1 15480What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
7 10357I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,
2 4280write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
6 20495I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
6 6520
What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....
What is PL/SQL Records?
What is ibdata1?
State the difference between union and union all?
How you would rewrite the sql query to return the customerid sorted numerically?
Can I delete event logs?
what is the different between now() and current_date()? : Sql dba
What is 3nf normalization?
Do accountants use microsoft access?
Explain types of indexing in dbms?
Can you please explain the difference between function and stored procedure?
Explain the terms specialization and generalization.
How to apply filtering criteria at group level in oracle?
Can you tell a way to know the number of days between the two given dates in php?
Is mongodb normalized?