Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
No Answer is Posted For this Question
Be the First to Post Answer
What will be the maximum number of index per table?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Explain indexed views and partitioned view with their syntax.
How to rename databases in ms sql server?
When would you use it?
Mention the uses of stored procedures.
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?
What is referential integrity? What are the advantages of it?
4 Answers Descon, Digital Domain,
What is a with(nolock)?
How to modify the underlying query of an existing view?
How many index can be created for single table
4 Answers CarrizalSoft Technologies, Verizon,
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)