I remember using it once. There was compression done outside of the database, and the data was stored compressed. But for some reason, the database also needed to be able...

Yes, maintainability is key. But, the technology used is only part of the choice. The actual design of the solution is probably more important. If it is designed well, and...

I too saw Tufte's presentation. I saw it a couple years back in Chicago. I particularly remember the discussion about the role that PowerPoint may have played in the Challenger...

I recently passed Exam 70-461. I used the Exam Training Kit from Microsoft Press. I was able to order the book earlier this year... March or April time frame. It's...

So, I thought, I'd post a reply to my own question. 'Cause I think I figured out what was going on, and I wanted to share it...

I believe that the...

I've worked in numerous environment, and the ratios have been all over the place. One place I worked we had no DBA, but easily 20+ developers. Although, there was probably...

So, I'll sort of echo what's already been said...

If we're looking at just the data engine, I'd look at other products, too.

But as soon as the requirements start needing ETL...

This reminds me of an article I came across earlier in my career... The gist of the piece was that every employee should know how to do their jobs without...

Thanks everybody!

I actually saw the IF construct in several stored procedures that I was asked to review, and it made me wonder why somebody would do that. Cause, I'd probably...

Jeff,

So, it was a fairly small dataset, one table had a couple hundred rows. The other had 3 rows. And, I can certainly see that as the row count got...

Steve, I think you "hit the nail on the head" when you said that SQL Server includes a lot of features beyond the database engine. If you're coding to ANSI...

So, I did a little playing around myself, and discovered that as far as performance goes there is zero difference. At least with the size data set that I was...

Yes, I agree 100% percent.

When I worked for a large building automation company, we moved one of our tools to Microsoft Azure. It was a foregone conclusion that we'd use...

One possible reason for a discriminator column is implementing the Table-Per-Hierarchy (TPH) pattern using Entity Framework (EF). In TPH, an entire class hierachy is stored in a single table, and...

So, here's what I've come up with...

SET NOCOUNT ON;

DECLARE @MisnamedConstraints TABLE

(

OldConstraintName SYSNAME,

NewConstraintName SYSNAME,

ParentObject SYSNAME,

ColumnName SYSNAME,

ConstraintDefinition NVARCHAR(Max)

)

-- Find all constraints on multistatement table-valued functions where the

-- constraint name doesn't match the...