I've been interviewing after being laid of in March (my place was acquired and they reorganized a number of us out of the company) and two things came up this...

Correct answer should be 4.  

I took a quick look and was surprised the official documentation doesn't make it clear that if you specify no measures in the...

I find this piece of documentation extremely helpful when dealing with SSIS data types.
https://docs.microsoft.com/en-us/sql/integration-services/data-flow/integration-services-data-types

Check out the sections on converting.  I think you need to define it...

What is going to digest the results of these queries?  I can't think of many applications that can handle different columns in a single result set.

How confident are you that the changed data is always going to come in through the stored procedure call?

I'm not a fan of triggers but they're a better...

I did some BASIC is high school and remember thinking I'd never work with computers as a "real" job.  During college I fell into doing some dBase III+ programming (gotta...

DaveJenkins (9/29/2016)

---

Totally agree, I got this wrong. My gut was option 3, ran the code to make sure as I don't like to assume. It produced 9, which is not...

At this point, I've designed a number of application and data warehouse databases from scratch. I've been the only or senior SQL guy at my last few jobs so...

Should have paid more attention to the QotD title.

Great article. Thanks.

I mistyped, I added it as a NCHAR(1) data type.

I feel like the metadata or package itself got corrupted or some such. I had dropped and recreated all the...

Thanks. I actually just solved it this week using help from Chris Webb's blog:

https://cwebbbi.wordpress.com/2013/05/29/aggregating-the-result-of-an-mdx-calculation-using-scoped-assignments/