help with storage engine in a sql server 2005
-
Hi, I am new to SQL and I am learning SQL through tutorials, Currently I am studying A topic named TRANSACTION. its good to know that statements in the transaction can be ROLLED BACK if anything accidently goes wrong OR COMMITTED when every thing goes fine. Then I read about choosing a proper storage engine is a must, but I cannot figure out what is a storage engine what does it do and which is best. can anyone please help me?
-
Hi, I am new to SQL and I am learning SQL through tutorials, Currently I am studying A topic named TRANSACTION. its good to know that statements in the transaction can be ROLLED BACK if anything accidently goes wrong OR COMMITTED when every thing goes fine. Then I read about choosing a proper storage engine is a must, but I cannot figure out what is a storage engine what does it do and which is best. can anyone please help me?
You do not say which SQL Server you are using reading about, but I suspect that it is MySql, since that is the only one that I know of that has a selection of storage engines. If this is correct, basically the different storage engines available are better suited to different types of application/data. You might be better off visiting the MySql site, specifically this page[^] as a starting point. Then just follow your nose. :) [Edit] 1) fixed bad wording in first sentence. 2) Here is a link to stuff about the Storage Engine for SqlServer 2005. clickety[^] [/Edit]
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
modified on Friday, September 11, 2009 6:53 AM