Unanswered Questions
10
votes
1answer
143 views
Recalculate Time Dimension in BIDS
I'm using BIDS to create a cube in SSAS 2008 r2.
I used the wizard to create a time dimension. Part of that configuration is selecting a date range.
After creation, I realized that I needed a wider ...
10
votes
3answers
679 views
SQL Server 2008 Full Text Index Never Seems to Complete
Our website has a SQL Server 2008 R2 Express Edition database with full-text indexing for our website search. Each time a new record is added or updated in one of the indexed tables, the indexing ...
9
votes
1answer
149 views
Treating certain Arabic characters as identical
In Arabic we have characters like ا (alef) and أ (alef with hamza).
Users write them interchangeably and we want to search them interchangeably. SQL Server treats them as separate characters. How ...
9
votes
0answers
259 views
Get and Put performance testing on Google BigTables (and other integrated DBs)
What are some effective ways to perform programmatic performance testing on database operations, especially in environments where the databases themselves do not offer dedicated tools?
For example, ...
8
votes
1answer
129 views
Disk file effects of delete and vacuum
I have a very frequently updated table with 240 million rows (and growing). Every three hours 1.5 million rows are inserted and 1.5 million are deleted. When I moved the cluster to a SSD this bulk ...
7
votes
1answer
105 views
USING construct in JOIN clause can introduce optimization barriers in certain cases?
It was brought to my attention that the USING construct (instead of ON) in the FROM clause of SELECT queries might introduce optimization barriers in certain cases.
I mean this key word:
SELECT *
...
7
votes
0answers
157 views
Sql Anywhere 11: Restoring incremental backup failure
The idea is to create remote incremental backups after a full backup and then restore in the event of a failure and bring up another machine with as close to real time backups as possible with SQL ...
6
votes
1answer
205 views
SQL 2008 R2 - Odd timeout issues
I'm having some recent timeout issues in our SQL 2008 R2 server. This started occurring late last week and has since somewhat improved.
Issues:
When using SSMS and right clicking over a ...
6
votes
0answers
45 views
Scalar function used in calculated column, what's the cleanest way to update the function?
I want to update a scalar function in our database. This function is used for several calculated columns in a key table so I get a dependency error if I try to update it. I can explicitly remove the ...
5
votes
0answers
20 views
MongoDB Replica Set SECONDARY Stuck in `ROLLBACK` State
During a recent automated update of our mongodb PRIMARY, when the PRIMARY stepped down it permanently went into a ROLLBACK state.
After several hours in the ROLLBACK state, there was still no ...
5
votes
1answer
43 views
Mirror log empty on primary but fine on the mirror
We have dozens of principle servers and corresponding mirrors, most are working fine, however, 1 of them is acting strange. Specifically, the usp_dbmmonitorresults proc returns all columns as NULL for ...
5
votes
1answer
223 views
How do I resolve this data source connection issue with Cognos?
We have (fairly recently) installed IBM's Cognos 10 as our business intelligence reporting tool. Most of the databases that we report over are DB2 9.7 LUW Enterprise Edition. We installed the DB2 ...
5
votes
1answer
119 views
bcp database migration
I want one server to migrate the database to another server. On another server database already exists, then ist all the tables, but they are empty and I want to fill. For the filling, I want to use ...
5
votes
1answer
40 views
Error handling in container procedures
I'm aware of and use the techniques in this question.
In my environment we have a lot of container procedures that call subprocedures, that may call other procedures, ad infinitum.
For me ...
5
votes
2answers
202 views
Simple SQL queries not finishing
I don't quite know how to formulate the question because we don't know much yet, but I would like to ask sooner than later because this looks like something that should not be neglected.
This week we ...
