Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 66,061 through 66,075 (of 66,815 total)

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

Michael L John One Orange Chip Points: 27079 More actions · Answer 1

It's on it's way. I have my blankets and footsie warmers ready.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 2

-38 is cold. yikes. My coldest was about this temp in SYR, but with wind that dropped it around -40. Hard to walk and breathe there. No wind yet here, so it's just a slow chill.

I did have to take breaks from shoveling manure to warm my hands. The gloves I normally use don't work so well at this temp. About every 20 minutes need to warm them inside a jacket. I'm taking hand warmers out for the afternoon shift.

Michael L John One Orange Chip Points: 27079 More actions · Answer 3

-38. Wow. The coldest I was ever out in -13 on a camping trip. In a tent.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 4

We survived, a lot of manure work and bundling up to manage horses, but got through it. Today is a balmy -1F when I started breaking ice in water buckets

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 5

Just for fun, -40 degrees is where the Celsius and Fahrenheit scales cross.

--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: 182948 More actions · Answer 6

Eirikur Eiriksson

SSC Guru

Points: 182948

December 23, 2022 at 5:32 pm

#4129481

Excuse the pun, but -40 is F**C cold 😉

😎

Scott Mildenberger Ten Centuries Points: 1399 More actions · Answer 7

Eirikur Eiriksson wrote:

Excuse the pun, but -40 is F**C cold 😉 😎

Or as I told my wife after shoveling snow yesterday, "it is RFC"

Jonathan AC Roberts SSCoach Points: 18407 More actions · Answer 8

Scott Mildenberger wrote:

Eirikur Eiriksson wrote:
Excuse the pun, but -40 is F**C cold 😉 😎
Or as I told my wife after shoveling snow yesterday, "it is RFC"

How do you persuade your wife to shovel snow? 😁

Scott Mildenberger Ten Centuries Points: 1399 More actions · Answer 9

Jonathan AC Roberts wrote:

Scott Mildenberger wrote:
Eirikur Eiriksson wrote:
Excuse the pun, but -40 is F**C cold 😉 😎
Or as I told my wife after shoveling snow yesterday, "it is RFC"
How do you persuade your wife to shovel snow? 😁

Hmmmm, never figured that out 🙂

Michael L John One Orange Chip Points: 27079 More actions · Answer 10

Scott Mildenberger wrote:

Jonathan AC Roberts wrote:
Scott Mildenberger wrote:
Eirikur Eiriksson wrote:
Excuse the pun, but -40 is F**C cold 😉 😎
Or as I told my wife after shoveling snow yesterday, "it is RFC"
How do you persuade your wife to shovel snow? 😁
Hmmmm, never figured that out 🙂

Double Hmmmm. Maybe if my wife shoveled snow, I would still be married??

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 11

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other than the following article, does anyone have a link to a decent article with some demonstrable proof in the form of code that either kind (logical or physical/page density) actually makes a substantial difference in performance? Ironically, Jonathon proved there may be an advantage to fragmented indexes.

https://sqlperformance.com/2017/12/sql-indexes/impact-fragmentation-plans

Yep... I get that the Physical/PageDensity type of fragmentation has an effect on memory usage and can lower the amount of time some things spend in memory but I'm looking for actual run time differences between identical data in tables where 1 is 0% logically fragmented and the other is 99% fragmented even for cold-cache loads.

In case you can't tell, I've been watching 'tubes and reading articles on the subject of fragmentation and they all say that "fragmentation affects performance" but I've not found a one, other than the article I cited above, that proves that de-fragmentation substantially improves run times.

Another bone I'm getting ready to pick is all these people that say "Reorganize takes less time than a Rebuild", "Reorganize takes fewer resources than a Rebuild", "Reorganize is easier on the log file than Rebuild (I've proven that's totally incorrect more than once)" but NONE of them have proven it.

Any links that actually prove how de-fragmentation makes a substantial difference in performance (save that of total "Index Inversion" due to Shrink File) or proves any of the other claims would be greatly appreciated because I'm not finding any.

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

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 12

BWAAA-HAAA-HAAA. Posting on this thread must cause disturbances in the "force". I looked again right after I posted and I finally found one.

https://gertjans.home.xs4all.nl/sql/fragmentation-hurts-performance.html

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

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 13

And, then again, NOT! It turns out that he was testing fragmentation on spinning rust. Not logical fragmentation of a index. [headdesk] 🙁

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

Michael L John One Orange Chip Points: 27079 More actions · Answer 14

Jeff Moden wrote:

BWAAA-HAAA-HAAA. Posting on this thread must cause disturbances in the "force". I looked again right after I posted and I finally found one.
https://gertjans.home.xs4all.nl/sql/fragmentation-hurts-performance.html

He also was only testing a table scan.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 15

Michael L John wrote:

Jeff Moden wrote:
BWAAA-HAAA-HAAA. Posting on this thread must cause disturbances in the "force". I looked again right after I posted and I finally found one.
https://gertjans.home.xs4all.nl/sql/fragmentation-hurts-performance.html
He also was only testing a table scan.

Yeah... and no actual data access. He was using the SELECT as a Pseudo-Cursor to dump GETDATE() for a variable. And, it was back in the days when spinning rust was pretty much all that was available.

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