Viewing 15 posts - 26,416 through 26,430 (of 49,552 total)
zayidka (5/1/2011)
Corgi said,“You mentioned that you are stack, I'm stuck as what you are trying to say...”
What do you think?
I think that he, like me, is having...
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
May 1, 2011 at 4:02 pm
zayidka (5/1/2011)
if you did do you really think asking someone why they write an A instead of U in simple word that 3 year old can understand is necessary?
No one...
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
May 1, 2011 at 3:35 pm
Post the exact errors please.
What was the CheckDB command you ran?
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
May 1, 2011 at 3:22 pm
Craig Farrell (5/1/2011)
Azhar, I'm surprised noone brought this up before. Latches are primarily memory objects.
Err, I did... 😉
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
May 1, 2011 at 3:20 pm
zayidka (5/1/2011)
Or “What kind of test are you referring...
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
May 1, 2011 at 3:20 pm
For your info:
http://www.microsoft.com/learning/en/us/certification/exam-policies.aspx#tab2
The Examinee may be prohibited from taking any Microsoft Certification Exams, and/or may be decertified from Microsoft Certification Program if Examinee violates this Exam Agreement and/or engages in...
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
May 1, 2011 at 11:01 am
Lynn Pettis (5/1/2011)
I have also reported the post to ssc suggesting that the attachment be deleted as it may violate Microsoft NDA agreements.
No 'may' about it. It's actual screenshots 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
May 1, 2011 at 10:55 am
CELKO (5/1/2011)
Really awful T-SQL people will use both a real key and an IDENTITY property. We do not use th4e old Sybase getdate() any more.
You have a very broad...
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
May 1, 2011 at 10:49 am
If by dump, you mean braindump, you are aware that those are actual questions taken from the real exam. Using or distributing braindumps can result in your certifications being revoked...
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
May 1, 2011 at 10:42 am
The about.com article is wrong. Currently the product is code named Denali, sometimes called SQL 11 (it was called that before the code name was announced), but it is not...
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
May 1, 2011 at 9:38 am
zayidka (5/1/2011)
SELECT COUNT( courseId)FROM dbo.registration
WHERE SID = Inserted.SID AND course_name = inserted.course_name ) = 0
That's going to give you a syntax error since you reference the table inserted but never...
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
May 1, 2011 at 9:17 am
Ok, one thing. Denali is not SQL 2011.
It's called SQL 11 because the major version (SELECT @@version) is 11.0
It has no official name yet.
It has no release date yet.
It...
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
May 1, 2011 at 9:14 am
A rebuild always needs free space, often the size of the index.
A data file will never shrink on its own. Only a shrink will do that, and it will fragment...
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
May 1, 2011 at 9:12 am
zayidka (5/1/2011)
Did not get to the SAT yet, butI have changed
IF (SELECT Due_Amount
FROM dbo. Student_Bill_Account
WHERE Due Amount) > 0
So if some random row in the table 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
May 1, 2011 at 9:10 am
Yes there is. You have 2 BEGINs and one END
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
May 1, 2011 at 9:06 am
Viewing 15 posts - 26,416 through 26,430 (of 49,552 total)