5
votes
2answers
680 views

Release SQL Server Memory usage

How can release memory usage of sql server by command. my system have 16GB RAM, but when get huge query by sql server, memory usage become full. if I restart SQL Server service memory usage become ...
3
votes
1answer
619 views

Service Broker Procedure that will be used by multiple initiators to begin dialog conversation.. how to pass a parameter into it

The standard format for beginning a dialog is like this: Declare @dialog_handle UNIQUEIDENTIFIER BEGIN DIALOG CONVERSATION @dialog_handle FROM SERVICE initiator_1 TO SERVICE 'target_1' ON ...
6
votes
2answers
7k views

How to get last identity row Inserted when using instead of trigger

When I insert into tables using instead of triggers, @@Identity, IDENT_CURRENT('Table') and SCOPE_IDENTITY() return null. How I can get the last identity of inserted row?
1
vote
1answer
607 views

How to sync a table between oracle and sybase

I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source) I cannot truncate and populate the table in Sybase because it is used by an application, I ...
2
votes
2answers
122 views

Ways to stop access to a SQL express database

I have a SQL express database and was wondering what options I have for securing it? More specifically it is a replicated database using merge replication. I want to stop a user with a replicated ...
2
votes
1answer
472 views

How does merge replication work with SQL Server CE

I have been trying out merge replication with SQL Server databases, and was just wondering how merge replication works on SQL Server CE? For instance merge replication with SQL Server databases ...
3
votes
1answer
2k views

How does performance of SQL Server CE and SQL Server Express compare?

We have an application that runs on netbooks. It currently uses a SQL Server CE 3.5 database, and we are thinking of upgrading to SQL Server Express. Just wonder if there are any benchmarks to ...
4
votes
2answers
591 views

Change Location of VALIDATE RECOVERY FILES work area

Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space? When I run the command in RMAN, it fails with the following error stack: ...
8
votes
3answers
529 views

What is retrieved from disk during a query?

Fairly simple question, probably answered somewhere, but I can't seem to form the right search question for Google... Do the number of columns in a particular table affect the performance of a query, ...
2
votes
1answer
28 views

Get the rows where id_user_rq exists in id_user_ap and viceversa

I have this table structure: http://www.dropmocks.com/mBjNvF and need to get the id_user_rq if not exists in id_user_ap as the title said. I need to get the rows where id_user_rq = 1 and id_user_ap = ...
1
vote
0answers
299 views

Populate database column with drop-down menu item

I'm quite new to Apex and Oracle in general, but I would like to know how to populate a database column with the data from the drop-down list Currently I'm not getting further than simply creating ...
7
votes
1answer
779 views

Transactional replication from SQL Server 2000 to 2008

I have legacy databases on two SQL Server 2000 servers that I am trying to replicate to a SQL Server 2008 R2 database using transactional replication. The 2008 server is not in the same LAN, so I am ...
6
votes
1answer
623 views

what is mongodb telling me when it logs an update?

After several minutes of a large program that pushes a lot of data into mongo, my log starts to show a message for (I guess) each update. This seems awfully noisy, is there some special reason it ...
4
votes
2answers
113 views

Mirroring and Buffer Page Write/s

Is the "Buffer Manager: Page writes/sec" (* 8 KBytes) a good indicator of how much bandwidth will be used to replicate all databases via Availability Groups? If not, why are these not equivalent? Is ...
3
votes
1answer
529 views

Could a large log file be the reason cron job keeps dying?

The log is 15 Gigabytes. I guess I have to back it up and delete. I have enough hard disc space, but did not realize log was so large. And overnight cron jobs suddenly started to die in the middle.
2
votes
1answer
106 views

Get the id_user_app if not exists in id_user_rq

I'm building a application and have this table for users relationships. I need to build some queries like for example: Who invited me as a friend? Who I invited to be my friend? Who I accept as ...
4
votes
2answers
1k views

replication monitor: why is current average performance poor?

