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
2answers
30 views
Challenge. Split database 500 records in two smaller datasets, randomly
I have a database with 500 records. I want to split these records to 75% and 25% *randomly*in order to use the different datasets for training and testing to machine learning algorithms. Does anyone ...
2
votes
1answer
37 views
What are the risks for logging across databases via a trigger?
I've searched for this online and had mixed or unclear responses, and after posting on superuser, was directed over here.
On SQL Server 2005, we currently log certain table changes via triggers using ...
1
vote
1answer
27 views
How can we get tablename from inside of Trigger Code?
I have requirement that, need to pass tablename from trigger to procedure.
ALTER TRIGGER [dbo].[Trg_ProjectCreation]
ON [dbo].[Projects]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
-- ...
0
votes
4answers
40 views
Database Restore Failed Due to Incompatible Version of SQL Server
I am working on different two SQL Server , I need to transfer database from one server to another but problem is both server has different version.
Below is Image of Error message.
Using SELECT ...
1
vote
1answer
30 views
Restoring SQL Server 2012 database onto 2008
I am trying to restore a SQL Server 2012 database after I set the compatibility level to SQL Server 2008 by following the instructions as listed on: ...
4
votes
4answers
160 views
SQL Server: Worse performance on a new server
We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008. The performance on the ...
0
votes
0answers
17 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 ...
2
votes
1answer
31 views
Create SQL Script for Statistics
I wanna create script my whole table, including all statistics and indexes.
In SSM, When I right click table and create script, it gives me script for Indexes for not for statistics.
If I right ...
1
vote
1answer
49 views
Upgrade SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard
I understand that this is not a supported path, but does anyone have any insight about how to accomplish this? I can't seem to find any documents on the subject. I need my QA (2005) to match my ...
2
votes
2answers
31 views
how to check which background process are running in my oracle database?
To check all background process in oracle we can see using v$bgprocess view. I want to check which background process are active. Can anybody please help ?
Thanks
0
votes
2answers
50 views
Database search with multi joins
I have a MySQL database and I want to perform a little bigger search.
I have about 10k records in one of the tables and It's expected to grow, but slowly.
The biggest problem is that to perform the ...
2
votes
1answer
72 views
Postgres: count(*) vs count(id)
I saw in the documentation the difference between count(*) and count(pk). I had been using count(pk) (where pk is a SERIAL PRIMARY KEY) not knowing about the existence of count(*).
My question is ...
-1
votes
3answers
95 views
Add Contents in a Column and make them 0 [closed]
http://sqlfiddle.com/#!3/96f11/3
In the above fiddle, I need the required output in the Fiddle.
ie., The UserID column in Filtered Table and Main table are equal.
I need to get the Amt column data ...
1
vote
1answer
78 views
Separating tables vs having one table
At the moment I have a table setup that looks somewhat like this:
create table tbl_locationcollections
(
id int(11) PRIMARY KEY IDENTITY, --(Primary Key),
name varchar(100) not null,
...
1
vote
1answer
45 views
Summation query with complex grouping criteria
I have a database of coded actions with this structure.
{User, Date, ActionCode}
I need to generate reports based on dates and action codes, and the action codes are not clean because we have to ...
1
vote
2answers
31 views
How to create trigger on database that 'triggers' when mirroring role changes from mirror to principal
I want to perform some sql when my database mirroring state changes
3
votes
1answer
30 views
tempdb logs on same drive as tempdb data or with other logs?
For many reasons I only have 3 hard drives (RAIDed and in an Always-On AG) for all my database files:
D: Data
E: Logs
F: Tempdb
Should the tempdb log file go on F: with the data file(s) or on E:?
...
0
votes
1answer
33 views
Login failed for user 'domain\username'. (Microsoft SQL Server, Error: 18456)
I am facing this problem when connecting to local system db, but when i connect any server it connects.
Login failed for user 'domain\username'. (Microsoft SQL Server, Error: 18456)
For help, click: ...
0
votes
4answers
44 views
Selecting the first purchase item of each customer
I have a table like this:
CREATE TABLE SALES
(
CID NUMBER(4),
PDATE DATE,
ITEMCODE NUMBER(4),
ITEMNAME VARCHAR2(20)
);
INSERT INTO SALES VALUES (1111,'15-JAN-2011',4001,'LUX');
INSERT INTO SALES ...
0
votes
1answer
41 views
Efficient way to perform approximated search?
I have to perform a join between table_a and table_b, using three fields as key being one of them the date of the event, say, both tables have id1, id2 and evnt_time for eache record.
As it happens ...
3
votes
2answers
43 views
Extract part of string based on nth instance of character
I am trying to find a way to extract part of the strings below. I need everything between the 6th and 7th \ character.
\\fileServerA\d$\LiteSpeed\Wednesday\ServerA\Tlog\DBA1_TLOG_20110504_0333.SLS
...
0
votes
1answer
35 views
Combine multiple queries into single query
I am trying to run the following query:
SELECT Freight.Freight_No,
Freight.Available,
Locomotive.Loco_No,
Locomotive.Available,
Driver.Driver_No,
Driver.Name,
...
2
votes
2answers
42 views
Using TSQL to dynamically create Extended Properties Name
I would like to add "Description" and "Status" in the Extended Properties of a large database to all my Tables and Columns before someone fills in the values.
It would be very laborious to add these ...
0
votes
1answer
12 views
Running a Job from a Stored Procedure in another server?
How can I run a job from another server using a stored procedure?
Let's say
server 1 : db1
server 2 : db2
username : testssis
password : testssispass
sqljob found in db2: job1
Here is the part ...
1
vote
2answers
36 views
Creating a PostgreSQL SERIAL column using pgAdmin3
When I use pgAdmin3 to create a column of type serial, why does it instead create nextval('prices_id_seq'::regclass)?
Should we keep this type defined by pgAdmin? Manually create the table with SQL ...
0
votes
1answer
26 views
MySQL stored routine performance while using PREPARE
Instead of maintaining stored routines for each database in my current environment i have decided to create separate database just for stored routines storage. Mainly i am using them for reporting. ...
1
vote
2answers
42 views
“Rewinding” a Postgresql database
I have heard that Postgresql uses an append-only format for it's databases, and if this is true I should be able to 'rewind' the database to a previous point in time by removing the commits that came ...
2
votes
0answers
31 views
SQL - Grouping results by custom 24 hour period [closed]
I need to create an Oracle 11g SQL report showing daily productivity: how many units were shipped during a 24 hour period. Each period starts at 6am and finishes at 5:59am the next day.
How could I ...
3
votes
1answer
50 views
Error while taking backup using SSMS
I am accessing my sql server 2008 r2 express server using SSMS. I have about 5 logins. For a particular login I have all server roles other than sysadmin. It is a sql login(not windows authentication) ...
1
vote
1answer
52 views
Paging in SQL Server 2012 vs. previous versions
I have used lot of paging code in SQL Server 2008. The format is
With CTE(
-- SQL With RowNumber
)
-- SELECT ALL Page N
This is working fine. But I have heard that SQL Server 2012 has better ...
1
vote
1answer
70 views
GROUP BY with OR/AND clause?
Lets say my database looks like this:
Table: messages
+----+------+----+----------+----------+
| id | from | to | double_1 | double_2 |
+----+------+----+----------+----------+
| 1 | 1 ...
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
33 views
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' [closed]
I have 4 SQL Server 2008 instances from which I need to pull data using OPENROWSET. I am adding this data to a table on server 1. Server 1 and 2 are in a cluster, same as 3 and 4. I am remoted into ...
0
votes
1answer
32 views
Generic SQL Job Scheduler for multiple RDBMS's?
I have been searching for an answer to this, but can't seem to find anything. So my problem is this - we have an environment with MS SQL Server 2008, MySQL, and RedShift, and have some complex ...
1
vote
1answer
40 views
How can I identify the number of times a View is called in SQL Server?
How can I identify the number of times a View was called in SQL Server?
I am looking for an answer that is similar to this below which shows how it can be done for stored procedures.
How can I ...
0
votes
3answers
98 views
T-SQL Issues With Defining 'AS'
I am creating a fully dynamic application but have ran into a bit of a hiccup. There are multiple 'undefined' fields that can be defined by the users. The only problem is redisplaying them. Currently ...
2
votes
2answers
69 views
Identity proceeds as normal, but with a leading 10…?
So I noticed a very strange thing when tinkering with my database.
I had just inserted a row which was ID 47, then after inserting some more, I realised that somehow my Identity had skipped all the ...
0
votes
3answers
79 views
Is transaction log lost after backup on SQL Server?
I have database that has regular nightly backup (full recovery, full backup). I noticed some irregularities in data and wanted to check out transaction log to see what happened. I restored earlier ...
0
votes
1answer
18 views
Simple query not using indexes
My query is not using indexes.
It is a simple query.
Can someone explain why that's the case?
The query:
select TIME_FORMAT(start_time,'%H:%i') start_time,
TIME_FORMAT(end_time,'%H:%i') ...
1
vote
1answer
50 views
How to enhance the SQL query performance for thousands and millions of huge data
Now Our team are involved in a forum data analysis project. Its target data is so huge(I think). We should find the potential informations from it. Such as the popular products,the customers ...
0
votes
3answers
59 views
Oracle SUM - ORA-00937: not a single-group group function
For every journey want to sum them to work out the distance between.
SELECT Journey.Journey_No, Stages.Stage_ID, SUM(Stages.Distance_Between)
FROM Journey, Journey_Stages, Stages
WHERE ...
2
votes
2answers
25 views
SQL3550W: … target column has been defined as GENERATED ALWAYS
I am trying to export + import data from a table in a db2 database to another.
But while running the export command I am getting the following error.
SQL3550W The field value in row "26" and column ...
0
votes
2answers
52 views
Storing data in PostgreSQL: One table or two?
I've just started using PostgreSQL 9.2 and my data consists of product prices at various points in time, usually a different price every month.
Question: Because every product can have different ...
0
votes
0answers
31 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
2answers
42 views
Accessing Database without using SQL
This might be some ambiguous but I have not much info about this so I need some start point;
As a general idea; in conventional RDBMS', there are a DB engine and storage of data. We use the language ...
1
vote
3answers
75 views
Relational vs Non-Relational Database for Events Database
I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
1
vote
0answers
16 views
Is there a generic SQL-92 ODBC 64-bit Mac driver for Python?
I have a 4D SQL database which implements SQL-92.
4D's ODBC driver does not work on my system because it is compiled for 32 bit (and I am on 64 bit) and it is closed source.
I wonder if there is ...
4
votes
1answer
62 views
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR
We have a process that generates an inventory report. On the client side, the process splits of a configurable number of worker threads to build a chunk of data for the report that corresponds to one ...
2
votes
1answer
53 views
Replacing a PHP loop with a MySQL Query
I have a MySQL database table where I store a user_id and a hash each time someone logs in. The hash is stored in a persistant cookie so it doesn't change as users log in and out of the site.
The ...
2
votes
1answer
80 views
Update “NULL” string to Actual NULL value
I have a table that contains NULL values but the problem is that some of the values are actually string "NULL" and not actual NULLS so when you trying something like
where date is null
it will not ...
