Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,701 through 20,715 (of 66,815 total)

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

WayneS SSC Guru Points: 95461 More actions · Answer 1

@paul-2 - interesting colours on your new avatar.

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

Paul White SSC Guru Points: 150468 More actions · Answer 2

WayneS (10/20/2010)
@paul-2 - interesting colours on your new avatar.

Thanks - it's almost summer here, so I felt like brightening it up a bit 🙂

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

Paul White NZ (10/20/2010)
WayneS (10/20/2010)
@paul-2 - interesting colours on your new avatar.
Thanks - it's almost summer here, so I felt like brightening it up a bit 🙂

Nice effect! You could do the same to your car:

-- Gianluca Sartori

Johan Bijnens SSC Guru Points: 135551 More actions · Answer 4

Paul White NZ (10/20/2010)
WayneS (10/20/2010)
@paul-2 - interesting colours on your new avatar.
Thanks - it's almost summer here, so I felt like brightening it up a bit 🙂

I tought it was the dust of a collapsing building during the recent earthquake :hehe:

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 5

Steve Jones - SSC Editor (10/20/2010)
I know that some of these people are annoying, but let's try not to pile on too much. Just post that you expect them to do some work, or something similar that's professional and let them respond. Seems like we're getting a few too many people overwhelming the OP and I think some of them are getting scared of responding when there are 4 or 5 replies that are in essence, beating them up a bit.

Well this one came back, and although they didn't supply the samples, did some work.

And it seems he was very satisfied in the end.

Although at one point, I didn't think he would return.

That would have been a shame, as it seems this poster wants to learn.

And those (at least I hope) are the ones we want to help.

Greg E

Ray K SSC-Dedicated Points: 31172 More actions · Answer 6

Anyone have any ideas to help this fellow out? (I don't.)

http://www.sqlservercentral.com/Forums/Topic1008514-391-1.aspx

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

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

Hey Threadizens,

I've got a confusion that I could really use your assistance with in regards to some strangeness out of the optimization engine. Well, strange to me. If one of y'all can take a look and at least make sure I didn't miss the obvious?

http://www.sqlservercentral.com/Forums/Topic1008709-360-1.aspx

Much obliged.

EDIT: Nevermind, nailed it down. Silly little row_number() inside the view destroyed all passthrough where clause index seeking.

- 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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 8

Anyone need a good laugh?

http://www.careerride.com/sql-server-what-is-index-segmentation.aspx

Some gems...

Q:What are the advantages of using Stored Procedures?

A: Stored procedures provide performance benefits through local storage, precompiling the code, and caching......

Database backup methods:

Full Backups

Differential Backups

Transaction Log Architecture Backups

File and Filegroup Backups

Q: Explain how to rename a table.

A: The ALTER table statement can be used to rename a table.

ALTER TABLE table_name

RENAME TO new_table_name

Q: Explain how to determine if a table has a primary key?

A: A primary key is usually identified by the keyword PRIMARY KEY. Any column that has the keyword (while creating the table) as PRIMARY KEY means the table has a primary key.

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 9

GilaMonster (10/21/2010)
Anyone need a good laugh?
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Some gems...
Q:What are the advantages of using Stored Procedures?
A: Stored procedures provide performance benefits through local storage, precompiling the code, and caching......
Database backup methods:
Full Backups
Differential Backups
Transaction Log Architecture Backups
File and Filegroup Backups
Q: Explain how to rename a table.
A: The ALTER table statement can be used to rename a table.
ALTER TABLE table_name
RENAME TO new_table_name
Q: Explain how to determine if a table has a primary key?
A: A primary key is usually identified by the keyword PRIMARY KEY. Any column that has the keyword (while creating the table) as PRIMARY KEY means the table has a primary key.

Isn't it fun when the interviewer got his questions from a site like this? One big reason I hate specific questions in interviews.

--------------------------------------
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 10

GilaMonster (10/21/2010)
Anyone need a good laugh?
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx

Oh good grief, my brain already hurt today. Now it's making a run for the border. Tequila, anyone?

- 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

GSquared SSC Guru Points: 260824 More actions · Answer 11

Jeff Moden (10/20/2010)
GSquared (10/20/2010)
it's been worse than every other standard hierarchy implementation that I know of
What do you mean, Gus? How has it been worse? Implementation, performance, easy of maintenance, useage, or ????

In my experience, it does slower selects than nested sets while having the update issues they have, and does slower updates than adjacency while not achieving a significant speed increase over them until you hit very deep hierarchies.

Basically, in my experience, it's good at semi-static hierarchies because of update issues, but nested sets are better at exactly that.

Path hierarchies are where it will do well. But most of those aren't deep enough to require better performance than adjacency, which gives better update/insert/delete performance. So it really needs semi-static, deep, path hierarchies, in order to beat the other major hierarchy implementations. I haven't had a chance to implement one of those, and doubt I ever will. I've done proof-of-concept work on it, in my copy of Dev Edition at home, and it does work well for that, but to me it's a theoretical thing with very little, if any, real-world value.

I rank it right down there with SQL's implementation of Pivot. Theoretically useful, but in practice, not so much.

And I have done multi-path adjacency hierarchies using adjacency (a many-to-many self-join) and it was easy to build and manage. Not as easy to query, but there were workarounds for that.

So far as I know, if you wanted to do geneology with the Hierarchy datatype, you'd pretty much end up with one hierarchy path per ancestor for each node. That would be worse than a simple two-parent adjacency model.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Ron McCullough SSC Guru Points: 63877 More actions · Answer 12

Gail,

at first I thought those answers / explanations were jokes, but then realized they were not. May the Gods save us from the stupidies of those who think they know, but in reality know squat.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281344 More actions · Answer 13

GilaMonster (10/21/2010)
Anyone need a good laugh?
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Some gems...
Q:What are the advantages of using Stored Procedures?
Database backup methods:
Q: Explain how to rename a table.
Q: Explain how to determine if a table has a primary key?

I like my answers better.

True

False

True

False

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

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

CirquedeSQLeil (10/21/2010)
GilaMonster (10/21/2010)
Anyone need a good laugh?
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Some gems...
Q:What are the advantages of using Stored Procedures?
Database backup methods:
Q: Explain how to rename a table.
Q: Explain how to determine if a table has a primary key?
I like my answers better.
True
False
True
False

Q:What are the advantages of using Stored Procedures?

A: They are stored so you don't have to write them every time.

Database backup methods:

A: Tell someone they should back up the database

Q: Explain how to rename a table.

Talk to eveyone who uses it and come up with a new name everyone likes.

Q: Explain how to determine if a table has a primary key?

Lock the database, if the table can get back in, it has a key.

--------------------------------------
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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 15

Stefan Krzywicki (10/21/2010)
CirquedeSQLeil (10/21/2010)
GilaMonster (10/21/2010)
Anyone need a good laugh?
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Some gems...
Q:What are the advantages of using Stored Procedures?
Database backup methods:
Q: Explain how to rename a table.
Q: Explain how to determine if a table has a primary key?
I like my answers better.
True
False
True
False
Q:What are the advantages of using Stored Procedures?
A: They are stored so you don't have to write them every time.
Database backup methods:
A: Tell someone they should back up the database
Q: Explain how to rename a table.
Talk to eveyone who uses it and come up with a new name everyone likes.
Q: Explain how to determine if a table has a primary key?
Lock the database, if the table can get back in, it has a key.

That would actually be a skeleton key.

Primary key is the nice and colorful ones with which kids play.

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