Thoughts on Advent of Code
Over the past couple of days I’ve posted several times about the Advent of Code Contest and worked my way through...
2015-12-24
726 reads
Over the past couple of days I’ve posted several times about the Advent of Code Contest and worked my way through...
2015-12-24
726 reads
This one gives you a 1000 rows of package dimensions. You calculate the surface area needed for wrapping paper, plus...
2015-12-23
680 reads
Part 1 isn’t bad. Parse a string that has direction indicators and track each location you stop at. I’m trying...
2015-12-23
1,016 reads
Adding to my solution for #3 part 2, I finally got it, but I paid the price for not adding...
2015-12-23
713 reads
I just donated $10 to Wikipedia. I use it and find it useful, so I don’t mind contributing so that...
2015-12-22
575 reads
It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations....
2015-12-22
644 reads
Today we have a guest editorial from Andy Warren. We still have many applications runnning under sysadmin accounts, often "sa". Why do people do this? Andy has a few thoughts on the subject.
2015-12-21 (first published: 2011-05-04)
541 reads
Sometime in the next couple weeks Rodney & Karla Landrum are moving from Orlando to Pensacola (home). I’m happy for them...
2015-12-21
627 reads
I saw the post from Steve Jones about the Advent of Code contest and decided to take a look. The first...
2015-12-18
671 reads
Khan Academy is doing a fund raiser and I just donated $10 to help out – my kids have easily gotten...
2015-12-15 (first published: 2015-12-14)
1,746 reads
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers