Database Administrators Weekly Newsletter
Database Administrators Weekly Newsletter

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 can I check for stored procedure consistency across multiples servers

I've got a stored procedure on 10 distinct servers, how can I check across all servers for stored procedure consistency? I'm currently pulling the definition for each server manually, and comparing ...

sql-server stored-procedures  
asked by LemonCat 7 votes
answered by Craig Efrein 7 votes

Is this update, select combination query thread safe?

I have a table called seats, which has a schema like this id,taken For each user, I take a random untaken id and assign to that user, here for simplicity say, I make taken =1. The query I am ...

mysql sql locking update  
asked by Dude 6 votes
answered by RolandoMySQLDBA 3 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 5 votes
answered by Pavel Nefyodov 0 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

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 5 votes

Greatest hits from previous weeks:

How do I find PostgreSQL's data directory?

I forgot how I last time started postgres (it was months ago) and I don't remember where the data directory is located at. The postgres command seems to require to location. I'm on MacOsX if that ...

postgresql  
asked by randomguy 31 votes
answered by Peter Eisentraut 39 votes

What is the best way to reduce the size of ibdata in mysql?

I have some Production servers whose ibdata files increases in size day by day. It has already consumed 290GB of space. The tables in the servers are mostly InnoDB and there are high read and write ...

mysql innodb database-administration  
asked by Abdul Manaf 17 votes
answered by RolandoMySQLDBA 33 votes

Can you answer these?

Wich is the most efficient/easy way for end-user to get data from Analysis database?

I know that you can quey a cube by connecting from excel to Analysis database and using formulas like cubevalue() or cubemember(). I also know that after converting the power pivot to formulas you can ...

sql ssas excel olap  
asked by Pirvu Georgian 2 votes

Prevent truncate without denying ALTER permission

Is there a way to disallow users from truncating a table without denying ALTER permission on the table? Users should be able to maintain the standard ALTER permissions (adding columns to a table, ...

permissions alter-table truncate  
asked by westonsankey 1 vote

Scripting Local Policy Perform Volume Maintenance Tasks

I am working on an automated SQL 2012 install process on Windows 2012 R2 and have everything complete except for one task. My process launches secpol.msc but I am still required to drill in and ...

sql-server installation scripting  
asked by Scott S 2 votes
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