111 reputation
5
bio website
location Medina, OH
age 39
visits member for 3 years, 7 months
seen Jul 9 at 17:10

Once upon a time I worked in a factory to pay for my CS degree. I was promoted several times into engineering and then into engineering management. To switch back to my goal of a computer programming became expensive - upper end engineering salary vs mid level programmer. So I wrote code to automate engineering processes ("Expert System" if you will). Then one day I made an executive decision and made the career change and have been happier but poorer since.

  • I am a parent
  • I am a husband
  • I am a software developer
  • I am a Freemason
  • I am a Scottish Rite Freemason
  • I am a Royal Arch Freemason
  • I am a Shriner
  • I am a member of the Order of the Eastern Star
  • I believe in the teachings of Jesus
  • I believe in one God
  • I do not know if your belief is right or wrong and I will never judge you

Jan
31
awarded  Student
Jan
31
comment Comparing Queries
Yes, this is the train of thought. I've always beat myself up over #1 but your addition and rational behind #2 is a good point. The developers do not have sysadmin, it's kind of hard for them to honestly check these things.
Jan
31
comment Comparing Queries
Thanks, I've changed the question such to describe that the account does not have sysadmin
Jan
31
revised Comparing Queries
added 93 characters in body
Jan
31
asked Comparing Queries
Jan
13
awarded  Editor
Jan
13
revised Performance on updating row
added 94 characters in body
Jan
13
comment Performance on updating row
Very interesting, I have to do some more research starting here: sqlservercentral.com/blogs/sqlinthewild/2011/06/21/…
Jan
13
awarded  Commentator
Jan
13
comment Performance on updating row
I'll post my results from the testing.
Jan
13
comment Performance on updating row
Thanks for the article. My excursion is to find out if update x set name = 'x' performs as well as update x set name = 'x', age = 1, ... ... zip = '44111' assuming that all of the other columns' (age ... ... zip) values do not really change. My assertion is that if the columns change or not, the performance is the same.
Jan
13
asked Performance on updating row
Dec
25
awarded  Supporter
Nov
4
comment Why is my SQL server using ~4 GBs of memory?
The funny thing is, people don't realize that it's SQL SEVER, not SQL Application. As a Server type of application, you should expect it to utilize all resources as it needs to.
Nov
4
comment Why is my SQL server using ~4 GBs of memory?
Because it can.
Jan
16
comment Relationships in a school database
Nice comment, however I'm not sure you've answered the question.
Aug
28
comment Sql Server - Best Practices for Growing Database Files
@RemusRusanu I resemble that DEV that you speak of. That's why we should use more virtual machines, we could just fire up another instance as a DEV machine.
Aug
28
comment Sql Server - Best Practices for Growing Database Files
I'm only playing the devil's advocate. However, HDs are cheap. Lost time in production for reconfiguration and performance loss is expensive.
Aug
28
comment Sql Server - Best Practices for Growing Database Files
@AaronBertrand you say "over-allocate" like it's a bad thing :)
Mar
6
comment Common Table Expression (CTE) benefits?
Profiler should tell you if it scans twice. IMHO, CTE's are awesome for recursion.