An acronym for "Structured Query Language", SQL can be used in relational database management systems (RDBMS) to query, update, delete, and insert data as well as modify the structure of the database. It can also be used to manage schemas and data access privileges.
1
vote
0answers
48 views
why size of data files is not grow up even existing data?
currently, I created 1 partition table with 1 file group and 4 data files (4 quarter/year).
Data have been inserted successfully. And everything is right when I check records belong to which ...
1
vote
0answers
89 views
Use of hash functions in group by?
I'd use a listagg() to generate a list of components a certain customer has and compare it to another list generated the same way somewhere else to detect inconsistencies. The problem is that ...
1
vote
0answers
109 views
hStmt/cursor error caused by faulty data?
Could a busy hStmt and invalid cursor errors be caused by faulty data?
ODBC and the software that connects to the database is correct and working - i have ran a test with a clean database (that has ...
1
vote
0answers
257 views
SELECT value from database over ODBC wont reach the software
SQL Server 2008 R2 latest updates.
SQL server ODBC driver version 6.01.7601.17514
PS!!! native drivers are incompatible with the software so i cannot use them.
I cannot edit or change the server ...
1
vote
0answers
85 views
Get all comment.message, status.message, users.* and profiles.* where users.user_id exists in friend.friend_id or friend.user_id
I need some help building this query because it's a bit complicated at least for me. I need to get all comment.message, status.message, users.* and profiles.* where users.user_id exists in ...
1
vote
0answers
31 views
How does MySQL 5.1 use indexes?
I've read the docs for MySQL v5.1.x on how about the indexes are used, but I'm not sure I understood it properly.
Suppose having the following MySQL table:
CREATE TABLE IF NOT EXISTS ...
1
vote
0answers
507 views
SQL query optimization in Prestashop e-Commerce solution
I'm working on a layered navigation module within Prestashop e-Commerce solution.
I'm trying to optimize a SQL query which creates a temp table during execution. I think this is creating a ...
1
vote
0answers
111 views
Database model problem from MS Access to SQL Server 2005
Good Day,
I am a C# programmer but I have a problem with a database model on SQL Server 2005. I have a client who told me to rebuild his database from Access to SQL Server 2005 and actually I did but ...
1
vote
0answers
110 views
Cannot Check if the Access Database Engine is Installed and Configured
All, I want to check if the Access Database Engine is installed and linked to SQL Server. On my development machine (x64-bit) the following queries both show the Access Engine to be avalible as a ...
1
vote
0answers
54 views
Tool to list down resultset from SQL Server for bulk data
I have many records with me for which I need to query the database. How can I write a query that can list down all the resultset at once using my large set of data?
The database that I used in SQL ...
1
vote
0answers
46 views
Drill down report links fall outside cell
Apologies for the vague title, not sure how to summarise the problem...
I'm creating a dashboard report showing server state for a group of SQL servers, the problem is that the links for the drill ...
1
vote
0answers
42 views
How to write up the specs for the server that we will need
I am a dev. and have written basic app. which will be used by customers this app. Basically, I present them screen to select their excel file which has some billing info. we are analyzing this billing ...
1
vote
0answers
23 views
Monoblock, Multiblock queries?
What exactly mean the terms monoblock / multiblock queries in data warehouses when talking about materialized views? Does a monoblock query just use one data source (a normal table) while a multiblock ...
1
vote
0answers
218 views
Oracle Flashback Archive aka Total Recall in MySQL
What would you suggest as a replacement system to achieve the same functionality of Oracle Flashback Archive aka Total Recall in other DBMS, in general or specifically in MySQL or MariaDB?
...
0
votes
0answers
21 views
developing procedure in sql for global use
what type of complex procedure can i develop in SQL which will make others work easy as well ,
like in Java , i had developed a program for FTP so that anyone can import this program and can use it ...
0
votes
0answers
78 views
how to find similar word with more similarities
how to Find words with length less than or equal...
declare @inp nvarchar(max),@data nvarchar(max)
set @inp='You can dance, you can jive, having .... jove... jve, ...'
set @data = 'jeve'
...
0
votes
0answers
11 views
Vote to a db server using session key
I do not know if this is the right stackexchange site to ask this question, but I believe that is relevant.
I am trying to implement an e-voting protocol. At some point the protocol says that server 1 ...
0
votes
0answers
15 views
How to get Greenplum table defintion?
There are already tables created in the schema but I don't know how to get the detailed information of how it was created. Like the configuration used, the orientation, etc.
How do I get this ...
0
votes
0answers
22 views
MySQL not using resources?
Hi I have a decent setup: 16Gb RAM and a 4 cored CPU. I'm on a 64-bit Windows OS with MySQL Ver 14.14 Distrib 5.5.24 Win64 (x86). I am also using InnoDB.
The query I am using to test the setup is a ...
0
votes
0answers
14 views
Performance Slow After CompactRepair Access
I am performing a large number of insert operations using VBA - Access. the VBA code is in a file "control.accdb" performing operations on "data.accdb"
Few tables in the process are created from the ...
0
votes
0answers
50 views
How to update column value in MS-Access by comparing two columns?
I have an Access 2000 table with 10 fields. I want to compare the 2 column and update the third one.
To elaborate :
keyfield cno entno uno
(Text) (Text) (int) (int)
...
0
votes
0answers
15 views
Identical Postgres index scan taking 5x longer on server
I have an intermediate table for managing a many-to-many relation between tables called Expert and Subject:
Column | Type | Modifiers
...
0
votes
0answers
43 views
Linked server performace issue?
I have created a linked server in sql server 2008 R2 Enterprise Edition for mysql i.e. MySQL database is accessible under sql server environment. I have a created a trigger in sql server such that ...
0
votes
0answers
52 views
Insert performance deterioration over network
i have a strange issue with a windows application (in delphi) running on a win7 client.
The application has a loops and inserts rows on a SQL Server table.
It's simply an insert statement, repeated on ...
0
votes
0answers
36 views
Huge sizes Replication Tables in Sql Server db, how to deal with?
I've a sql server database that is configured to work with old software, i've no details about the software, but i know that DB uses replication.
the DB size dramatically increases.
When i ...
0
votes
0answers
44 views
Oracle Alternative to EXISTS EXCEPT
I wonder if there is an equally elegant solution for Oracle for the problem posted and answered here:
Comparing Columns that can contain NULLS - is there a more elegant way?
I can't get this ...
0
votes
0answers
23 views
Ghost replication jobs in replication monitor
Has anyone ever seen and know the cause of this issue? We have transactional replication with pull subscriptions. At 2am this morning it appeared that the job (that runs every 15 minutes) stalled out. ...
0
votes
0answers
16 views
Data usage increases initially when reorganize partition mysql cluster
In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes.
But before ...
0
votes
0answers
27 views
mysql: how many disk seeks were made for a select query
I will fire a select query. I want to know how many disk seeks does that query take.
mysql documentation has given formula for full table scan. ...
0
votes
0answers
130 views
Achieve PostgreSQL hstore functionality in MySQL
Please suggest any MySQL 5.5+ Engine that can support collection of key-value pairs be stored in any column of a table.
I don't know if this feature is available out of the box in MySQL like ...
0
votes
0answers
38 views
Mysql notifier Error
i'm getting error when opening Mysql notifier High Severity Error Element 'UpdateCheck' was not found. Line 3, position 2. My mysql server is running. why it's showing this error.
0
votes
0answers
45 views
Database too slow after CHARSET Conversion
I have an Oracle database which runs on version 9.0.1 with WE8859P1 charset and i'm trying to migrate it to the version 9.2i which has the WE8MSWIN1252 charset.
The conversion is made without any ...
0
votes
0answers
98 views
error in creating trigger in phpmyadmin
I have 4 tables:
event:
event_id(p.k) | uid | circle_id(f.k)
activity:
uid | performed_activity_id(f.k->event_id) | activity_type_id
follow:
follower_id | circle_id(f.k)
noiticication:
...
0
votes
0answers
137 views
Postgres error ( XX000: invalid memory alloc request size 4294967290 )
I'm getting the following error in my postgres 8.4 database:
XX000: invalid memory alloc request size 4294967290
Operating System : Windows 7 64 bit
Memory : 8GB
Database Version: Postgres 8.4 ...
0
votes
0answers
38 views
Connecting to an SQL Azure Database from SSMS - IP Restriction
I am trying to connect to a new SQL Azure Database via SQL Server Management Studio. The client box running SSMS is hosted on a production DB so we restrict access on 1433 to just a handful of IPs ...
0
votes
0answers
187 views
Understanding the time difference between data grid initial display and export/full display using Toad for Oracle
I am trying to run a query on a local Oracle DB and output the results to a .CSV file. The query runs in a decent amount of time (usually less than 5 minutes), but returns tens of thousands (possibly ...
0
votes
0answers
73 views
Performance Optimising MySQL query
I have this query in my mysql database, when i execute this, it takes about 4 sec. To give me the result (on xampp 1.8.0 with mysql 5.5)
I was wondering if there is any way to enhance this query so ...
0
votes
0answers
54 views
Monitoring calculation in xDB replication server in PostgreSQL
I am using PostgreSQL 9.2.
I have installed xDB replication server through stack builder.
I want to know the how much the server slave is lag behind the master.
Master - 192.168.1.2
Slave - ...
0
votes
0answers
106 views
MySQL Left Join Select all rows
Hi guys I have a query which is pulling data from database :
SELECT sandwich_table.id,
`sandwich_name`,
salad,
COUNT(salad),
salad_type.type,
...
0
votes
0answers
81 views
Try to find a match using SUBSTRING(SHA1(value)), 0, 6)
I have a tbl where all entries for companies that participate in a online project are saved. This table is named "business". Those companies can use their employess to access the online platform i 've ...
0
votes
0answers
222 views
How to integrate sqlite extension in XAMPP?
There's an extension on the http://www.sqlite.org/contrib?orderby=date, extension-functions.c, which integrates the SQRT command in sqlite.
How can I integrate this and use it in my Windows-XAMPP ...
0
votes
0answers
42 views
Which mysql server 5.5 variables would be involved in queries locking in sending data state?
A large portion of my queries (~58%) be it for queries with previously quick return rates or other, are spending in my monitor as sending data. I made some configuration changes but it was very broad ...
0
votes
0answers
120 views
RAND in T-sql function
Can any one tell why t-sql not allowing using RAND function in side a function
SELECT CAST (RAND() * 10000000 as varchar(20))
the error is
Invalid use of a side-effecting operator 'rand' ...
0
votes
0answers
531 views
0x84BB0001 Error when installing SQL Server 2012. Could not create a handshake
I have hopelessly attempted to install SQL server 2012 onto my 64 bit Windows 8 machine.
The database engine always fails to install with error 0x84BB0001. Native reporting also fails, I reckon from ...
0
votes
0answers
454 views
Dynamically Converted rows into columns (Pivoting)
Query
SELECT
Performparam.performparam_Name,studfeedback.studfeedback_Rating, SUM(studfeedback.studfeedback_Rating) AS total,
COUNT(studfeedback.studfeedback_Rating) AS totastudents, ...
0
votes
0answers
196 views
with using PIVOT table sql server
I am facing a small issue while using PIVOT table.
My problem is as following.
I have a single table with the procedures id and their steps and i want all the steps needs to be displayed in 5 column ...
0
votes
0answers
37 views
“optimizer was unable to construct a valid access plan” after Update ASA9 to SA12
After an update from ASA9 to SA12, there seems to be a problem with several procedures.
This occurs only if the user does not have DBA authority. In ASA9 everything worked fine.
SELECT * FROM ...
0
votes
0answers
100 views
GROUP_CONCAT with ORDER BY , but results are not orderd
SELECT
*,
(SELECT
GROUP_CONCAT(url SEPARATOR '$$' )
FROM project_photos
WHERE project_id = projects.id
ORDER BY priority) AS images
FROM projects
WHERE catID = 2
LIMIT 0,5
above query works fine but ...
0
votes
0answers
102 views
How do I get the date that each user last logged onto the server / database in SQL Server 2005
Currently, I have the following code that gets the DBNAME, USERNAME, ROLE_NAME for each user on the database. I need to get the last logged in date for each user to fill in the
LASTLOGIN_DATE.
ALTER ...
0
votes
0answers
278 views
Sqlsrv sqlsrv_num_rows FALSE, adding cursor type times out
$sql = "SELECT * FROM lastdeath";
$result = sqlsrv_query( $con, $sql);
if( $result === false )
{
die( print_r( sqlsrv_errors(), true));
}
$row_count = sqlsrv_num_rows($result);
echo $row_count;
...
