WayneS

Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 5,588 total)

RE: The Missing Certification

Luke L (4/1/2010)
CirquedeSQLeil (4/1/2010)
So we have the model by PMP as one suggestion.
Anybody have anymore suggestions as to models to research and potentially emulate?
I think the direction the conversation needs...
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:31 pm

#1144468
RE: The Missing Certification

CirquedeSQLeil (4/1/2010)
I think these types of questions that get deeper into the subject certainly are what is needed at a higher level certification. This type of certification is kind...
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:10 pm

#1144458
RE: The Missing Certification

Michael Meierruth (4/1/2010)
So what was the purpose of this discussion on 'table scan vs clustered index scan'.
That discussion evolved from a comment being made about someone ~~not~~ thinking that an...
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:01 pm

#1144449
RE: The Missing Certification

CirquedeSQLeil (3/30/2010)
If any are interested, I posted my blog on the topic. A greater bit of depth needs to be done with the topic. I figure this is...
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 1:17 pm

#1144402
RE: The Missing Certification

dma-669038 (3/30/2010)
I am writing to Kevin Kline tonight to ask for input on the previous attempt that Gail mentioned. Am going to copy Lynn but if anyone else wants to...
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 1:07 pm

#1144398
RE: Are the posted questions getting worse?

I've got a theory about Paul... I think he has cloned himself. He then sends his clone out to "go forth and find all good sql nuggets", and then does...
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 11:48 am

#1144334
RE: The Missing Certification

Paul White NZ (4/1/2010)
Anyone giving an answer like that is clearly an insufferable nerd and of no practical use to anyone! :w00t:
LOL!
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 10:19 am

#1144202
RE: No More NULL

I think that the NULL / NIL would be interesting...
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 10:11 am

#1144188
RE: The Missing Certification

Paul White NZ (4/1/2010)
They might be exactly the same thing IF (the execution plan specifies ordered:false to the storage engine) AND (the effective isolation level is read uncommitted OR a...
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 10:05 am

#1144181
RE: No More NULL

Ralph Hightower (4/1/2010)
Ah Steve,
You had to spoil the joke with a disclaimer.
Of course, this is also an April Fool's joke and is in no way based on reality. It's entirely...
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 7:19 am

#1143936
RE: How to find number in series is not entered in table

You might want to check out this recent thread (click here). It seems to be very similiar to what you are asking.
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 7:15 am

#1143933
RE: The Missing Certification

GilaMonster (3/31/2010)
WayneS (3/31/2010)
dma-669038 (3/31/2010)
One guy i talked to did not know the difference between table scan and index seek except that 'it ran faster')
Makes me wonder what he thinks 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

March 31, 2010 at 9:36 pm

#1143631
RE: DBCC Timewarp

Man, that was a lot of points for this question!
Happy April Fools!
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

March 31, 2010 at 9:18 pm

#1143618
RE: Advice on an OR statement

Paul White NZ (3/31/2010)
WayneS (3/31/2010)
In addition to what Paul suggests (using a UNION ALL), you should remove the NOLOCK hint. Unless you don't mind sending potentially wrong data back to...
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

March 31, 2010 at 2:35 pm

#1143480
RE: The Missing Certification

dma-669038 (3/31/2010)
One guy i talked to did not know the difference between table scan and index seek except that 'it ran faster')
Makes me wonder what he thinks the difference is...
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

March 31, 2010 at 2:17 pm

#1143467

Viewing 15 posts - 4,546 through 4,560 (of 5,588 total)