WayneS

Forum Replies Created

Viewing 15 posts - 4,531 through 4,545 (of 5,588 total)

RE: The Missing Certification

dma-669038 (4/2/2010)
Am really sorry to hear Wayne thinks he is 'waffling' about it , I didnt think he was and i dont' think it should just be tossed out either.
Hey,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 2, 2010 at 9:41 am

#1144879
RE: The Missing Certification

Grant Fritchey (4/2/2010)
I think the time in service, as part of the bridge between MCTIP and MCM, actually adds unecessary overhead that is simply going to be gamed anyway. ......
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 2, 2010 at 8:01 am

#1144756
RE: The Missing Certification

dma-669038 (4/2/2010)
Yes I concur with Lynn. The problem I have with 'tossing out time in service' (and I mean time spent working on the product not in any title) -...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 2, 2010 at 7:53 am

#1144750
RE: Decoding the SQL Server Index Structure

Steve Jones - Editor (4/2/2010)
Glad you liked it, Dave. Took awhile to try and write it up and get something that looked real. Phil Factor helped flesh out details in...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 2, 2010 at 7:35 am

#1144736
RE: Decoding the SQL Server Index Structure

GSquared (4/2/2010)
But, with this article, it's more like he told you "April Fool's" about five minutes into class, and then again at five minute intervals, and you only noticed it...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 2, 2010 at 7:31 am

#1144732
RE: The Missing Certification

Grant Fritchey (4/2/2010)
That's the problem with bringing titles and time in rate to the equation. One of the best DBA's I know isn't a DBA, she's a developer; Gail Shaw....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 2, 2010 at 7:23 am

#1144719
RE: The Missing Certification

Grant Fritchey (4/2/2010)
Set a decently high bar. If people clear it, they're certified. If they don't... go study and come back again in 3-6-9 months and try it again.
This brings...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 2, 2010 at 7:14 am

#1144715
RE: The Missing Certification

Lynn Pettis (4/1/2010)
I'm thinking more about the interaction between them in a BI environment. As you gain experience, you are going to find yourself working more closely with them...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 9:55 pm

#1144593
RE: The Missing Certification

CirquedeSQLeil (4/1/2010)
Another idea is to implement multiple MCJ certs within the Database world since there are so many things at which you could specialize.
I can see this point, since there...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 3:25 pm

#1144504
RE: Trigger Performance: Blocks and Deadlocks

Dan.Humphries (4/1/2010)
If I am understanding your post correctly then it ties into a responce I just posted for another thread.
the trigger will only fire once per update so during mass...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 3:17 pm

#1144500
RE: Trigger Update

Dan.Humphries (4/1/2010)
A trigger will still only fire once per statemnet though is that not correct?
A trigger will fire only ONCE per DML statement. The problem is that the...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 3:13 pm

#1144491
RE: Trigger Performance: Blocks and Deadlocks

am-244616 (4/1/2010)
Guys,
I have to track all the DMLs on bunch of tables to see when the data got modified.
I have come up with two options
Option 1
TRACK table has been created...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 3:08 pm

#1144485
RE: Trigger Update

Dan.Humphries (4/1/2010)
HEre is a link to one of the threads on this subject.
http://www.sqlservercentral.com/Forums/Topic730493-338-1.aspx
This link is referring to the specific case of firing a trigger during a bulk insert and doesn't...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 2:56 pm

#1144482
RE: Trigger Update

am-244616 - when you select into a variable from a table, the variable is going to hold the value from the last row selected. It might be the first...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 2:53 pm

#1144479
RE: SP says it's exceeded nesting level when there is no nesting involved!

CirquedeSQLeil (4/1/2010)
Congrats on finding the issue.
This would be a nice example of a bad loop.
Bad loop indeed. Hmm, what would be a good loop? :w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 1, 2010 at 2:34 pm

#1144469

Viewing 15 posts - 4,531 through 4,545 (of 5,588 total)