What do you mean by an execution plan? Why is it used?
No Answer is Posted For this Question
Be the First to Post Answer
What is tablesample?
Does sql server use t sql?
What is difference between equi join and inner join?
How to write a script for upate the data in prod , i have 50000 row are there
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
how to select 5 to 7 rows from a table, which contains 10 rows?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Define DML and DCL statements?
What is the purpose of the master database?
Mention the command used to rename the database.
what is differece between union and union all
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
Oracle (3253)
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)