Viewing 15 posts - 34,681 through 34,695 (of 49,552 total)
Steve Jones - Editor (1/15/2010)
I could see separate pricing if the product was locked to that language.
iSQL Server. iDatabase management platform
(South Africans should get the joke, I apologise to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 8:42 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 8:27 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 8:23 am
baghel_ramdas (1/15/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 8:20 am
baghel_ramdas (1/15/2010)
Sir Really I have lot of questions.
I don't see one in this thread. I just see a complaint.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 8:10 am
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 8:09 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 8:06 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:57 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:48 am
Consult the documentation, then restore from backup.
http://msdn.microsoft.com/en-us/library/ms190749.aspx
Interview question?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:44 am
Well, who else is going to be able to properly asses a junior DBA's skills other than another DBA?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:43 am
Table-valued parameters - http://msdn.microsoft.com/en-us/library/bb510489.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:07 am
They'll be identical.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:04 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:02 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 7:00 am
Viewing 15 posts - 34,681 through 34,695 (of 49,552 total)