What are trace flags and mention a few common trace flags used with sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are db_options used for?
What are the advantages of using cte?
What is use of except clause? How it differs from not in clause?
Explain optimistic and pessimistic concurrency?
explain databases and sql server databases architecture? : Sql server database administration
How do I find the sql server database version?
How do you trace the traffic hitting a sql server?
What is a livelock?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Explain filtered indexes?
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?
Differentiate between mongodb vs. Sql server?
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)