I am a replication rookie. We have a very simple transactional replication set up in SQL Server. I am looking at the Replication Monitor on the subscriber and one of my subscriptions show Poor ...
5
votes
2answers
141 views

best way to consolidate data

I have three select statements which have the bulk of their columns which are the same except a few. So here is an example select *orgid='0' ,'P' as OrgType* , Lang ,*cast(Null as varchar) as ...
6
votes
2answers
866 views

MySQL Permissions Necessary To Reset Password

On my team there is a desire for some users to periodically update their MySQL password. Our MySQL server is shared between a few projects (and certain users are assigned to certain projects). If I'm ...
3
votes
1answer
153 views

Cannot retrieve values from LEFT JOIN (2 tables)

Here it is my query: $query_products = " SELECT p.Id , p.product_sku , p.product_name , p.hide_product , p.new_style_image , p.ext , p.product_thumb_image , ...
4
votes
2answers
3k views

Using the correct database when calling a system stored procedure in SQL Server 2008

I think there's something I'm missing when it comes to which database is being used when running a custom system stored procedure. I have the following in my stored procedure (edited for brevity): ...
5
votes
1answer
6k views

sql server , set N prefix as unicode for all queries by default

Is there any option in ms sql server which use N prefix for my database. There are many query in my application which non of them use N prefix for nvarchar fields , and now I have to set N for all of ...
4
votes
2answers
327 views

How to speed up this simple mysql query?

The query is simple: SELECT TB.ID, TB.Latitude, TB.Longitude, ...
2
votes
1answer
18k views

How to import a.csv file into a postgresql database using \copy?

