Reputation
1,032
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 9
Newest
 Yearling
Impact
~48k people reached

  • 0 posts edited
  • 0 helpful flags
  • 20 votes cast
Mar
23
comment High Availability using SQL Server 2012 requires how many licenses
The only person who can answer this is your MS Licensing rep.
Jan
22
comment Metadata Headache
You should be able pick reasonable sizes for the fields. Metadata scanning should only throw an error very rarely. Your data is only going to vary so much or you wouldn't use varchar in the first place. MySQL can't store War and Peace in a single varchar field. It's limited to 65535 bytes per record unless they're using blobs, but blobs wouldn't be as much of a SSIS problem. If it's really that big of a problem that you can't ever fail or you can't ever wait to fix it, use CAST(Field AS VARCHAR(max)). Your performance will suffer, but you don't have a lot of choice given your requirements.
Jan
22
comment Metadata Headache
What if you use a CAST(LEFT(Field,500) AS VARCHAR(500)) in your view on SQL Server to lock the metadata, and then compare your table metadata in the SSIS package by comparing INFORMATION_SCHEMA.COLUMNS from SQL Server and MySQL for your local view and the remote table to detect truncation?
Dec
27
comment MySQL slave stuck at 'System lock' most of the time, high CPU usage
Possible bug with 5.6. Also here‌​.
Nov
3
awarded  Yearling
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