November 30, 2022 at 6:02 am
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
Change is inevitable... Change for the better is not.
November 30, 2022 at 6:04 am
Dupe post so the forum software would actually let people see this page. 🙁
--Jeff Moden
Change is inevitable... Change for the better is not.
December 22, 2022 at 8:05 pm
December 22, 2022 at 8:13 pm
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 🙂
December 22, 2022 at 8:54 pm
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/
December 22, 2022 at 8:57 pm
-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.
December 23, 2022 at 3:30 am
-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/
December 23, 2022 at 4:43 pm
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
December 23, 2022 at 5:10 pm
Just for fun, -40 degrees is where the Celsius and Fahrenheit scales cross.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 23, 2022 at 5:32 pm
Excuse the pun, but -40 is F**C cold 😉
😎
December 23, 2022 at 6:02 pm
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/
December 28, 2022 at 12:22 am
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
Change is inevitable... Change for the better is not.
Viewing 15 posts - 66,076 through 66,090 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply