Database Administrators Weekly Newsletter - Friday, November 28, 2014

Top new questions this week: Professor told us to store serialized Java objects as blobs instead of defining relational tables Instead of actually defining a tables with the correct attributes, my professor told us we could map objects to ids like this: id (int) | Serialized Object (blob) 1 10010110110 ... database-design   asked by Tyler Davis 12 votes answered by fdreger 26 votes How to recursively find gaps where 90 days passed, between rows This is a kind of trivial task in my C# homeworld, but I don't yet make it in SQL and would prefer to solve it set-based (without cursors). A resultset should come from a query like this. SELECT ... sql-server sql sql-server-2014 recursive-query   asked by Independent 8 votes answered by Paul White 7 votes AlwaysOn Availability Group error after Windows Update in environment without a failover cluster Our SQL Server service was down this morning which brought down some of our websites. When I went to check the Windows Event Viewer I saw the following errors: Script level upgrade for database ... high-availability sql-server-2012   asked by skeletank 4 votes DBCC DBINFO showing wrong information Though DBCC DBINFO() is undocumented, but we all know that dbi_crdate: Database creation datatime dbi_dbccLastKnownGood: the completion time of the last 'clean' run of DBCC CHECKDB For one ... sql-server-2008-r2 dbcc   asked by aasim.abdullah 4 votes answered by Brent Ozar 9 votes Discrepancy between system catalog view and sp_change_users_login? I want to check for orphaned users on a database. To that end, I use the following query on my SQL Server 2005 instance to get all users and their accompanying logins for a specific database (say ... sql-server-2005 security   asked by Josien 3 votes answered by aasim.abdullah 3 votes dbcc memorystatus - buffer pool target on VM higher than max memory I'm doing some digging into potential memory/configuration problems on a sql server 2012 SP2. I stumbled upon something that seems a bit strange in the performance counters as well as the dbcc ... sql-server sql-server-2012 memory bufferpool   asked by Hal 3 votes answered by Shanky 1 vote One foreign key for two columns I have two tables, Results and Teams Teams has the following columns: team_id team_name Results has the following columns: match_id home_team (foreign key references teams [team_id]) away_team ... mysql sql foreign-key   asked by serg_ka 3 votes answered by ypercube 9 votes Greatest hits from previous weeks: What's the difference between a temp table and table variable in SQL Server? This seems to be an area with quite a few myths and conflicting views. So what is the difference between a table variable and a local temporary table in SQL Server? sql-server sql t-sql temp-tables   asked by Martin Smith 206 votes answered by Martin Smith 343 votes MySQL DB import/export command line in Windows How to export / import a database in MySQL through the command line? MySQL system configuration, WampServer server installed. OS: Windows The advice for my local host, not an live hosting... mysql mysqldump   asked by Bharanikumar 24 votes answered by matei 30 votes Can you answer these? select on table slows done during update on same table I have a weird problem with mysql. During a transaction which runs from 10-30s around 270 statements are performed, some of which are updating and inserting a few rows on a table. If a select is ... mysql query-performance   asked by greenone83 2 votes How do I recover from MySQL InnoDB table/index corruption? While trying to upgrade a database (in place) I got the following error. The server starts up and everything seems to be fine, except that the table mentioned in the message is no longer accessible. ... innodb index mysql-5.5 corruption   asked by Wodin 1 vote PostgreSQL 9.4 analysis, performance of normal column, indexed column and jsonb key If I have a table containing: CREATE TABLE test( id SERIAL PRIMARY KEY, name VARCHAR(200), age INT, data JSONB ); and data column populated with {"name": xxx, "age": yyy}, sometimes ... performance index json postgresql-9.4   asked by Kokizzu 1 vote

Subscribe to more Stack Exchange newsletters Unsubscribe from this newsletter or change your email preferences by visiting your subscriptions page on stackexchange.com. Questions? Comments? Let us know on our feedback site. If you no longer want to receive mail from Stack Exchange, unsubscribe from all stackexchange.com emails. Stack Exchange, Inc. 110 William St, 28th Floor, NY NY 10038 <3