Viewing 15 posts - 1 through 15 (of 141 total)
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...
January 2, 2018 at 6:20 am
SELECT X.Person, SUM(X.NetBeerCount) as NetBeerTotalFROM ( SELECT OwedTo as Person, Beer as NetBeerCount FROM myBeers WHERE EarnedDate < GETDATE() UNION ALL SELECT OwedBy, Beer * -1 FROM myBeers WHERE EarnedDate...
September 18, 2017 at 6:45 am
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...
August 11, 2017 at 5:45 am
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...
April 21, 2017 at 5:45 am
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...
March 3, 2017 at 5:59 am
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.
September 21, 2016 at 4:55 am
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...
July 25, 2016 at 5:30 am
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...
July 13, 2016 at 5:05 am
And if you have a linked server connecting to Oracle
CREATE SYNONYM [dbo].[TestSynonym] FOR [TestLinkedServer]..[Workspace].[TableName]
April 4, 2016 at 5:05 am
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...
March 24, 2016 at 8:42 am
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...
January 6, 2016 at 5:26 am
We typically use schemas to separate application object / process areas
REPORT (app specific)
We also use a CUSTOM schema for customer's to add their own objects, such as views so that...
November 13, 2015 at 5:58 am
robert.sterbal 56890 (9/1/2015)Again, is there any data to back up any of these statements about programmers, doctors, lawyers, etc?
robert.sterbal 56890 (9/1/2015)
To backup which statements? That estimates are bad?
You should be able to...
September 1, 2015 at 12:21 pm
Steve Jones - SSC Editor (9/1/2015)
We do ask...
September 1, 2015 at 11:45 am
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...
September 1, 2015 at 5:49 am