Are the posted questions getting worse?
- DesNorton wrote:
Your fingers might get considerably shorter, but you could always add a lot of these ...
IF UPDATE (colName )
BEGIN
-- Add your column to DSQL ...
END;Thanks. The problem there is that dynamic SQL cannot see the Inserted or Deleted tables.
--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) -
Dupe post so the forum software would actually let people see this page. 🙁
--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) -
-
Where I am at in Montana it was -14 this morning but about 100 miles away I saw it was -38, so it could be worse 🙂
-
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/ -
-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.
-
-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/ -
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
-
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) -
Excuse the pun, but -40 is F**C cold 😉
😎
- 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"
- 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/ -
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)
Viewing 15 posts - 66,076 through 66,090 (of 66,547 total)
You must be logged in to reply to this topic. Login to reply