What is the datatype returned by count(*)
Answers were Sorted based on User's Feedback
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
What is index fragmentation in ms sql server?
What are the steps you will take to improve the performance of a poor performing query?
Explain error handling in ssis?
Can we hide the definition of a stored procedure from a use?
What is sql server used for?
What is the difference between varchar and nvarchar datatypes?
Explain nested join?
Where in ms sql server is ’100’ equal to ‘0’?
What are the different acid properties?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What are different types of database indexes?
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)