What is the difference between seek predicate and predicate?
No Answer is Posted For this Question
Be the First to Post Answer
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?
Can a synonym name of a table be used instead of a table name in a select statement?
How you would rewrite the sql query to return the customerid sorted numerically?
What is a cursor in SQL Server 2000 and their types?
What is the system function to get the current user's user id?
What is the security principal at the server level that represents your session?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is xdr?
What is auditing in sql server?
How much memory that we are using in Logshipping Concept?
How to declare and use cursor variables?
What do I need to start working with sql studio? : sql server management studio
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)