Just to make sure we are all on same page, the way I've heard the Microsoft CAT engineers explain for row and page compression that the data is compressed both...

Unfortunately I do not have before and after data size numbers fro the row compression on our production OLTP database. But I did use (as documented in the script)...

You are correct; compressing small lookup tables actually may increase the overall size. That is why I exclude any tables less than 8 pages in my script. I...

Yes I did look at page compression, but the community consensus is that you should only do page compression for fairly static tables. If you have to update or...

In my "second" career (retirement from military was first) I was CTO for an insurance company for over 9 years when a new General Manager asked me to leave (about...

At first reading I thought that was a neat idea, but on reflection (and sadly experience), what runs on one machine and one set of data does not mean it...

OK, I think I've figured it out. The original definition of the FK included a "NOT FOR REPLICATION" clause. If I delete the clause and recreate the FK...

Data is valid between the 2 tables:

The following query returns a empty result set:

select * from Adapter.ServiceConfiguration

where CreateComponentID NOT IN (select SysComponentID from SysComponent where SysComponentID IS Not...

And I thought that re-enabling the FK constraint also only applied to future updates. And you can see from my example that the FK constraint is_disables is set to...

This is after a re-enable of the constraint. Now I want to get the constraint back to a is trusted state.

While I understand the need for privacy, I also do some snooping just to understand the characteristics of the data within the database. All the planning in the world...

Interesting question. We all code differently and usually my way is not the only way. We are all subjective in the best way to write code and usually...

I think the role of SQL Server DBA is under-rated and over-used. My title is Senior Database Developer and I help our sole DBA with performance issues and setup....

Hmmm, computers have been my hobby for last 35 years. During my last few years in the USAF I even free-lanced for PC Magazine (nothing like having $12,000 worth...

Having been on both sides of the fence, I would hope that the annual performance review includes a two-way dialogue for both the manager and the employee. I've been...