Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 22,471 through 22,485 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

Stefan Krzywicki (12/15/2010)
GilaMonster (12/15/2010)
Chris Morris-439714 (12/15/2010)
I *think* Gail has blogged on this, will look.
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
So that is a "yes" then? : -)

Yes. 😉

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

da-zero (12/15/2010)
I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.
:rolleyes:

Agreed on the interesting advertisement. Is the book bad?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 3

CirquedeSQLeil (12/15/2010)
da-zero (12/15/2010)
I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.
:rolleyes:
Agreed on the interesting advertisement. Is the book bad?

If I'm understanding da-zero correctly, you should read the name of the author.

EDIT: But seriously, is there really a need to comment on it? Not to be mean, but I thought we were all adults around here. Random potshots and snide remarks only exacerbate a potentially bad situation and the whole "debate in a side thread" is rapidly devolving into a group bully mentality that I do not like.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Stefan Krzywicki (12/15/2010)
GilaMonster (12/15/2010)
Chris Morris-439714 (12/15/2010)
I *think* Gail has blogged on this, will look.
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
So that is a "yes" then? : -)

Nah - that's still up in the air 😀

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

dup post

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Brandie Tarvin (12/15/2010)
CirquedeSQLeil (12/15/2010)
da-zero (12/15/2010)
I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.
:rolleyes:
Agreed on the interesting advertisement. Is the book bad?
If I'm understanding da-zero correctly, you should read the name of the author.
EDIT: But seriously, is there really a need to comment on it? Not to be mean, but I thought we were all adults around here. Random potshots and snide remarks only exacerbate a potentially bad situation and the whole "debate in a side thread" is rapidly devolving into a group bully mentality that I do not like.

I had to recheck the newsletter because none of the authors on the book advertisement that I read sounded familiar.

Excerpt from ad :

Accelerated SQL Server 2008 - The expert tuition and approach to rapid learning in Accelerated SQL Server 2008

I simply thought the description was bad.

When I went back to the newsletter I saw the other ad. For that one, I have no comment. I haven't read the book.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Paul White SSC Guru Points: 150467 More actions · Answer 7

Stefan Krzywicki (12/15/2010)
It contains no duplicate values. Is there any difference in using EXISTS in that case?

Yes and no. :pinch:

There would be no difference between the results from a query expressed using JOIN, from one expressed using EXISTS. The execution plans and performance might well differ, however.

On the other hand, IN and EXISTS have slightly different NULL-handling semantics, so it is not possible to express the exact same logic using IN as it is using EXISTS.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 8

Paul White NZ (12/15/2010)
On the other hand, IN and EXISTS have slightly different NULL-handling semantics, so it is not possible to express the exact same logic using IN as it is using EXISTS.

Where does one locate information on NULL-handling semantics? Not just for IN and EXISTS, but across the board.

I'd like to do some testing myself on that sort of thing.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 9

CirquedeSQLeil (12/15/2010)
Brandie Tarvin (12/15/2010)
CirquedeSQLeil (12/15/2010)
da-zero (12/15/2010)
I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.
:rolleyes:
Agreed on the interesting advertisement. Is the book bad?
If I'm understanding da-zero correctly, you should read the name of the author.
EDIT: But seriously, is there really a need to comment on it? Not to be mean, but I thought we were all adults around here. Random potshots and snide remarks only exacerbate a potentially bad situation and the whole "debate in a side thread" is rapidly devolving into a group bully mentality that I do not like.
I had to recheck the newsletter because none of the authors on the book advertisement that I read sounded familiar.
Excerpt from ad :
Accelerated SQL Server 2008 - The expert tuition and approach to rapid learning in Accelerated SQL Server 2008
I simply thought the description was bad.
When I went back to the newsletter I saw the other ad. For that one, I have no comment. I haven't read the book.

It's funny but I don't even notice the ads so I had to go back and look.

For the Accelerated SQL Server 2008 book the description is bad, but it is exactly the same on Amazon. There are a couple of people I respect on the author list. I don't know anything about a couple of others.

I have Celko's book that is in the newsletter today. I got it in 2007 when he came and did a pre-con before the first SQLSaturday. I haven't read it all because it is written completely using ANSI standards, no surprise, so you can't directly apply it to SQL Server, but it is pretty high-level and has some good theory. Joe is a smart guy and knows his stuff. I don't agree with everything he is a proponent of and how he presents himself online, but doesn't mean I can't learn from him.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 10

Speaking of books, got a great email from O'Reilly today about a 60% off eBooks, today only. I believe this was sent out to all PASS Chapters.

PM me, and include your email adrress, if you didn't get this email and want in on the deal.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

I am growing a hatred for dne2000.sys (deterministic network enhancer) required by cisco vpn. It constantly crashes on win7. Nothing like working and getting BSODs on a random interval.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

CirquedeSQLeil (12/15/2010)
I am growing a hatred for dne2000.sys (deterministic network enhancer) required by cisco vpn. It constantly crashes on win7. Nothing like working and getting BSODs on a random interval.

I'm assuming you checked if you have the latest version.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Alvin Ramard (12/15/2010)
Speaking of books, got a great email from O'Reilly today about a 60% off eBooks, today only. I believe this was sent out to all PASS Chapters.
PM me, and include your email adrress, if you didn't get this email and want in on the deal.

Nope, not gonna PM you. :hehe:

I believe you know my email anyway - will you forward that email?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Paul White SSC Guru Points: 150467 More actions · Answer 14

Brandie Tarvin (12/15/2010)
Paul White NZ (12/15/2010)
On the other hand, IN and EXISTS have slightly different NULL-handling semantics, so it is not possible to express the exact same logic using IN as it is using EXISTS.
Where does one locate information on NULL-handling semantics? Not just for IN and EXISTS, but across the board.
I'd like to do some testing myself on that sort of thing.

I've never seen a good account anywhere all in one place 🙁

There are bits and bobs scattered though BOL, which vary in quality, coherence, and accuracy.

Part of the problem (as with much of SQL Server) is backward-compatibility: there are some decidedly odd behaviours, preserved only to avoid breaking stuff.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 15

CirquedeSQLeil (12/15/2010)
Alvin Ramard (12/15/2010)
Speaking of books, got a great email from O'Reilly today about a 60% off eBooks, today only. I believe this was sent out to all PASS Chapters.
PM me, and include your email adrress, if you didn't get this email and want in on the deal.
Nope, not gonna PM you. :hehe:
I believe you know my email anyway - will you forward that email?

Jason, read your PM, or no email. 🙂

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]