Unanswered Questions
18
votes
1answer
920 views
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:
...
15
votes
0answers
3k views
MySQL 5.1.66 SSL connection error ERROR 2026 (HY000)
UPDATE2
Using WireShark I found out the problem string (I hope I did):
28 | 9.582638 | 192.168.18.128 | 192.168.18.129 | MySQL Response Error 1043
And the error is (according to docs):
Error: ...
8
votes
0answers
283 views
Storing and querying rolling data in PostgreSQL
I have a large quantity of weather model data being put into a PostgreSQL database. The machine has 8 cores and 16 GB of RAM. I'm running PostgreSQL 9.3 with PostGIS 2.1. Each table will have a ...
7
votes
2answers
1k views
Migrate heroku database to Amazon RDS with minimum downtime
I have a heroku postgres database and want to migrate it to Amazon RDS to save cost. What's a way to do so with minimum downtime? Usually this involves replicating database in real time and then ...
7
votes
1answer
379 views
Designing Simple Schema for Disaggregation of Demand Forecast
I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case:
I have a parent-child hierarchy of products (example, Raw ...
6
votes
0answers
125 views
How to handle bad query plan caused by exact equality on range type?
I'm performing an update where I require an exact equality on a tstzrange variable. ~1M rows are modified, and the query takes ~13 minutes. The result of EXPLAIN ANALYZE can be seen here, and the ...
6
votes
0answers
352 views
Fast hamming distance queries in postgres
I have a large database (16M rows) containing perceptual hashes of images.
I'd like to be able to search for rows by hamming distance in a reasonable timeframe.
Currently, as far as I properly ...
6
votes
0answers
159 views
Modification to GEQO (Genetic Query Optimization) of PostgreSQL
I need to implement a functionality that is in line with the GEQO functionality of PostgreSQL. I understand that GEQO approach is to encode query plans as integer strings and GEQO generates these ...
6
votes
0answers
169 views
9i streams capture doesn't evaluate rules
I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
6
votes
1answer
1k views
SQL-08S01 error in FreeTDS/Azure when executing stored proc for a few minutes from Linux (but not from Windows)
I get this error on Linux (Ubuntu and CentOS) when executing a stored proc from Perl/DBI/ODBC/FreeTDS to SQL Azure:
[unixODBC][FreeTDS][SQL Server]Read from the server failed (SQL-08S01)
I don't ...
5
votes
0answers
198 views
Trace Flag 1222 Not Working?
I have a customer site with two similarly configured 2008r2 SQL Servers "A" and "C". On both servers the trace flags 1204 and 1222 are enabled and DBCC tracestatus shows the following on both ...
5
votes
0answers
492 views
SQL Server not starting at Windows startup but starts manually
My SQL Server instance's (SQL Server 2008 R2 Express) service has Startup Type = Automatic. The past couple of times I've restarted my computer the service has failed to start on its own, but it ...
5
votes
0answers
309 views
Excessive compile blocking on sp_procedure_params_90_rowset
A resurgence of this question Blocked-process-report: what is this waitresource "OBJECT: 32767:124607697:0 [COMPILE] on MSDN:
I have caught these statements in Profiler. They all have durations over ...
5
votes
1answer
2k views
Error 18456 error severity 14 state 5 SQL Server 2012 SCCM2012 SP1
We had a primary site for SCCM 2012 SP1 running fine. I then installed CAS for SCCM on another server. The prerequisites required me to change the collation on the existing server. I did this and ran ...
5
votes
0answers
306 views
SQL Server Sproc calls from IBM Cast Iron orchestration with XML payload fail
I'm hoping that someone on this forum may have experience with an IBM appliance, Cast Iron (Websphere), and how it interacts with SQL Server. I know very little about the Cast Iron appliance, and its ...
