Where do you find the default Index fill factor and how to change it?
No Answer is Posted For this Question
Be the First to Post Answer
How do you debug a procedure in sql server?
What is Data model and how to prepare a data model.?
Create and insert into temp table in sql server?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is the default value of CHAR type?
Tell me about the approaches which you used to counter the DI problems.
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Who developed sql server?
what is Archive old data?
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
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)