Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 49,486 through 49,500 (of 66,712 total)

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

Lynn Pettis (7/14/2015)
Brandie Tarvin (7/14/2015)
Eirikur Eiriksson (7/14/2015)
Brandie Tarvin (7/14/2015)
Lynn Pettis (7/14/2015)
Eirikur Eiriksson (7/14/2015)
Lynn Pettis (7/14/2015)
I know that an OP posted a question with the following error:
Cannot create a row of size 8071 which is greater than the allowable maximum row size of 8060. The statement has been terminated.
There was a suggestion offered that helped them and it wasn't rebuilding the clustered index. I can't seem to find the thread and we are getting this error in HOA (Horn of Africa, not Home Owners Association).
I guess you are referring to this thread
😎
Yes, thank you. I even responded on that thread and still couldn't find it.
Wow. That's an interesting read. Now I want to go in and test creating a huge table.
I also wonder how many tables in our databases are afflicted with this issue given all the changes we've made over the years.
EDIT: "This issue" meaning how many tables could be cleaned and bring down the size of our dbs, not how many tables have this error.
Look up Housekeeping in "the manual", chapter "Elephant in your database":-P
😎
BTW Survey data is more like a herd of Elephants, had my share of that in the past.
So I'm testing a quick bit of code on a dev version of our bigger reporting database and it found something on the first table it hit. Nothing else so far, though. I'm doing it automagically with dynamic sql and INFORMATION_SCHEMA.TABLES.
That was definitely a fun exercise in trying to write code without using my usual DoneNotDone bit column in a temp table referenced by my loop. Adding to personal knowledge store = DBA Success. YAY!
I never use the INFORMATION_SCHEMA views personally preferring to use the system views like sys.tables, sys.columns, etc.
I've written quite a bit of dynamic SQL in my current position.

I don't like them either. The system views contain everything from the INFORMATION_SCHEMA views and so much more.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 2

Steve Jones - SSC Editor (7/14/2015)
[/url]

According to the article the IEEE is considering something that would be a big mistake. P-values are useless in Bayesian statistics and reviewers usually pretend to prefer that to all other statistics because it allows them to compute the probability of their reviews enhancing their reputations (with the editors of the journals, not with the tech community generally).

:Whistling:

Tom

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

Eirikur Eiriksson (7/14/2015)
Brandie Tarvin (7/14/2015)
So I'm testing a quick bit of code on a dev version of our bigger reporting database and it found something on the first table it hit. Nothing else so far, though. I'm doing it automagically with dynamic sql and INFORMATION_SCHEMA.TABLES.
That was definitely a fun exercise in trying to write code without using my usual DoneNotDone bit column in a temp table referenced by my loop. Adding to personal knowledge store = DBA Success. YAY!
Suggest you stop using the INFORMATION_SCHEMA views, the old ANSI standard objects are there for backward compatibility, nothing else. Even MS advices against it
😎

Come, come now... don't you want to be able to migrate your code to multiple platforms? (Wait for it... wait... wait...)

[font="Arial Black"]BWAAAA-HAAAAAA-HAAAAAA!!!! HOOOOIIIEEEE!!! [/font]

Yeah... I got your ANSI "standards" right here. 😉

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 4

Jeff Moden (7/14/2015)
Eirikur Eiriksson (7/14/2015)
Brandie Tarvin (7/14/2015)
So I'm testing a quick bit of code on a dev version of our bigger reporting database and it found something on the first table it hit. Nothing else so far, though. I'm doing it automagically with dynamic sql and INFORMATION_SCHEMA.TABLES.
That was definitely a fun exercise in trying to write code without using my usual DoneNotDone bit column in a temp table referenced by my loop. Adding to personal knowledge store = DBA Success. YAY!
Suggest you stop using the INFORMATION_SCHEMA views, the old ANSI standard objects are there for backward compatibility, nothing else. Even MS advices against it
😎
Come, come now... don't you want to be able to migrate your code to multiple platforms? (Wait for it... wait... wait...)
[font="Arial Black"]BWAAAA-HAAAAAA-HAAAAAA!!!! HOOOOIIIEEEE!!! [/font]
Yeah... I got your ANSI "standards" right here. 😉

