Reputation
3,307
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 5 24
Newest
 Caucus
Impact
~295k people reached

Jul
27
awarded  Caucus
Jul
24
comment SQL Server 2014 schema changes in 24/7 multi user environment
@Kin do you have any written info on your implementation of Green/Blue deployments per chance? I've been looking into that and it could be very useful here and elsewhere.
Jul
24
revised microsoft sql server schema
added 175 characters in body
Jul
23
answered microsoft sql server schema
Jul
21
comment How to name a new table storing location at which transaction occurred
Well put @a_horse_with_no_name. Thanks. Good luck BoatCode, it sounds like you're on the right track.
Jul
21
comment ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT
Well put Delux. TY.
Jul
21
awarded  Enlightened
Jul
21
awarded  Nice Answer
Jul
20
revised How to name a new table storing location at which transaction occurred
added 58 characters in body
Jul
20
comment How to name a new table storing location at which transaction occurred
Ah yes, this is hotly debated. Camel Case and Pascal Casing often draw blood between devs. I'll stay neutral for this one and modify it :P
Jul
20
answered How to name a new table storing location at which transaction occurred
Jul
17
answered Are there security vunerabilites/implications with SQL Mail, currently using SQL Server 2008 R2
Jul
16
comment Restore SQL Server 2008 database onto SQL Server 2014?
Prior to checking compatibility level which will take effect after the restore, please check to see if your backup script includes 'WITH FORMAT' and let us know. Thanks.
Jul
13
comment SOS_Scheduler_Yield wait type
Quick Question, is that particular process still running where it's trying to insert into the table or is it just the recorded wait stats post action? I am assuming it is the wait stats after it finished, is that correct?
Jul
13
answered SOS_Scheduler_Yield wait type
Jul
9
comment SQL Server process only using half of the memory on host
Are you sure it needs the additional memory though? Have you tried forcing major table scans or loading up the execution cache?
Jul
9
comment SQL Server process only using half of the memory on host
If you're not locking pages in memory, does it actually need the data? Is the OS running something that is stealing data? Is this on a hypervisor with a balloon driver or something of the sort?
Jul
9
comment How to manage RAM consumption in MongoDB?
What are you storing in your index that is bigger than 27x bigger than your base document? Your base document is everything. An index will typically have a subset of the fields, or all the fields but sorted differently so typically worst case scenario it will be equal size. I don't know of any 'computed index columns' in mongo. Maybe you're looking at all document indexes. Show us a sample output of your base document and indexing. Do your indexes contain each data field from the base document 27 times or is there something odd that is going on?
Jul
9
revised How to manage RAM consumption in MongoDB?
added 39 characters in body
Jul
9
answered How to manage RAM consumption in MongoDB?