I am trying to import a .csv file into a postgresql database. I am using pgadmin III for that on a win7 machine. My query looks like that: \COPY pop_grid(GRID_ID, POP_TOT, YEAR, METHD_CL, CNTR_CODE, ...
3
votes
5answers
594 views

Query optimization [Oracle]

The Query: select JOIN_RESULT.batch_id as BATCH_ID, JOIN_RESULT.unique_doc_id as DOCUMENT_ID, JOIN_RESULT.brand as BRAND, JOIN_RESULT.message_date_time as UPLOAD_DATE, ...
3
votes
1answer
145 views

Does MySQL Enterprise Backup work across Operating Systems?

The problem with testing is that one can never be sure (it may seem to work and then you find some thing changed later). A definitive statement from the vendor would definitely be helpful (I cannot ...
5
votes
1answer
6k views

How can I get the Oracle TNSListener to start after changing my host name?

When running lsnrctl status I can see that it is using the old host name, but I don't know where it is pulling that value from. My Oracle installation is 11.2.0 on Windows7 x64, if that makes any ...
7
votes
2answers
376 views

Why do we have SHRINKDATABASE command in SQL Server

I have read across the internet where Finest Developer says shrinkdatabse should be avoided as it causes increase in fragmentation and decrease in performance . I would like to know from you guys ...
1
vote
1answer
864 views

Replacing a table with new version

I am a programmer changing the way a process works, and will be using a different table to do this. The process is just sending emails from a web application. Currently the database scripts run during ...
2
votes
2answers
336 views

speeding up a deletion in postgresql

I came up with: drop table if exists idtemp; create temp table idtemp as select documentid from taskflag where taskid='coref' and state = 2 order by statechanged asc limit howmany; ...
3
votes
1answer
269 views

What Happens When Identity Range IsExceeded?

I am using identity columns in my merge replication solution to give people an id they can tell us over the phone (i.e. to support staff). A rowguid column would be too hard for this. I have noticed ...
7
votes
1answer
2k views

Recursive CTE performance

Need help with recursive CTE performance. Below CTE is running very slow as it is trying to pull heirarchical data recusively. Table is big with every root id having upto 3 recursive itemid. There ...
2
votes
1answer
356 views

Multiple Publications for Merge Replication?

I am designing a system which will have one SQL server 2012 central database. Each client will user merge replication to take an offline copy of their data to edit on the road. If I add a ...
8
votes
3answers
1k views

Fix for orphan user 'guest'?

What can be done, if anything, when the special guest user is orphaned (not linked to any login)? For one of my databases (SQL Server 2005), executing the following lists the guest user as an ...
0
votes
2answers
167 views

Want to create an SQL function that removes table row duplicates

I'd be following the procedure outlined here (unless of course someone has a better way to do it), and I'm wondering if I could just have some help being pointed in the right direction on how to ...
5
votes
2answers
833 views

Query pauses after returning a fixed number of rows

I have a view which runs quickly (a few seconds) for up to 41 records (e.g., TOP 41) but takes several minutes for 44 or more records, with intermediate results if run with TOP 42 or TOP 43. ...
-1
votes
2answers
396 views

Tutorial in datamining [closed]

Where can I find about tutorial of datamining in SQL server 2012 or 2008 R2? The purpose is to improve my knowledge in datamining.
5
votes
1answer
852 views

Connecting to SQL Server using cached credentials

While migrating from SQL authentication (user-password) to integrated security I ran into an unexpected combination of requirements. SQL clients are services running under a LOCALSYSTEM or ...
11
votes
2answers
1k views

SQL Server Data Tools and partition functions

I'm creating a sliding window loading scenario and the partition functions will be changing their boundaries through time. I have created some partition functions in my SQL Server Data Tools (SSDT) ...
2
votes
1answer
854 views

How to calculate query that access system view cost in Oracle?

For a query that returns if there are any active transactions within current session , SELECT COUNT(*) FROM v$transaction t INNER JOIN v$session s ON (t.ses_addr = s.saddr ) INNER ...
2
votes
1answer
725 views

Ordering with custom paging when using pivot to convert a query

This is a follow up to my question on changing a flat result set into a different column set using Pivot. Scripts for test DB can be found in that link Ordering works just fine like this: SELECT ...
3
votes
1answer
4k views

Oracle 11: Change global index to local on huge production table

I have big partitioned table with global index. My case is drop old data from archived partitions. I can't simply drop partition because i have global index. So I have idea to use INVISIBLE local ...
3
votes
2answers
662 views

mysqldump fails to dump database

I m using following sql query for creating db backup mysqldump -u[username] -p[password] -h[hostname] [database] | gzip > [backup file path] This generates zipped .sql file in path specified but ...
4
votes
2answers
904 views

Database Schema for an address book with different mailing lists

I'm helping a friend out with taking an old excel, single-page database which contains around 12 different columns that store information about: person first+last name email(s) current address ...
1
vote
1answer
125 views

Where do caching servers conceptually fit in my architecture?

Given the simple well-known architecture below: Where (conceptually) does the caching server(s) sit?
3
votes
1answer
462 views

tds: unable connect to SQL Server using servername specified in freetds.conf file

I am using freetds to connect to SQL Server from ubuntu. First, the SQL Server is running at port 1433 currently. I can telnet it. The following command also works. I can query table data using it, ...
4
votes
6answers
9k views

SQL Server log shrinking Issue [duplicate]

Possible Duplicate: Why Does the Transaction Log Keep Growing or Run Out of Space? I have a 300 GB database log in our SQL Server. I want to shrink all the logs but it is not allowing me to ...
2
votes
2answers
102 views

Incremental backups - differences

What is the differene between: BACKUP INCREMENTAL LEVEL 0 DATABASE; and BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; ? I read some manuals, but I don't get the idea beacuse of my poor ...
1
vote
1answer
636 views

How many files should I create for one filegroup and 9 weekly partitions?

I have 9 weekly partitions on one filegroup. How many files do I need to create? There are 3 tables containing 46 million, 16 million and 10 million rows.
2
votes
3answers
708 views

Postgresql sync databases

I am having a postgres database on my portable and on a server. I would like to keep those two in sync as easy as possible. I know about slony but I am not able to figure out: Does it work when the ...

15 30 50 per page