441 reputation
1410
bio website
location Grand Rapids, MI
age 31
visits member for 3 years, 3 months
seen Sep 11 at 14:33

MCITP: Database Developer 2008

Sr. Database Developer

Hockey Goalie

Soccer Goalie


Aug
17
awarded  Yearling
Jul
31
comment Can I force a user to use WITH NOLOCK?
If you trust your users not to change it, there is a setting in SSMS which will set the Transaction Isolation Level for a connection - you could have them set that to READ UNCOMMITTED
May
24
awarded  Nice Answer
May
24
answered Query without having to specify table's schema
May
20
awarded  Constituent
May
20
awarded  Caucus
Sep
22
awarded  Custodian
Sep
22
reviewed Reviewed Reducing Errorlog file size
Aug
17
awarded  Yearling
Jun
29
awarded  Citizen Patrol
Jun
12
awarded  Editor
Jun
12
revised DB2 equivalent to T-SQL's REPLICATE?
Updating example to be more simple
Jun
12
answered DB2 equivalent to T-SQL's REPLICATE?
Jun
8
awarded  Caucus
Feb
17
awarded  Fanatic
Dec
9
awarded  Enthusiast
Nov
30
answered Can you prevent more than X number of rows being updated in SQL Server?
Nov
10
awarded  Supporter
Nov
10
awarded  Teacher
Nov
9
comment Unable to delete SQL Server 2008 R2 login
Not a problem, glad I could help.