Mike Waddle (@sqlmike) profile picture

Mike Waddle

@sqlmike

Senior SQL Server/ MySQL DBA working in a large web environment.

 Seattle
Joined March 2009
  • Tweets233
  • Following199
  • Followers171
This is a good solution for data type checking in #mysql tinyurl.com/gl2m35o

Looking out for max values in integer-based columns in MySQL

Matthew Boehm shares a script he wrote in Go to check all integer-based columns in MySQL when a particular column counter was not incrementing.

percona.com
Don't wait until the middle of the night to find out your unsigned int column has a value of 4294967295. Run a monthly check of datatypes.
#ssis Ok to develop in 2008_r2 and run packages on 2005 engine?
2
#sqlhelp found the -4 in the blocking column listed in BOL. Session ID could not be determined. Search dm_exec_request
#sqlhelp What does -4 infer when in the blocked by column of sp_who2? Clearly there is no spid -4 so it must be system related.
1
The business never appreciates the delayed standby until someone updates every row in a table like they did last night.
@AdamMachanic sounds like a different issue. We could not connect with .net or perfmon because the remote registry would crash kb2159286
@AdamMachanic ran into an issue on windows 2008 where we could only see perfmon data local to the instance. There is a KB.
#sqlhelp I have some orphaned temp tables that do not correlate to any connections. Anyway to remove other than restarting SQL?
2
Replying to @_nickdyer
@NDyerAtXsigo we had many engineers onsite to facilitate and fix after fix came and went and we still had issues. We are now moving off.
Replying to @_nickdyer
@NDyerAtXsigo @rspruijt 2/2. My issue is with the technology not the company.They tried hard to make it work and someday they might #xsigo
1
Replying to @_nickdyer
@NDyerAtXsigo @rspruijt I'm speaking from my experience in a large varied environment that includes mysql, SQL server, and oracle. 1/2
Interesting deadlock message I came across today "Deadlock was due to false lock hash collision" Anyone see this before? #sqlhelp
1
PREEMPTIVE_OS_GETPROCADDRESS is a measure of xproc execution time. Had to go look in an old #SQLPASS session that Bob Ward gave to findthis
#sqlhelp any good references for UTF8 to UCS2/UTF16 conversion? Dev does not seem to think we need to convert prior to DB layer. I disagree
We are looking for a Senior SQL Server DBA to help support Disney, Espn, and ABC: http://tinyurl.com/4xsqc4w Appreciate a RT
2
Replying to @Sapient4Sec
@SPBrianCulver perfmon is your friend. If you think it's I/O prove it by showing the response times of the lun(s). #sqlhelp
If you create an executable litespeed backup you will need to stripe the backup to keep the files to 4GB or less if running < ver6
@AdamMachanic roughly 700 blockers. #sqlhelp
You can reduce the time to resync a subscriber by running distrib.exe locally on the subscriber. Comes in handy across datacenters.
Load more