Viewing 15 posts - 31 through 45 (of 62 total)
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)...
Mike Byrd
January 13, 2011 at 12:30 pm
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...
Mike Byrd
January 13, 2011 at 6:34 am
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...
Mike Byrd
January 13, 2011 at 6:30 am
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...
Mike Byrd
October 22, 2010 at 7:21 am
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...
Mike Byrd
September 13, 2010 at 9:15 am
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...
Mike Byrd
September 3, 2010 at 1:27 pm
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...
Mike Byrd
September 3, 2010 at 1:06 pm
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...
Mike Byrd
September 3, 2010 at 12:59 pm
This is after a re-enable of the constraint. Now I want to get the constraint back to a is trusted state.
Mike Byrd
September 3, 2010 at 11:40 am
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...
Mike Byrd
August 2, 2010 at 6:43 am
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...
Mike Byrd
July 2, 2010 at 6:38 am
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....
Mike Byrd
June 25, 2010 at 2:36 pm
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...
Mike Byrd
May 28, 2010 at 7:58 am
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...
Mike Byrd
April 30, 2010 at 8:04 am
Good article and glad to see numbers attached to it.
One question, though, when you apply row or page compression is the table (and its respective indexes) still accessible...
Mike Byrd
April 23, 2010 at 2:04 pm
Viewing 15 posts - 31 through 45 (of 62 total)