Database Administrators Weekly Newsletter - Friday, August 29, 2014

Top new questions this week: How to calculate/store Top 10 in a tabular model? We have recently created an SSAS tabular model so our users can access it via PowerView. We have a measure on one of our fact tables to get the TotalActiveItems using a formula: … ssas tabular-model   asked by bluefeet 12 votes Why are simple SELECTs on InnoDB 100x slower than on MyISAM? I have quite an annoying problem. I want to use INNODB as my main database engine and give up on MyISAM as I need the former for using galera-cluster for redundancy. I copied (description follows) … mysql sql performance innodb myisam   asked by jollyroger 6 votes answered by jollyroger 1 vote Avamar SQL Agent running against live SQL Server databases We use a large company as our service provider. The tech people from that service company are pushing very hard to install something called the Avamar SQL Agent which purportedly will be used to … sql-server backup transaction-log   asked by Bill 5 votes answered by Shanky 3 votes Why does my query end up with two seeks instead of one and how do I fix that? I have these two tables: CREATE TABLE [TaskItems] ( [ItemId] UNIQUEIDENTIFIER NOT NULL UNIQUE PRIMARY KEY, [LastOperationTime] DATETIME NULL DEFAULT GETUTCDATE(), [OwnerId] … sql-server performance execution-plan sql-azure   asked by sharptooth 3 votes answered by Rob Farley 2 votes How to benchmark Microsoft SQL Server in my company we have multiple virtual machines hosting SQL Server 2008 R2 and some of these machines perform differently than others, some because of very busy Vmware hosts some because of slower … sql-server   asked by Davide Piras 3 votes answered by mskinner 1 vote How to enforce the structural constraints of rectangularly arrayed data? (I'm particularly interested in answers that view the question below as a special case of the question: how should a RDBMS enforce structural constraints that are more specific than "one-to-many" and … database-design schema constraint   asked by kjo 3 votes answered by Stoleg 2 votes How to find XXth day of previous month in SQL server? I have 2 parameters, an input date (DATETIME) input day of month (TINYINT) If I enter 11 MAR 2014 as the DATETIME and 26 as the input day of month, I would like to select 26 FEB 2014 as the … sql-server-2008-r2 datetime   asked by JohnLinux 3 votes answered by Aaron Bertrand 7 votes Greatest hits from previous weeks: Import a Oracle DMP file into a Fresh install of oracle A client sent us a oracle database we need to test against. We don't use oracle or have any oracle expertise in house. We need to setup the database so we can connect to it and debug a problem. I … oracle import   asked by James 13 votes answered by Andrew 13 votes Sql Server database in recovery: How to stop, Take ofline or delete? I have a development database which has entered recovery mode on restart, and has been recovering for the last hour or so. I need to either stop the recovery, or kill it in some way. I dont care one … sql sql-server sql-server-2005   asked by CrapHands 13 votes answered by gbn 19 votes Can you answer these? 500GB Data Warehouse - how to split it into FileGroups? OK, so I have: 500 GB DW 5 GB in smaller DBs 220 GB TempDB 350 GB in Log files. My machine is Fujitsu Primergy 64 cores (with HT) and 192 GB RAM. I have several IO locations: 540 GB in-server … sql-server data-warehouse filegroups   asked by barthoos 1 vote Many small queries or one single query This is not exactly a question, more of a survey. Here at BlackBean we have a time series aggregation and analysis platform built on top of MySQL, where each client have your own database, and each … mysql   asked by Bruno Magalhães 1 vote Stack Depth Limit Exceeded (After delete trigger) CREATE TABLE parent ( parent_id VARCHAR(30) PRIMARY KEY ); CREATE TABLE child ( parent_id VARCHAR(30) REFERENCES parent ON DELETE CASCADE, child_id VARCHAR(30) PRIMARY KEY ); CREATE OR … postgresql   asked by samol 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