Reputation
247
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 12
Newest
 Announcer
Impact
~31k people reached

  • 0 posts edited
  • 0 helpful flags
  • 354 votes cast
Feb
20
awarded  Announcer
Sep
13
awarded  Popular Question
Apr
2
awarded  Popular Question
Jan
25
comment What are the arguments against or for putting application logic in the database layer?
@BlueRaja-DannyPflughoeft : Yes, I know, I've been watching it before even the private beta. However they dropped LINQ2SQL, did you know? They use Dapper now ;)
Aug
24
awarded  Yearling
Aug
17
accepted Speed up INSERTs
Aug
17
comment Direct the OUTPUT of an UPDATE statement to a local variable
Could someone with a reputation with 300 or more please add a tag called "OUTPUT" to this (if you agree, of course). Thanks!
Aug
17
awarded  Scholar
Aug
17
accepted Direct the OUTPUT of an UPDATE statement to a local variable
Aug
17
comment Direct the OUTPUT of an UPDATE statement to a local variable
I understand. However I can say SELECT @JNK = SomeColumn FROM SomeTable WHERE SomeOtherColumn = MatchesMultipleRows... So why wasn't this constraint applied here? Anyway thanks and I'll just declare a local table variable and be done with it. Life goes on. :)
Aug
17
asked Direct the OUTPUT of an UPDATE statement to a local variable
Apr
5
awarded  Civic Duty
Apr
4
comment What is the best practice for storing image varbinary(max) data in a database table?
Maybe it was auto-generated for you? (ALLOW_PAGE_LOCKS=ON)
Apr
4
comment How do you ORDER BY a parameter?
won't this solution (CASE-based) generate a poor execution plan too? Won't this CASE be evaluated for each row?
Mar
29
answered When should you denormalize?
Mar
20
comment How do you submit a List of items to a Stored Procedure to limit results?
@mrdenny : yeah and then some smart-donkey will devise escaping sequences and then I'll inherit their code base :(
Mar
20
comment Backing up SQL DB more frequently
Tens of thousands of dollars, running on Express? Interesting!
Mar
20
comment Speed up INSERTs
A follow-up is in order : setting up a RAMDISK where I placed TEMPDB and this test database increased the performance more than 10x :D
Mar
20
awarded  Critic
Mar
19
comment Testing stored procedure scalability
Why don't you write this app making use of my open source project Benchmark.NET and using a parallel benchmark?