iSQL Server. iDatabase management platform

(South Africans should get the joke, I apologise to...

This must be deadlock month. I have 6 different deadlock-related threads bookmarked, all of which I need to look through. I wish deadlocks were easier to help with.

The only traceflag you need is 1222. 1204 is the old one from SQL 2000, the info it produces is far less useful than what 1222 outputs. 3605 is used...

baghel_ramdas (1/15/2010)

---

That’s my question why the trying to confuse in interview? He told me that SQL server is not starting due to MSDB database corruption. And forcefully telling me that...

I don't see one in this thread. I just see a complaint.

The whole point of an interview is to see what you know. Part of that means asking questions that you may not be able to answer. If you don't know,...

Consult the documentation.

http://msdn.microsoft.com/en-us/library/ms190190.aspx

http://msdn.microsoft.com/en-us/library/dd207003.aspx

Interview question?

btw, msdb corruption shouldn't prevent the SQL database engine from starting. It'll prevent SQL Agent from starting.

I just tested this out on SQL 2005, renamed the...

Do you have a question, or are you just trying to insult people?

Related to this question: http://www.sqlservercentral.com/Forums/Topic848271-1550-1.aspx

No replies to this thread please.

I'm going to guess, from your other questions here today, this is a question that you were asked in an interview.

If that's the case, "what is behind of sense of...

Consult the documentation, then restore from backup.

http://msdn.microsoft.com/en-us/library/ms190749.aspx

Interview question?

Well, who else is going to be able to properly asses a junior DBA's skills other than another DBA?

Table-valued parameters - http://msdn.microsoft.com/en-us/library/bb510489.aspx

They'll be identical.

All queries use transactions. If you don't explicitly start a transaction, one is automatically started at the beginning of a statement and automatically committed if the query finishes without error.

As...

Brain dumps are cheating. They are actual questions taken from the exam in violation of the agreement that all candidates have to accept when taking the exam.

Using or requesting braindumps...