Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 31,891 through 31,905 (of 66,000 total)

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

WayneS SSC Guru Points: 95405 More actions · Answer 1

Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!

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

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 2

WayneS (11/18/2011)

Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!

Thanks.

I had no idea I was doing good work.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

SQLRNNR SSC Guru Points: 281324 More actions · Answer 3

Ninja's_RGR'us (11/18/2011)

Steve Jones - SSC Editor (11/18/2011)

Behave, I'm off to the mountains for a week.

Enjoy Thanksgiving, everyone.

Who'd you put in charge in your wonderful abscence?

You are - now get going on those 300 posts/day to the thread

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: 281324 More actions · Answer 4

WayneS (11/18/2011)

:w00t::w00t::w00t:

Just passed 70-451. Now I have all exam pre-req's for 88-970 done... just not sure I'm ready for that one yet though.

Congrats

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: 281324 More actions · Answer 5

Stefan Krzywicki (11/18/2011)

GilaMonster (11/18/2011)

WayneS (11/18/2011)

GilaMonster (11/18/2011)

Chad Crawford (11/18/2011)

The MCM would be cool, but the $19K price tag is a bit tough to come up with.

What $19 000 price tag? The knowledge exam is $500, the lab exam is $2000. The expensive part is finding good enough training.

I think Chad is thinking of the old way, where you had to go to MS for a 3 week training period. Even so, I believe that was $15K.

$18k (for normal people, MVPs got a substantial discount)

But yep, the cost for the exam is "just" $500.

The first exam. There are 2.

What might also be a consideration is the testing location... there are just two in all of VA (thankfully one is just 2 miles from work). Not sure where you can do 88-971 (lab) at - it's not showing up on Prometric's site yet.

There's none in Australia at all iirc. 1 in Africa (the continent of), it's 15 min away from me. Lab exam is at a secure prometric site, I suspect you call and ask.

There's no way that kind of a price tag would ever be worth it to me. Getting a certification isn't going to increase my salary by $20K a year and it'd have to pay for itself in less time than that if I'm going to be getting multiple certifications.

You could have your employer pay for it 😉

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

george sibbald SSC Guru Points: 104210 More actions · Answer 6

george sibbald

SSC Guru

Points: 104210

November 18, 2011 at 4:30 pm

#1410243

Hey, I've made a difference! (finally)

http://connect.microsoft.com/SQLServer/feedback/details/342832/active-active-logshipping-restores-clear-proccache

---------------------------------------------------------------------

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 7

SQLRNNR (11/18/2011)

Stefan Krzywicki (11/18/2011)

GilaMonster (11/18/2011)

WayneS (11/18/2011)

GilaMonster (11/18/2011)

Chad Crawford (11/18/2011)

The MCM would be cool, but the $19K price tag is a bit tough to come up with.

What $19 000 price tag? The knowledge exam is $500, the lab exam is $2000. The expensive part is finding good enough training.

I think Chad is thinking of the old way, where you had to go to MS for a 3 week training period. Even so, I believe that was $15K.

$18k (for normal people, MVPs got a substantial discount)

But yep, the cost for the exam is "just" $500.

The first exam. There are 2.

What might also be a consideration is the testing location... there are just two in all of VA (thankfully one is just 2 miles from work). Not sure where you can do 88-971 (lab) at - it's not showing up on Prometric's site yet.

There's none in Australia at all iirc. 1 in Africa (the continent of), it's 15 min away from me. Lab exam is at a secure prometric site, I suspect you call and ask.

There's no way that kind of a price tag would ever be worth it to me. Getting a certification isn't going to increase my salary by $20K a year and it'd have to pay for itself in less time than that if I'm going to be getting multiple certifications.

You could have your employer pay for it 😉

Thanks! That may have been the funniest thing I read all day. 🙂

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 8

george sibbald (11/18/2011)

Hey, I've made a difference! (finally)

http://connect.microsoft.com/SQLServer/feedback/details/342832/active-active-logshipping-restores-clear-proccache

That's a fairly brutal result from logshipping, wow. Nice catch George.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 9

Grant Fritchey (11/18/2011)

WayneS (11/18/2011)

Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!

Thanks.

I had no idea I was doing good work.

Awesome job, Grant... especially since you didn't know! 😀

