Reputation
1,116
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 10
Impact
~58k people reached

  • 0 posts edited
  • 0 helpful flags
  • 24 votes cast
Jul
15
comment SQL Server Slowdown?
These were my first thoughts as well. Tempdb contention and autogrowth events for the DB and transaction logs are known causes for slowdown.
Jun
30
comment A good dataset to experiment NoSQL databases
-1 While I don't think you're wrong, I'd argue that an RDBMS and NoSQL data store simply do different things, making this a pretty unfair comparison. Beating up on an NoSQL data store because it's a bad RDBMS is as silly as beating up on an RDBMS because it's a bad file system. And ultimately, you didn't really do anything to answer the question actually being asked.
Jun
11
answered Does SA account need to be called “SA” or can I rename it safely?
Jun
11
comment How to select first row from a join that returns multple rows on the primary key
@normandantzig Both are valid in SQL Server in most situations.
Jun
11
comment How to select first row from a join that returns multple rows on the primary key
@normandantzig That's an alias.
Jun
11
comment Changing sa password
What error are you getting when you try to log in? Has the server been configured for Windows Authentication only? Is the sa account disabled? Has the sa account been renamed and another account named sa been added? What do you get when you run these: SELECT CASE SERVERPROPERTY('IsIntegratedSecurityOnly') WHEN 1 THEN 'Windows Authentication' WHEN 0 THEN 'Windows and SQL Server Authentication' END as [Authentication Mode]; SELECT name, type_desc, is_disabled FROM sys.server_principals WHERE sid = 0x01; SELECT * FROM sys.syslogins WHERE sid = 0x01;
Apr
27
awarded  Peer Pressure
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