Monday, September 16, 2013

[SQL Server] Update Table - By Looping Through Field Name

[SQL Server] Update Table - By Looping Through Field Name

Update Table - By Looping Through Field Name

Posted: 15 Sep 2013 09:50 PM PDT

HI,Is it possible to achieve the following ;I have a table with say ... 200 Fields and I want to check each field for a value and possibly update if a match is found.something like...FOR EACH "FieldWithinMyTable" as FieldChecker IF FieldChecker = 'FoundIt' then update FieldChecker with new fielddata ENDIFNEXT

Log file backup growth (how long's a piece of string...)

Posted: 15 Sep 2013 10:13 PM PDT

If your log backup file was as follows:2,176 KB at 10 this morning10,617 KB at 11 this morning18,615 KB at 12 middaywould that seem like an unusual amount of growth to you? (I know approx 8 MB an hour might not seem like a lot, and it's early days yet, but I wondered what others thought.)It has just been switched to Full recovery model, with the log being backed up every hour. Do the figures above suggest that it needs to be backed up much more frequently than that? (The database is about 58 GB.) (2008 R2 Standard Edition)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog