7,044 reputation
31640
bio website
location Berlin, Germany
age 39
visits member for 2 years, 10 months
seen 53 mins ago

Feb
14
revised Creating CDC system table on SQL Server 2008
edited tags
Feb
14
comment Safe way to stop/abort REINDEX
I would not expect any problem stopping a REINDEX. Once it started, the index would be unusable until REINDEX successfully would finish. But I'm concerned more with why do you need reindexing? Anyhow, dropping the index and building it with CREATE INDEX CONCURRENTLY wouldn't block the normal operation of your system.
Feb
14
revised Safe way to stop/abort REINDEX
edited tags
Feb
14
comment I have table with 17 Indexes if i add 1 more index for search in two columns
What to do? First, include here the following: CREATE TABLE statement, index definitions, typical queries you try to accelerate with all those indexes, probably coupled with index usage statistics to see whether all those make any sense. All these are needed to assess whether you need this many indexes ('yes' is answer only in rare cases) and then being able to determine which ones to drop. Anyway, 'slow' means what exactly? An example would be useful here again.
Feb
13
comment Permission Denied Copy
Well, what is your file name after all? This latter ls output refers to what? What do you get running ls -ld /Users/Shared/folder?
Feb
13
reviewed Close 32-bit ODBC driver on 64-bit SQL Server
Feb
13
awarded  Custodian
Feb
13
reviewed Leave Closed NOSQL Database for
Feb
12
revised Moving data between Oracle and PostgreSQL
edited tags; edited title
Feb
12
revised Can a table belong to multiple tablespaces?
deleted 1 characters in body; edited title
Feb
12
comment Indexing is not working
How many rows are there in the table? It looks like the selectivity of the multi-column index is too low.
Feb
12
comment Open source alternative to SQLMaestro for PostgreSQL
Which one have you tried/chosen?
Feb
11
reviewed Close Continuing failovers on production server
Feb
11
reviewed Close SQL Server Restore a SINGLE table from a backup
Feb
6
comment Granting access to all tables for a user
@PlaidFan Thanks for the edit!
Feb
6
reviewed Approve Granting access to all tables for a user
Feb
6
comment Using data from other database to populate a new database
Instead of using <br> tags, you should use the {} button over the textarea (which basically inserts four spaces before each row).
Feb
6
revised Using data from other database to populate a new database
edited body
Feb
6
reviewed Approve Oracle Table Design, Storing Small Values
Feb
6
reviewed Looks OK SQLQueryTableData-Important