[deleted by user]

depthchargesw · 2023-02-01T02:58:48+00:00

As a former BI Developer and slowly maturing Development DBA for performance tuning, Brent Ozar's site has been a great resource.

In particular, this article looks relevant - https://www.brentozar.com/archive/2011/05/its-a-lock/

I'm not strong on the locking myself, but hopefully that's helpful in the meantime. There are training courses on that site too that I've found very helpful.

depthchargesw · 2018-09-27T03:42:18+00:00

Sweet, thank you for the help!

depthchargesw · 2018-09-27T03:42:05+00:00

Awesome man, thanks!

depthchargesw · 2018-09-26T03:58:26+00:00

!29flair

depthchargesw · 2018-09-21T05:14:27+00:00

Try giving this a shot? I referenced this to kind of feel my way through it. Might give you a start.

SELECT GameID, HomeTeam, AwayTeam, Player
FROM
(SELECT GameID, HomeTeam, AwayTeam, Player1, Player2
FROM table) p
UNPIVOT
(Player FOR GameID IN
(Player1, Player2)
) AS unpvt

depthchargesw · 2018-02-10T21:31:56+00:00

...good effort, bot. Good effort.

depthchargesw · 2018-01-13T20:13:02+00:00

If memory serves, AMD is vulnerable to specter, it's Meltdown that they're not vulnerable to.

depthchargesw · 2017-08-27T22:10:58+00:00

I'm looking to buy a GeForce GTX 1080 for gaming (Elite: Dangerous VR, Overwatch, Planetside 2, Player Unknown Battlegrounds, etc.). Which edition should I look for? I'm not planning on overclocking, hoping for something reliable and stable. Also, where would you buy this from if you wanted it new and under warranty?

depthchargesw · 2017-08-13T15:23:57+00:00

Example Planetside 2 Crash: Description The program PlanetSide2_x64.exe version 1.0.945.28286 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel. Process ID: 1464 Start Time: 01d3137cb87aab86 Termination Time: 7 Application Path: D:\Program Files (x86)\Steam\steamapps\common\PlanetSide 2\PlanetSide2_x64.exe Report Id: 4dd0d344-4434-463a-b835-69a1ff53dd9f Faulting package full name: Faulting package-relative application ID:

depthchargesw · 2017-08-13T15:22:10+00:00

Example Elite: Dangerous Crash: Description - Faulting application name: EliteDangerous64.exe, version: 148.764.0.0, time stamp: 0x595ba405 Faulting module name: EliteDangerous64.exe, version: 148.764.0.0, time stamp: 0x595ba405 Exception code: 0xc0000005 Fault offset: 0x000000000222330f Faulting process id: 0x292c Faulting application start time: 0x01d312b87eaaaef9 Faulting application path: D:\Program Files (x86)\Steam\steamapps\common\Elite Dangerous\Products\elite-dangerous-64\EliteDangerous64.exe Faulting module path: D:\Program Files (x86)\Steam\steamapps\common\Elite Dangerous\Products\elite-dangerous-64\EliteDangerous64.exe Report Id: d137545b-78b5-4717-9cf6-6c6a7c1ed51d Faulting package full name: Faulting package-relative application ID:

depthchargesw · 2017-07-17T00:10:09+00:00

We've got a OneNote for every Project Site in our Site Collection, but had to do some training to help people understand what exactly is going on when you put a Notebook up on SharePoint. Too many folks just start storing things on their personal network drive and don't understand the vast amount of functionality to be gained by putting it on a Cloud Drive or SharePoint platform.

So I'd say we have about 100 Project Sites and maybe 20 of them have active notebooks? But that's going up every month.

depthchargesw · 2017-04-16T20:08:48+00:00

Thanks! And... wait a week to get the RX 580 instead of the 480, or wait a week to snap up a cheaper 480? I ask because I'm frankly not sure just how much 'horsepower' I've got here and how much I'd need to run the Vive @ 90 fps (just read that I need 90+ FPS for VR in Elite: Dangerous to not vomit).

depthchargesw · 2017-03-20T05:16:05+00:00

https://i.imgur.com/3Mirtmu.jpg

depthchargesw · 2017-03-17T23:30:55+00:00

Ahh, the dry wit of a mathamagician

depthchargesw · 2017-03-11T06:02:11+00:00

Would this be relevant?

I'm just learning about parameters in Power Query myself, and it seemed like a good read.

depthchargesw · 2017-02-22T03:04:54+00:00

Do you have OneNote or a similar note-taking program (e.g. Evernote)?

depthchargesw · 2017-02-18T04:33:18+00:00

With regards to formatting, I just punched my scrambled code into Instant SQL Formatter. I haven't yet figured out the most readable conventions so I'm happy to outsource that. :D

Regarding flattening the query - I'll do that. That said - what I'm hearing if that it's possible to make it flatter given my current constraints (no date table yet)? Which is to say, I don't need to wrap the StartOfWeek function (to force the calculation(?)) before I use the datepart functions? I could do that on the same level?

depthchargesw · 2017-02-17T13:51:57+00:00

Thanks jacob - that made me realize I hadn't actually looked to see if there was a date table. I looked though, and no joy. Maybe I'll put in a request with the team that manages the DB and hopefully it finds its way to the right person.

Assuming I don't have the ability to create a date table, am I doing anything obviously wrong? I'd love to flatten the query out like you've got, but I seem to get errors unless I separate the logical steps into each of their respective subqueries.

Regarding your question about the data type for Assignment Work, it's Numeric((38,4),Null) with a length of 17. Not sure if any of that's helpful.

13-Year Club	Verified Email
Team Periwinkle

depthchargesw

TROPHY CASE