130 reputation
6
bio website 2bsoftware.co.za
location South Africa
age 31
visits member for 1 year, 9 months
seen Mar 7 at 14:49

code monkey


Jun
19
awarded  Popular Question
Jan
11
comment Migrating SQL Server 2008 R2 to new server
I confirmed that the server names are the same (@@server and physical server). The new servers are on a completely different network, actually different country. So having the same name is not a problem. I already script the sql jobs as part of my daily backups, so I'll restore them from there. Thank you for warning me about those.
Jan
11
asked Migrating SQL Server 2008 R2 to new server
Jan
9
comment Which stored procedures are using a specifc index
excellent article. thank you for the info
Jan
9
comment Which stored procedures are using a specifc index
thank you, that helped a lot and explained the high usage
Jan
9
accepted Which stored procedures are using a specifc index
Jan
8
revised Which stored procedures are using a specifc index
added 85 characters in body
Jan
8
asked Which stored procedures are using a specifc index
Oct
10
revised Sql Server 2008 R2: Simple recovery model with transaction log backups
Final solution
Oct
10
awarded  Scholar
Oct
10
accepted Sql Server 2008 R2: Simple recovery model with transaction log backups
Oct
4
awarded  Supporter
Oct
4
comment Sql Server 2008 R2: Simple recovery model with transaction log backups
Thank you Jon, what you stated above is matching up with my findings/testing. Things are slowly coming together now.
Oct
3
awarded  Editor
Oct
3
revised Sql Server 2008 R2: Simple recovery model with transaction log backups
note to all the guys helping to provide answers.
Oct
2
awarded  Student
Oct
2
comment Sql Server 2008 R2: Simple recovery model with transaction log backups
Thank you Jaime. A whole bunch of lights went on this morning in my head. I got a bit of information overload from all the books and articles, but concepts are starting to come together now.
Oct
2
comment Sql Server 2008 R2: Simple recovery model with transaction log backups
very true - working on that. I'm a developer who accidentally fell into the role of DBA a short while ago, so busy testing and configuring everything correctly now (and building up knowledge at the same time). That's kinda how it goes with small companies :)
Oct
2
awarded  Autobiographer
Sep
28
asked Sql Server 2008 R2: Simple recovery model with transaction log backups