List the different index configurations possible for a table?
- 0 Answers
- 673 Views
- I also Faced
- E-Mail Answers
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What type of locking occurs during the snapshot generation? : sql server replication
What is de-normalization and what are some of the examples of it?
Why we use functions in sql server?
What is purpose of normalization?
Why Master database is required?
How to provide values to user defined function parameters?
How to execute a stored procedure in ms sql server?
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?
What is a cursor in SQL Server 2000 and their types?
how to invoke a trigger on demand? : Sql server database administration
How can a user-defined datatype be created?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
