Reputation
727
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 10
Newest
 Caucus
Impact
~88k people reached

  • 0 posts edited
  • 0 helpful flags
  • 70 votes cast
Sep
20
comment Can I force a user to use WITH NOLOCK?
I didn't said that. Who said that was Aaron.
Aug
21
comment Is there a DB that will allow the same field name with different cases?
@GreenstoneWalker: it make painkillers' vendors richer.
Aug
8
comment Can I force a user to use WITH NOLOCK?
@AaronBertrand: wow Aaron, you made the hard job for me. Tks. Paul, give up on that. Exist rules I don't like on SO/SE network? Yes. But I can live with it.
Aug
8
revised Can I force a user to use WITH NOLOCK?
new information
Aug
7
comment Can I force a user to use WITH NOLOCK?
@Paul for the use in SO and StackExchange network, "thankyou" is classified as a greeting.
Aug
7
comment Can I force a user to use WITH NOLOCK?
The only other methodology is in Aaron's answer about using SP's and/or views.
Aug
7
revised Can I force a user to use WITH NOLOCK?
add little explanation on read committed snapshot
Aug
3
awarded  Yearling
Aug
2
revised Can I force a user to use WITH NOLOCK?
deleted 812 characters in body
Aug
2
answered Can I force a user to use WITH NOLOCK?
Jul
30
comment SQL Server Tuning a table for massive inserts
ALTER SCHEMA...TRANSFER ? Never heard of it. Interesting...
Jul
8
answered How to undo every change made to a database in a controlled environment?
Jun
17
awarded  Necromancer
May
24
answered Updating a table with millions of records, its been 4 days
May
7
comment pros/cons of different ways to store whether a record is one of two options?
Good catch! I never thought of that hypothesis on the question, but it's really the right answer since all the bases are covered up.
Feb
21
answered Manually set log file size after shrink SQL Server 2008 R2
Feb
21
comment Manually set log file size after shrink SQL Server 2008 R2
@AaronBertrand - I agree with you in this. Log backup is nice for those who want almost 0 lost data. In this case, appear that some never changed the default recovery mode of model database........
Nov
30
comment We are running database maintenace with indexing the system, indexing fails due to locking?
@Laurence: maybe they does not have Enterprise Edition?
Oct
31
revised Query performance of a NULL vs an empty ('') varchar in SQL Server 2012
suggestions to solve the problem added
Oct
31
answered Query performance of a NULL vs an empty ('') varchar in SQL Server 2012