RussianGuyovich
Account Details
SteamID64 76561197977257109
SteamID3 [U:1:16991381]
SteamID32 STEAM_0:1:8495690
Country Scotland
Signed Up December 1, 2012
Last Posted November 7, 2024 at 10:02 AM
Posts 434 (0.1 per day)
Game Settings
In-game Sensitivity
Windows Sensitivity
Raw Input 0 
DPI
 
Resolution
 
Refresh Rate
 
Hardware Peripherals
Mouse  
Keyboard  
Mousepad  
Headphones  
Monitor  
1 ⋅⋅ 13 14 15 16 17 18 19 ⋅⋅ 29
#40 Anybody like heavy music? in Off Topic

https://www.youtube.com/watch?v=kUcFAA1dKPY

posted about 10 years ago
#118 Twitch now scanning VODs for copyrighted content in Off Topic

Donno like Jon boy. Video game nerds in general have shit music tastes but there's some good ones in the tf.tv Last.fm group.

posted about 10 years ago
#16 Mike left Epsilon ? in TF2 General Discussion
downpouri dont think people understand just how many big names/teams are leaving after i52
the hype will be there, but its gonna be a wasteland afterwards.

So more people will step up and the game goes on.

TF2 confirmed dead 4+ years and counting

posted about 10 years ago
#3 [Stream] Russian Guyovich in Requests

Cheers Slin

posted about 10 years ago
#1 [Stream] Russian Guyovich in Requests

Twitch: http://www.twitch.tv/russianguyovich
Steam: http://steamcommunity.com/id/russianguyovich/
ETF2L: http://etf2l.org/forum/user/43331/

Finally got some decent internet and sorted out my stream today! Got a couple VODs on there if you want to check the quality (ignore the testing ones). Scotland flag please :)

I've been playing competitive TF2 for about 3 and a half years and I'll mostly be streaming pubs, lobbies, 6v6 and Highlander as I'm too bad for MGE. I may also do the odd cast here and there too!

posted about 10 years ago
#24 T minus 1 month in LAN Discussion

Can't wait for the Twitch chat

Oh and the games too I guess

posted about 10 years ago
#5 ETF2L Highlander Nations Cup #3: Scotland vs USA in Events

VOD is here patty melt bros

https://www.youtube.com/watch?v=o5CNX9tC8Wk

posted about 10 years ago
#12 Best Antivirus? in Off Topic

I switched to Avast! from AVG a few years ago and not had any problems. You have to re-register every year for the free version but it takes about 30 seconds through the application. Just remember to add your steam folders to the exclusion list and enable silent mode - very unobtrusive.

posted about 10 years ago
#70 Family issues when playing in Off Topic

Thank fuck ETF2L isn't like this.

posted about 10 years ago
#16 Help with TF2 database design in TF2 General Discussion

The idea behind identity columns is the value is auto generated by the database engine as opposed to a naturally-defined key on one or multiple columns. While you usually don't specify the value of this identity column during an insert statement, there are ways to perform a manual insert assuming it's a unique value (treated as a constraint).

One big advantage with using identities for a surrogate key compared to natural keys (such as map name) is that your referential integrity will be intact compared to a scenario where the information used for your natural keys might have to be updated.

Even if you don't intend on using an identity column for referential integrity, they are good for large tables which would benefit from a clustered index being present to optimise query plans that would otherwise take too large a storage hit if creating a nonclustered index on one or several columns on that table.

Just to mention, I come from primarily a SQL Server background. The Oracle equivalent to identity columns are sequences.

posted about 10 years ago
#13 Help with TF2 database design in TF2 General Discussion
mansfield7Diagrams themselves aren't that important as long as you understand the concepts of normalization.

+1

Can't say I've ever created a UML diagram before I started developing which didn't end up binned because of some changes to the design made along the way. Just make sure you don't store duplicate, or even worse, conflicting information where it isn't needed. Consider using identity columns where a primary key isn't easily defined (i.e. unique constraint isn't possible) and use them as foreign keys in your dependant tables.

posted about 10 years ago
#1668 Frag Clips Thread in Videos

http://www.youtube.com/watch?v=ym_cT2WW4HU&hd=1

posted about 10 years ago
#1437 Frag Clips Thread in Videos

http://www.youtube.com/watch?v=Hqcx02AV5Dc&hd=1

posted about 10 years ago
#3 UGC HL Season 12 Euro Plat Week 1: Bote Salva Vidas vs. Team Nein! in Events

Yeah, seems like an odd choice considering Nein beat them 3-0 yesterday

http://logs.tf/171461

posted about 10 years ago
#13 THE AWESOME CUP - JAN 26TH - 5PMUK/6PMCET START! in TF2 General Discussion

This starts in 5 hours time!

posted about 10 years ago
1 ⋅⋅ 13 14 15 16 17 18 19 ⋅⋅ 29