Tim Erickson

Technical Consultant versed in #SQLServer, #SSIS, #SSRS, and dabbling in #PowerBI. Dad of twins.

[Tim Erickson @SQL_TimE]

@DataCamp is offering all of its' courses for free this week, until Friday. Myself, I'm taking a look at Python. Check it out! https://t.co/WDF1yTrPD7 #data #learning #free #python #sql #R

[Super 70s Sports @Super70sSports]

Tom Brady: Drinks kale smoothies and 25 glasses of water a day in the off-season in hope of just making it to a Super Bowl.

Len Dawson: Drinks a Fresca and heats a lung dart at halftime of the Super Bowl he’s actively fucking participating in.

Advantage: Dawson

[Tim Erickson @SQL_TimE]

@PawarBI @dataveld Had this convo internally and brought this up before seeing this - went the simple average route which ended up being more precise for our purposes. Thanks for your reply!

[Tim Erickson @SQL_TimE]

#PowerBI is there a way to calculate a sum of all percentages that have already been calculated in a measure? Ex. would be 97% + 94% + 42% = 233% grand total.

[Tim Erickson @SQL_TimE]

Second requirement would be to then average those percentages out - not by the three you see, but by the count of those records (let's say that there are five calculations with 0% that we also want to include, so take the 233% above and divide by 8 = 29.13%)

[Tim Erickson @SQL_TimE]

Okay, I'll play the #FivePerfectMovies game, not necessarily by how "good" they are but for what they are attempting to achieve:

Goodfellas
The Shawshank Redemption
Swingers
Monty Python and the Holy Grail
Avatar (simply for the technological breakthrough in cinema)

[Tim Erickson @SQL_TimE]

@Super70sSports As a Timmy, this is absolutely 100% fact. #OwningIt

[Tim Erickson @SQL_TimE]

@patrickbnj @RiverOaksPrblms @Super70sSports Nice to see we have a similar sense of humor and taste in Twitter follows, Patrick. How you been these days?

[Tim Erickson @SQL_TimE]

@SqlWorldWide @BrentO @AaronBertrand Now the only issue is that since this is a #D365FO cloud-hosted implementation, PROD is totally 100% Microsoft-managed, all the way to both the code and database level, so this will have to be approved by MS in order to be run...

[Tim Erickson @SQL_TimE]

#sqlhelp is there an efficient yet (relatively) fast way to delete (not truncate) over 20 million rows from a table? Trying to be mindful of locking, I’m also aware of using DELETE TOP (x) FROM TABLE but still think that may pose a locking risk...

[Tim Erickson @SQL_TimE]

@SqlWorldWide @BrentO @AaronBertrand Thanks for the help #sqlfamily! I'm going with the batch and loop method for now using DELETE TOP (5000) - probably could go more at a time but trying to be cautious.

[Tim Erickson @SQL_TimE]

I tried SQLCMD on a DEV machine first to generate the delete statements one at a time based on the PK, but obviously it is taking forever...

[Tim Erickson @SQL_TimE]

A little dose of #humanity for your Friday: https://t.co/svVviplyyx
#covid19 #HappyFriday

[Tim Erickson @SQL_TimE]

@Mrjimflorentine If you used the word "drop," I think we all know what you would have actually meant.

[Tim Erickson @SQL_TimE]

And just to add my own answer - in my four years of #RemoteWork, I've only known of a handful of instances where I've been in a meeting where video was utilized. I think I prefer audio, but there are times I wish it were more mixed.

[Tim Erickson @SQL_TimE]

Posing a random question to #SQLFamily and anyone that's either been in a #RemoteWork environment full-time for a while or just being thrown into this given the times:

Are your #MicrosoftTeams or #Zoom meetings audio-only or do you incorporate video as well?

[Tim Erickson @SQL_TimE]

@tjaybelt I've been purely remote for four years now and absolutely love it, and with the current state of affairs, this might really open the doors in persuading a lot of company talent management personnel to offer this as a viable, legitimate option for potential candidates. #RemoteWork

[Tim Erickson @SQL_TimE]

@Super70sSports Farley would have done absolutely anything to get a laugh, he surely seemed like one of the most genuine and humble guys from that era. If you get a chance to dig up his Splash Zone skit with #GeorgeClooney and #JaneaneGarofalo it's worth a look... absolutely hilarious.

[Tim Erickson @SQL_TimE]

Finally made the choice to get rid of cable TV today, and to Comcast's credit, the CSR (named Kia) was unbelievably helpful, courteous and friendly. Complete polar opposite of what I would have expected. Thanks Kia, and kudos to #Comcast! #CustomerService #Friendliness #Courtesy

[Tim Erickson @SQL_TimE]

@markvsql @MartijnAlsem @tjaybelt @GuyInACube And I've seen @GuyInACube's tutorials on both RLS and workspaces in the Premium capacity. Thanks for all the content that is available!

[Tim Erickson @SQL_TimE]

Question for @tjaybelt or @markvsql since I've seen their #PowerBI expertise... either of you know if the capability exists to have multiple subtotal lines in one matrix visualization? Example in this case would be a subtotal row for Hours, and a subtotal row for Dollars...

[Tim Erickson @SQL_TimE]

@markvsql @MartijnAlsem @tjaybelt @GuyInACube Appreciate all the insight from the #PowerBI community. Requirements ended up getting a shakeup and it looks like we need to leverage another solution, but thanks for all your help regardless!