Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 48,136 through 48,150 (of 66,675 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

GilaMonster (4/8/2015)
On the subject of reading...
https://www.thedodo.com/pets-interrupting-reading-968102862.html

I love that link. I had cats and dogs (and children) like that and somehow managed never to throw them at things.

Tom

Jeff Moden SSC Guru Points: 1004166 More actions · Answer 2

Brandie Tarvin (4/8/2015)
Jeff, what did you mean by "retro code" when you were talking about how hosed up SSMS got?

I'll see if I can find the links I was looking at about this. There was also a connect item on the subject of (IIRC) some always-on problems and a bunch of other things. They came out with CU5 for 2012 on March 16th to supposedly fix that but don't yet know if they fixed all the serious little gotcha's in SSMS. It would take me quite some time to write them all up but might do it just to submit as a bug list in Connect.

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

Brandie Tarvin (4/8/2015)
GilaMonster (4/8/2015)
Does this answer your question?
Those are two instances on the same server, one 2012 and one 2014 and I opened both from the same SSMS 2014
The bug doesn't always show up immediately for me. Sometimes I can be working for about 10-30 minutes before that refresh causes one of them to go down.
Can you leave those screens open for a while and see if it pops for you?

Both still refreshing fine ~17 hours later, they've been refreshing every minute

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

Brandie Tarvin SSC Guru Points: 173033 More actions · Answer 4

GilaMonster (4/9/2015)
Brandie Tarvin (4/8/2015)
GilaMonster (4/8/2015)
Does this answer your question?
Those are two instances on the same server, one 2012 and one 2014 and I opened both from the same SSMS 2014
The bug doesn't always show up immediately for me. Sometimes I can be working for about 10-30 minutes before that refresh causes one of them to go down.
Can you leave those screens open for a while and see if it pops for you?
Both still refreshing fine ~17 hours later, they've been refreshing every minute

Thank you, Gail. You can close them now. I'm glad to hear that the bug has been fixed. It drives me nuts in 2008.

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.

venoym SSCarpal Tunnel Points: 4161 More actions · Answer 5

SQLRNNR (4/8/2015)
Brandie Tarvin (4/8/2015)
Jason, what screen resolution are you using?
That happens on both of my monitors.
One is 3200x1800 and the other is 1680x1050.
It is an issue in many of the screens in ssms 2014 but not 2012.

Which DPI are you using? I've seen that happen a lot when someone ups the DPI to about 200% (normal is 96, 200% is 192). Most applications do not auto size text labels when the DPI is changed from the 96 default (most common is 120 under Windows XP, but Windows 7 and beyond allows for a percentage change).

Resolution would make the entire window smaller and the text smaller. Changing the DPI setting would increase the size of the text without changing the window size by much.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

venoym (4/9/2015)
SQLRNNR (4/8/2015)
Brandie Tarvin (4/8/2015)
Jason, what screen resolution are you using?
That happens on both of my monitors.
One is 3200x1800 and the other is 1680x1050.
It is an issue in many of the screens in ssms 2014 but not 2012.
Which DPI are you using? I've seen that happen a lot when someone ups the DPI to about 200% (normal is 96, 200% is 192). Most applications do not auto size text labels when the DPI is changed from the 96 default (most common is 120 under Windows XP, but Windows 7 and beyond allows for a percentage change).
Resolution would make the entire window smaller and the text smaller. Changing the DPI setting would increase the size of the text without changing the window size by much.

It is on the default setting.

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 7

Somebody with more SSIS knowledge than me (which isn't hard to accomplish) want to lend a hand?

http://www.sqlservercentral.com/Forums/Topic1675814-392-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Luis Cazares SSC Guru Points: 183699 More actions · Answer 8

I finally found Dwain's secret.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Luis Cazares (4/9/2015)
I finally found Dwain's secret.

Yeah it really just boils down to a fish story.

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 10

Luis Cazares (4/9/2015)
I finally found Dwain's secret.

It won't display here. Says the image contains errors. :w00t:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

Sean Lange (4/9/2015)
Luis Cazares (4/9/2015)
I finally found Dwain's secret.
It won't display here. Says the image contains errors. :w00t:

He he, not the thing I would think of in the context of Fish Fingers

😎

Sean Lange SSC Guru Points: 286590 More actions · Answer 12

For any of you regular speakers I could use a little help over here. http://www.sqlservercentral.com/Forums/Topic1675923-61-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Dwain Camps SSC Guru Points: 86938 More actions · Answer 13

Sean Lange (4/9/2015)
Luis Cazares (4/9/2015)
I finally found Dwain's secret.
It won't display here. Says the image contains errors. :w00t:

Maybe that's what he means after the code I posted to his recent question on inserting zeroes padding in the middle of a number.

I can't see it either and I am most certainly curious to know what my secret is.

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

Luis Cazares SSC Guru Points: 183699 More actions · Answer 14

That's weird. The image is hosted in here.

Does anybody else have the same problem?

EDIT: Original source of the picture in here: http://www.moef.dk/fishfingers/

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Brandie Tarvin SSC Guru Points: 173033 More actions · Answer 15

Luis Cazares (4/9/2015)
That's weird. The image is hosted in here.
Does anybody else have the same problem?
EDIT: Original source of the picture in here: http://www.moef.dk/fishfingers/

I can see the original source, I couldn't see the attached one.

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.