database-administration

相关标签：javascript jquery android 多少钱 iPhone

best way for handling identity columns in replication

I need to implement Merge replication with a scenario like a Central Main server, 4 Office Servers located at each country office, and each machine having sql exp开发者_如何学JAVAress insatalled on th[详细]

2023-01-26 05:38 分类：问答
Replication - Explicit value must be specified for identity column in table

I\'m using Merge Replication. The Identity range management is AUTOMATIC I HAVE A TRIGGER ON COMPANIES TABLE WHICH INSERTS ROWS IN SERIALNUMBERSCHEME TABLE which has documentID as identity column[详细]

2023-01-25 22:41 分类：问答
Notify Operator if ANY step in job fails

Can I (How do I) configure Sql Server 2008 to notify an operator if any step in the Job fails? I have a Sql Server job with several steps to update data from multiple different sources, followed by o[详细]

2023-01-19 03:42 分类：问答
Scanning a mysql table from the bottom

When i run a mysql select statement, it 开发者_如何学运维takes very long because i have already previously deleted a very large number of rows.[详细]

2022-12-31 09:38 分类：问答
Very large database, very small portion most being retrieved in real time

I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would[详细]

2022-12-30 20:38 分类：问答
Frontend tool to manage H2 database [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]

2022-12-29 14:49 分类：问答
SQL Server - Detecting non-indexed columns but used in WHERE clause

How to detect a column included in WHERE clause but used in indexed? Little Background: Until the time the table has few 开发者_JAVA百科number of records things will be okay, once it started having[详细]

2022-12-25 08:14 分类：问答
What administration tasks (if any) should I perform on a sqlite database?

I\'m deploying a client application to several thousand windows machines. Each machine will use a sqlite database as a local datastore, ultimately开发者_运维知识库 writing data to a remote server. So[详细]

2022-12-20 01:24 分类：问答
how to drop database

i used the following sytanx drop database filmo; and got the following error: ERROR 1010 (HY000): Error dropping database (can\'t开发者_如何学JAVA rmdir \'./filmo/\', errno: 17)[详细]

2022-12-15 22:26 分类：问答