Good Question.
I was thinking to myself that not enough information was provided about the table structure to answer - since there is no guaranteed order, but we know how...

SELECT X.Person, SUM(X.NetBeerCount) as NetBeerTotal
FROM (    SELECT OwedTo as Person, Beer as NetBeerCount FROM myBeers WHERE EarnedDate < GETDATE()
        UNION ALL
        SELECT OwedBy, Beer * -1 FROM myBeers WHERE EarnedDate...

When SQLCLR first came on the scene we used it to proof of concept some generic auditing and encryption / decryption. However, we went different directions with both. The only...

It depends on the turn around time, but I have used all of the methods outlined. One not mentioned that I have also used is to have a couple different...

NULL is my go to default for representing "Unknown" or "Missing". I cannot think of a time when doing OLTP where I ever needed to use a magic value to...

Still a decent question as I had to look up the difference in the editions.

I learned something from that and the the comments in the post.

Thank you for submitting it.

I use SSDT in visual studio for database projects and I use the built in test tooling for automated unit testing.

It has a nice SQL syntax wrapper over the...

Got me on this one.

I need to play with SSIS in 2016.

I just guessed that the truncation would work similar to previous versions and throw an error unless you...

And if you have a linked server connecting to Oracle

CREATE SYNONYM [dbo].[TestSynonym] FOR [TestLinkedServer]..[Workspace].[TableName]

GO

I think with the current data model and lack of constraints you would actually want both.

WHERE Played = 'Rock' OR Played = 'Paper' OR Played = 'Scissors'

GROUP BY Person HAVING...

When you installed SQL Server 2014 you had the option to install SSIS as a component.

If you want to run SSIS packages / projects on your server then you will...

We typically use schemas to separate application object / process areas

APP

CONFIG

STAGE

MDM

DW

REPORT (app specific)

TEST

We also use a CUSTOM schema for customer's to add their own objects, such as views so that...

To backup which statements? That estimates are bad?

Medical

Lawyer[/url]

Software[/url]

You should be able to...

Steve Jones - SSC Editor (9/1/2015)

---

Yes, very true. We need to deal with it. I think we also need to set better expectations, as well as perform better.

We do ask...

I think changing scope and situations occur in every industry and the entire reason we are paid is because as professionals we deal with it.

When you are billing time and...