Assuming the list is in order by votes, you've beat out some fairly impressive names.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 10

Jim Murphy

SSCertifiable

Points: 6263

November 19, 2011 at 12:35 am

#1410277

Grant Fritchey (11/18/2011)

WayneS (11/18/2011)

Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!

Thanks.

I had no idea I was doing good work.

I very much enjoy reading your stuff. Keep it coming; we find it useful.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph

george sibbald SSC Guru Points: 104210 More actions · Answer 11

Evil Kraig F (11/18/2011)

george sibbald (11/18/2011)

Hey, I've made a difference! (finally)

http://connect.microsoft.com/SQLServer/feedback/details/342832/active-active-logshipping-restores-clear-proccache

That's a fairly brutal result from logshipping, wow. Nice catch George.

thanks. worth being aware of I thought.

---------------------------------------------------------------------

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 12

Um, I don't know what to say to something like this:

SSIS would be a very simple setup:

And this is why I don't like it. It stops the learning curve for DB Developer.

IMHO, part of learning is about discovering and using the most efficient way of doing things.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 13

GilaMonster (11/19/2011)

Um, I don't know what to say to something like this:

SSIS would be a very simple setup:

And this is why I don't like it. It stops the learning curve for DB Developer.

IMHO, part of learning is about discovering and using the most efficient way of doing things.

It doesn't stop it. It changes it, but it certainly doesn't stop it. You just have more to learn and you might learn some things in a different order, but you still need to learn it all.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 14

GilaMonster (11/19/2011)

Um, I don't know what to say to something like this:

SSIS would be a very simple setup:

And this is why I don't like it. It stops the learning curve for DB Developer.

IMHO, part of learning is about discovering and using the most efficient way of doing things.

Agreed... but isn't that the point trying to be made? Is SSIS the most efficient way of doing things? For a lot of things, the answer would certainly be "Yes". For the things that it is not, more "difficult" methods must be found out and the point I believe that is trying to be made is that a lot of people won't try the more difficult methods because they haven't learned them nor will some of those people. They'll just say that SSIS can't do it and move on instead of learning the more difficult, more efficient way of doing things.

It's almost the same thing as why some people use some of the more common cursor mistakes we've all seen... it's the "easy" way instead of learning how to do things in a set based fashion. A lot of people will simply take the path of least resistance even if it's not the most efficient method. If you'd rather, I know people who don't know the 10x times tables because they use the "more efficient" method of doing it on a calculator. Should they know the times tables? My thought is "Yes"... they shouldn't have to dig out a calculator to figure out something as simple as a tip in a restaurant. It's much more efficient to be able to do it your your head but they have no incentive because of the calulator and they'll never learn the more efficient method because of it.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 15

Jeff Moden (11/19/2011)

GilaMonster (11/19/2011)

Um, I don't know what to say to something like this:

SSIS would be a very simple setup:

And this is why I don't like it. It stops the learning curve for DB Developer.

IMHO, part of learning is about discovering and using the most efficient way of doing things.

Agreed... but isn't that the point trying to be made? Is SSIS the most efficient way of doing things?

In that particular case, yes it was.

The specifics aren't what I was getting at. The general attitude of 'don't look at stuff outside of one area because it will slow down your learning' is what I was getting at. Focus on just on one area if you like, but don't assume that learning stuff outside will be a waste. Sure, you may learn that one area slower, but you may learn other ways of doing things that are far more efficient.

For a lot of things, the answer would certainly be "Yes". For the things that it is not, more "difficult" methods must be found out

But if you don't know SSIS at all, you won't be able to take advantage of it for those cases where the answer is yes. You won't know when use SSIS and when to pull another tool out.

If you'd rather, I know people who don't know the 10x times tables because they use the "more efficient" method of doing it on a calculator. Should they know the times tables? My thought is "Yes"... they shouldn't have to dig out a calculator to figure out something as simple as a tip in a restaurant. It's much more efficient to be able to do it your your head but they have no incentive because of the calulator and they'll never learn the more efficient method because of it.

Yes, but this comment wasn't saying only chose the easy way, it was saying don't use the easy way because you don't learn anything. I don't need a calculator to add up shopping prices, but I'm not going to do my tax calculations in my head just because it'll improve my maths skills.

Right tool for the right job, don't ignore a tool because it's the easy way out.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass