How to start learning?

[stalo]

Dear All

I have upsized my database and came up with a lot of questions. I have posted a question on a problem I am having, but after reading a lot from this forum I want to ask you to tell me where I can find info on starting after upsizing.

For example, some of the questions that I need answer are:
1. Why some of the queries do not return results?
2. The queries were converted into stored procedures? If yes, how do I use them, what are sp?
3. What is the diffenerve between nvarchar and varchar? How data types are converted?
4. What are the major things to be cautious after migrating
5... the list goes on.

where can I find some practical introduction to get me started?

 

[SQLBill]

Start with the BOL:

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
or online at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

Posting advice: FAQ481-4875

 

[Catadmin]

Additionally, I recommend the Sybex series books for Certification. You don't have to go for the MCDBA. These are good exercise oriented books which teach you the definitions and how to create the most frequently used objects, including stored procedures, functions, general queries, etc.

Start with the Database Administrator book, not the Database Designer book.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[SQLSister]

Post the queries which should return results and the structure of the database and we can prolly help you figure it out. Likely the query used some Access type code that is not supported in SQL Server. Such as IIF. Or you have a permissions problem.

One thing to remember after migrating is to test extensively. Not everything works the same. Test every single functionality and try your darndest to break it.

Read about data types and really understand them. The upsizing wizard does not always pick the best datatype for the conversion.

BOL will answer questions about sp's. Also read the FAQs here; they will help tremendously.

Don't forget to set up backups and especially transaction log backups. If you don;t, you'll be back here in a few months wondering how to reduce the size of the transaction log that has eaten your entire hard drive.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief