.

>The new column has to fit on the original page.
Does that mean the entre table/leaf node pages have to be re-organised ? That way there is no 'row chaining'...

@TheSQLGuru (Kevin), The values are also different. It is a unique clustered index. the companyid and periodenddate are same, but formid is different.

@Gila, this code is...

@jeff, yeah we fixed the top 5 query SPs after a 2 year back-n-forth with vendor.. we've reached the end of tuning efforts
it's not CLR, just regular...

@jason, I've been monitoring the size for past couple years - 8 data files are pre-grown to 1GB each - they never grow more. and a 65 GB...

Agree on the $110-120K, but it's hard with the 5-10 year exp. bracket, if you are in the same job for long time.

Assuming you start at ~$60K after graduating college...

Virtualization offers us other benefits like snapshots etc., and we're OK with the slight overhead.

Only now it is dedicated, cos VM needs that many cores. After we upgrade, it can...

nevermind, just thought of workaround - I can insert record into table and then check rowcount

insert into #tmp select

top 1 1 FROM CHANGETABLE(CHANGES dbo.UserPrefs, @last_sync_version) AS ct

WHERE (ct.SYS_CHANGE_CONTEXT...

I read somewhere SSC has 600K visitors. Assuming 10% see the salary survey, and 1% respond, that is 6000 responses. I'm also trying to advertise this on stackexchange, and popular...

> What are you trying to accomplish with this survey?

To get many responses and make the data collected useful

FYI, the salary survey has been published on home page - https://www.surveymonkey.co.uk/r/SSC-Salary-Survey-2016

Spread the word !

1. should have mentioned, we use Enterpise (have SA with M$)

2. oltp box, see cxpacket waits, maxdop was 2 before, wasn't giving up much performance gains anyways, so changed to...

@RVarn , there is no external pressure . this is a SQL-only box (no apps), with 32GB ram on OS and 28GB max mem for SQL

There is no 'internal pressure',...

@Eirikur, one article says PLE is not what it seems, and another says BCHR is not what it seems 🙂 .. just like 'latest scientific studies show X is both...