Normalization will probrably come up and yes the interviewer will ask you some questions.

Be honest and say i not done this part but i am happy to research and provide...

These are good lynn thanks.

basically i have to tell the developer that you cannot have mode 80 on sql 2005 mode 90.

In english so he understands 🙂

I know it not a good idea now...

Perhaps write a trigger when you add login to server1 then fire to go create server2.

How many logins are you adding in a week.

If only a few just do it...

Here what i used to increase the tempdb...and was someone else post...

Please try on a test server to make sure you understand this first.

To improve query performance when you've found...

So what command with the tail log part amended...

😀

So what command with the tail log part amended...

😀

Primary goes down you want secondary to stand in.

Do you have cluster this will resolve your needs.

Also log shipping too.

You then don't copy all the logins over it all happens...

Thank you for the clarification.

Don't practice on production oh thats not fun 😀

No very good advice never pratice on production.

I will play around on my own SQL Server just to...

Interesting thing here, as I had neglected to move the resource database files out of the way, the reinstall did NOT overwrite the existing resource database, so having done the...

Thanks that the new command in 2005 for rebuilding master file........

start /wait setup.exe /qd instancename= MSSQLSERVER reinstall=SQL_Engine rebuilddatabase=1 sapwd=somethingsecure

What is the rebuilddatabase?

Nothing in there which is correct .........as no objects associated.

I try again and see what i get perhaps a connection was intact.

Cheers.

The schema is set to dbo.

Yes forgot that one too the ODBC itself...