992 reputation
39
bio website
location
age
visits member for 1 year, 11 months
seen Sep 26 at 19:50

Jul
1
awarded  Scholar
Jul
1
accepted MS SQL Server Cumulative Updates - Best Practices
Jun
30
comment MS SQL Server Cumulative Updates - Best Practices
Your experience is exactly what I'm afraid of. Thanks for sharing!
Jun
30
comment MS SQL Server Cumulative Updates - Best Practices
Thanks for the insight. Your opinion seems to mirror what I see elsewhere. We're a fairly small setup, so our QA cycle for most of our systems is essentially non-existant, but only a few of our systems are operations critical and those systems do have a QA process. We don't have the people to do it more rigorously, unfortunately, as we're a public entity with limited funding. We have large maintenance windows essentially daily, however, which does help a lot. It is very difficult to keep up on what issues the CU might resolve. The 2012 SP2 issue is actually what sparked the discussion.
Jun
30
awarded  Student
Jun
30
asked MS SQL Server Cumulative Updates - Best Practices
Jun
12
awarded  Enlightened
Jun
12
awarded  Nice Answer
May
20
comment SQL Server USE ignores IF block
On shrinking: Generally you're right, but there are legitimate situations. We have test databases on an application. We don't back up the test DBs (and don't want to) and the application has background transactions and never executes a CHECKPOINT. The vendor won't add it because production works flawlessly. Thus, with simple recovery the DB logs grow uncontrollably. We have a task which manually executes a CHECKPOINT and shrinks logs to 2 GB. It's rare for them to get that large (maybe once a quarter) so usually the task is just CHECKPOINTing to flush the logs, but it does happen.
May
7
answered Moved Model Database and now my SQL Server doesn't work
Apr
16
comment SQL Server 2005 database log size increasing drastically?
@veljasije Full backup doesn't shrink the log, but it does free pages in the existing log for reuse. If you're backing up your transaction logs consistently and see a consistent workload, your log files will not increase in size very often.
Nov
3
awarded  Yearling
Sep
12
awarded  Good Answer
Jul
30
comment Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?
@ypercube Yes, that's why RDBMSs have variable isolation levels and table hints. You can specify NOLOCK to read uncommitted data. This means you can direct the query planner to risk giving you unreliable data in exchange for not locking the database at all. MySQL appears to only support isolation levels, meaning your query would need to set the session isolation level. Probably what OP should actually be using.
Jul
30
revised Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?
added 49 characters in body
Apr
20
answered Relational vs Non-Relational Database for Events Database
Mar
4
comment Unable to restore dump file in mysql5.5
On line 1? Did you dump from a Linux system and are restoring to a Windows one? Do you need to convert line endings? I'm not sure if that matters, but "line 1" seems suspicious. Otherwise, what is on line 1?
Mar
2
revised Separated databases, separeted datas
added 334 characters in body
Mar
2
answered Separated databases, separeted datas
Feb
21
comment Tools and methodologies to keep to DBs aligned
Keep in mind that your options are going to be severely limited if you're using a custom, in-house database. Additionally, it's generally considered best practice for dev and prod to at least use the same systems. Having dev be Postgres but prod be custom-memory.db is a little awkward.