176 reputation
6
bio website bbvnsp.org
location California
age 43
visits member for 3 years, 11 months
seen Sep 3 at 6:28

Always on the look out to be:

  • more lazy
  • more clever
  • more resourceful

May
8
comment how to reduce transaction log size automatically?
Wonderfully simple. Set the offending database from full recovery to simple recovery (its a development database). performed the normal backup maintenance plan. Used Tasks-> Shink-> File. switch from Data to Log, and released the unused space.
Apr
11
comment Making a recursive CTE like query, but for many records
Is this a single rooted hierarchy? In other words, is there only one record with a null or empty ParentId?
May
17
awarded  Teacher
May
17
comment Cannot connect to MS SQL 2008 R2 by DBVisualizer. “Native SSPI library not loaded” error
DBVisualizer has a very nice diagramming graph layout for showing table references. IMHO better than SSMS at least for visualising
May
17
answered Cannot connect to MS SQL 2008 R2 by DBVisualizer. “Native SSPI library not loaded” error
Jan
28
awarded  Nice Question
Jan
20
comment When using an ORM, what are some things to watch out for in your database design
@John, yes Object Relational Mapping
Jan
11
awarded  Student
Jan
11
asked When using an ORM, what are some things to watch out for in your database design
Jan
4
awarded  Supporter
Jan
4
awarded  Precognitive
Jan
4
awarded  Autobiographer