Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
5
Newest
 Student
Impact
~240 people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Mar
26
comment Processors: E5-4620 v2 vs E5-2620 v3
I am asking HOW to choose, please see the last line. I created a Meta question regarding this question to get it edited and reopened.
Mar
23
asked Processors: E5-4620 v2 vs E5-2620 v3
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.