Indexes are updated automatically is the full-text index also updated automatically?
No Answer is Posted For this Question
Be the First to Post Answer
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is collation sensitivity? Explain different types.
Explain transaction server distributed transaction?
What is reference section?
How many types of triggers in sql server?
Tell me what is use of except clause? How it differs from not in clause?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
Explain what are page splits? : SQL Server Architecture
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
How to restore performance issues and how to check?
How column data types are determined in a view?
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)