So, how's everyone surviving the shut in?

We've got a nice day on tap here, and while I'm putting in a couple extra hours this afternoon, I think I still...

I think you also find that the Date data coming from an AS400 or IBM PowerSystem will contain all 0's for "null" dates.

Also, don't use VARCHAR(10) to hold string representations...

While I totally agree with the first statement there, I seriously...

Before answering your question, first you need to priorities why you need compression. If the answer is you need to save space, then you will benefit from index compression....

When you have lot of budget then we will prefer the consultant, but handling sql 7.0 to till 2017 we need to take over this with being backup and...

oh well.

Should I not even bother compressing non-clustered indexes?

what if my table does not have clustered indexes? it only has a composite primary key, non-clustered. And a dozen of...

I can't comment much about your good article other than it seems well laid out and produces the correct order of revelation.  So nice job there.

I'll also state that I...

I have a tip... Download the Developer's Edition of T-SQL, a copy of SQL Server "Books Online", and start teaching yourself more about SQL Server so that when you do...

What would be more interesting is what the CLR assemblies actually do.  A lot of people resort to CLR simply because they don't know how to do something in T-SQL. ...

I'm trying to set up a format file using bcp but I'm unsure of how to set it up.

I used "bcp de_identified.dbo.test format -c -t -f c:\sql\test3.fmt -T" and...

A trillion row table and you folks have no previous experience with partitioning.  My recommendation is that you don't try this on your own.  Get a consultant that really knows...

Excellent!  I have found that "The answer is always 'NO'... unless you ask". 😀

In what table design/scenarios should I prefer a Row level compression and not Page level?

Like if we were to name one major advantage of one over another, and possibly...

THANKS!

Question: can there be any reason that an error will be thrown while attempting to compress the table? Like what should be 'wrong' with table to cause the compression...

I'm sorry... I forgot to add that you can get the fnTally function from the similarly named link in my signature lines below.