Ah, now I get it, migrate from one version of SQL Utopia to another:hehe:

😎

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 5

Now come on you plinkers, here is a moving target practice

😎

rodjkidd SSCoach Points: 15916 More actions · Answer 6

Tom and BrainDoner and who else was interested in SQL Sat Manchester,

A tweet went out this morning saying it was full and there was a wait list...

And then a request for people to un-register if they can't make it...

I seen a couple of people on tweeter say they have un-registered, or will do.

Cheers,

Rodders...

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

Eirikur Eiriksson (7/15/2015)
Ah, now I get it, migrate from one version of SQL Utopia to another:hehe:
😎

Or one version of ANSI Utopia to another. 😀 ANSI and ISO standards also necessarily change over time. Since no RDBMS is fully compliant with either, then use the performance tools of whatever you're programming in because it's going to change anyway.

Also, some implementations of ANSI standards are just terrible. For example, use of SQL Server's FORMAT function should be illegal (and will be in the standards for the company I work for). It's no less than 44 times slower than the ol' CONVERT method.

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

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

Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

Jeff Moden (7/15/2015)
Or one version of ANSI Utopia to another. 😀 ANSI and ISO standards also necessarily change over time. Since no RDBMS is fully compliant with either, then use the performance tools of whatever you're programming in because it's going to change anyway.

Amen. The illusion of being able to migrate from one database platform leaves a lot of things unusable. I'm all in favor of getting every bit of performance out of the platform you're working on, no matter what it is.

Jeff Moden (7/15/2015)
Also, some implementations of ANSI standards are just terrible. For example, use of SQL Server's FORMAT function should be illegal (and will be in the standards for the company I work for). It's no less than 44 times slower than the ol' CONVERT method.

<sarcasm>Yeah, but it's new and shiny, so it must be good, right?</sarcasm> 😛 Seriously, I haven't tested it yet, so I can't speak from experience, but I'll take your word for it until I do.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 10

GilaMonster (7/15/2015)
Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....

...and an utter waste of time!

😎

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 11

Jeff Moden (7/15/2015)
Eirikur Eiriksson (7/15/2015)
Ah, now I get it, migrate from one version of SQL Utopia to another:hehe:
😎
Or one version of ANSI Utopia to another. 😀 ANSI and ISO standards also necessarily change over time. Since no RDBMS is fully compliant with either, then use the performance tools of whatever you're programming in because it's going to change anyway.
Also, some implementations of ANSI standards are just terrible. For example, use of SQL Server's FORMAT function should be illegal (and will be in the standards for the company I work for). It's no less than 44 times slower than the ol' CONVERT method.

In the "old" days, I had systems which used different databases, ended up writing everything in pseudo code and flow diagrams, then that became the common base and everything was a translation to the destination database. The ANSI standard proofed to be utterly and entirely useless.

😎

BTW, FORMAT is NOT allowed on my systems;-)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

GilaMonster (7/15/2015)
Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....

Sounds like client requests - no requirements but a due date.

End results - useless solution 😀

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 13

SQLRNNR (7/15/2015)
GilaMonster (7/15/2015)
Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....
Sounds like client requests - no requirements but a due date.
End results - useless solution 😀

Give the client what they want, not what they ask for, without asking questions. Too many try to do this and fail. I wonder why? 😎

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 14

Alvin Ramard (7/15/2015)
SQLRNNR (7/15/2015)
GilaMonster (7/15/2015)
Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....
Sounds like client requests - no requirements but a due date.
End results - useless solution 😀
Give the client what they want, not what they ask for, without asking questions. Too many try to do this and fail. I wonder why? 😎

A swift kick in the patookis?:crazy:

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

rodjkidd SSCoach Points: 15916 More actions · Answer 15

Oh looks like the relay web site has been updated...

Now taking submissions for sessions!

http://www.sqlrelay.co.uk/

Rodders...