Have you verified that the out of row setting on the table is actually active?

I sure am happy to see that I'm not the only one that thinks the contributors that seriously helped make this forum great have taken it in the socks in...

Jeff,

Re:  sp_ShowWorst

Question:  will collecting rows from SYSTEM DBs (i see a lot from msdb, master...)  be beneficial to me in any way?

i am thinking to easily  modify/limit it to...

Changing the option only applies for new rows.  The rows that were in the table before you changed the option will stay where they were.  Could that be what's...

What I'm concerned about is that it appears that it sounded like you have several temporal tables but management was asking you for any and all changes to every table. ...

Heh... exam dumps and other cheater methods (and that's what they are to me)...  This is one of the primary reasons why (except for the MCM certification, which they no...

First things first... has management approved the purchase of at least 10 times the amount of disk space you'll need to store just the next year's worth of changes? 😉

Ok, so let's just say that PASS, as an organization, disappeared (and I hope it doesn't).  Who would take the responsibility for the SQLSaturday site?  Who would fund the box...

<<< https://www.sql.ru/forum/96127/sp-who3%5B/quote%5DMsg 8152, Level 16, State 13, Line 1

String or binary data would be truncated.

DBCC execution completed. If DBCC printed error messages, >>.   Jeff, what parameters did you call...

Sure, found it, thank you. I know, my habit to laziness caused me to ask a simple question I should not have been asking... yet there is a variation...

With the idea of teaching a man to fish, lookup each of the DMVs that sp_ShowWorst calls upon in the MS documention and look for the "Permissions" section.

You might already...

It's not really a useful thing... there are 14 different "week" patterns (one for each day of the week times 2 because of leap years) and there's the issue of...

Saying something as nebulous as "it didn't work" without telling us WHAT about it...

I am submitting an official request for DBA of certain servers to run a script on those servers and give me back the resultset.

However the script (the actual script...