Explain what is the difference between a local and a global temporary table?
No Answer is Posted For this Question
Be the First to Post Answer
Mention the different authentication modes in sql server.
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
What is the size of transaction log file?
What is instead of dml trigger?
Explain what is analysis service repository?
What does the automatic recovery do?
Scalability, Availability, Integration with internet, etc.)?
Can we join two tables without primary key?
How can you find out how many rows returned in a cursor?
What is the difference between deallocate cursor and close cursor?
What is resource db in sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
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)