Where are magic tables stored ? Is it in the same database
where it is created ?

Answer Posted / amitmca09

Magic tables stored in the same database

Is This Answer Correct ?    19 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between seek predicate and predicate?

587


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1557


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

593


Difference between drill down and drill through report.

545


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

505






Differentiate between truncate vs delete in mssql?

529


How much space does sql server 2016 take?

569


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

589


How to use subqueries with the in operators in ms sql server?

569


Explain the difference between functions and stored procedures in sql server?

482


Does full backup break log chain?

552


What are the advantages of log shipping?

563


What are distinctive joins find as a part of sql?

560


What are the recovery models for a database?

619


Can we insert data into a view?

575