Interested to Buy Any Domain ? << Click Here >> for more details...
How would you choose between a clustered and a non-clustered index?
- 0 Answers
- 950 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do you find the error, how can you know the number of rows effected by last SQL statement?
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.
What is triggers and its types?
What are the differences between left join and inner join in sql server?
What is data modification?
Explain “@@rowcount” and “@@error” in sql server?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
Wht is Stuff in sql ser
What are trace flags and mention a few common trace flags used with sql server?
What the different components of Replication and what is their use?
Describe about first three Normal forms.
How do I shrink an ldf file?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
