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.
0
votes
3answers
116 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 ...
0
votes
2answers
151 views
optimize big sql query
My query has to return a statistics for example for march containing productname and price and its sidedishes (1:n relation) with the right price of each sidedish and the right tax for each sidedish ...
0
votes
2answers
90 views
Indexing a longtext field
I would like to run an index on a longtext field using:
CREATE INDEX post_meta ON wp_postmeta (meta_value(8));
There are currently ~1 million records.
Questions:
Will creating this index affect ...
13
votes
1answer
533 views
Sql Anywhere 11: Restoring incremental backup failure
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible ...
3
votes
1answer
39 views
Create Scheme that allows for fluidity between entities
We are a small rapidly evolving company and recently investigated switching databases from SQL Server to a graph database. We like the graph approach because of the fluidity and openness that it ...
1
vote
1answer
52 views
Custom sp_who/sp_whoUsers
I need to allow a client in a dev DW SQL 2K8R2 environment, to view and kill processes, but I do not want to grant VIEW SERVER STATE to this person (he's a former sql dba and is considered a potential ...
0
votes
1answer
22 views
createdb command error : could not connect to database
I am using the following command for creating database in postgresql.
createdb -D pg_default -E UTF8 -h localhost -p 5432 -U pramil -W pramil mydb
but this command results prompt for password.When ...
0
votes
1answer
60 views
query taking long time to execute.we are expecting result in very quickly anybody please rewrite it
Query is taking long time to execute.we are expecting result in 0 sec.If possible Please help me to rewrite it. Also suggest me to add any indexes on table.Also suggest me if optimization is needed.If ...
0
votes
1answer
12 views
content types of insertion
I have a CSV file that contains a lot of integer values. Is it better to insert these individual values in bulk as in a full transaction or should I be inserting the CSV file itself into the MySQL?
-1
votes
1answer
61 views
Validate each parent intermediary is also a parent to itself
I have a table for which I want to validate where each parent intermediary is also a parent to itself. How to write query to validate this?
COLUMN DATATYPE DESCRIPTION
...
4
votes
0answers
150 views
Receiving error Error: 18059, Severity: 20, State: 1 in the SQL Logs
I'm using SQL Server 2008 Sp3
Lately I'm having errors in the SQL Logs:
Error: 18059, Severity: 20, State: 1.
The connection has been dropped because the principal that opened it subsequently
...
3
votes
0answers
33 views
SELECT COL_NAME(969262708, ORDINAL_POSITION) returns a NULL value in one of the rows
So I've got a Stored Procedure that's copying data from one table to another. It calls this other SP to get the column names. I didn't write this darn thing, but here's that part:
ALTER PROCEDURE ...
3
votes
0answers
72 views
Key Lookup and Full-text index
I have the following query:
SELECT T2.Title
FROM TitleTable T1
INNER JOIN TitleTable T2 ON T2.FKID1 = T1.FKID1
WHERE T1.FKID2 = @ID_PARAM1
AND T2.FKID2 = @ID_PARAM2
AND ...
3
votes
0answers
229 views
Query to find optimal filegroups for objects
I have been assigned a task to create four file groups (one per volume) locate tables so that they are located in a manner that during an ETL process no filegroup is being read and written to at the ...
2
votes
0answers
99 views
Cannot connect to SQL Server 2008 after updating the service pack
After updating, whenever I start the service of the server in configuration manager, it always stops then.
And I found the error in the log
2013-04-13 19:08:19.63 spid7s Error: 15174, ...
2
votes
0answers
114 views
Transform XPath map into XML document using relational data
Background
Most modern databases have XML functions that can be used to extract data in an XML format. I want to avoid the task of manually calling XML functions to extract the data.
This problem ...
2
votes
0answers
47 views
merge replication too big
I have multiple handhelds which sync their data via merge replication. from time to time, new core data is imported on the server-database.
for some reasons I keep the old data in the databse and set ...
2
votes
0answers
124 views
Sybase SQL - Truncation error occurred. Command has been aborted
Need help with below code, as it fails with truncation error
Truncation error occurred.
Command has been aborted.
create table monCacheQuality (
ServerName sysname
...
2
votes
0answers
80 views
How to speed up SQL Server RIGHT JOIN on 100MM+ Records - use TVF?
I use a table insert to UNION a CTE of converting transactions to visits (converting or not) and then summarize the visit data (no details, just pages visited & txns completed) to get funnel ...
2
votes
0answers
37 views
What is the equivalent of a “Certificate of Destruction” when using a cloud-hosted database?
We have a Rails application hosted by Heroku and using an Heroku Postgres database. Some of the information we store is considered to be sensitive by our users, and we've been asked if we can provide ...
2
votes
0answers
41 views
Limit Output Flat File Size In SSIS
I am using Flat File Destination to export my data's to a Text file. I need to limit the output File size to 1 MB. Is it possible?
2
votes
0answers
453 views
Error 9001, Severity: 21, State: 1 The log for database 'DB_NAME' is not available
I have a SQL Server 2008 R2.
I got a mail that the backup had failed, I opened the SQL log viewer and started browsing.
And i found these two errors a bunch of times.
error 1:
Date ...
2
votes
0answers
101 views
Last Known Successful DBCC CHECKDB
I understand that looking at DBCC PAGE is supposed to show me the last known good DBCC CHECKDB but I am not seeing this work correctly.
I have a database that I know is corrupted. If I run DBCC ...
2
votes
0answers
208 views
Help with SELECT queries
I need help with some queries. I struggled do find out how to do it, but I think I finally caught on or at least got the results I was looking for in the database.
These are the tables (given by my ...
2
votes
0answers
80 views
How to Audit for Access with Cross Database Ownership Chaining
I've just joined the data team of a new company and we have a large SQL Server environment (100+ instances) and cross database ownership chaining is on by what I gather is a necessity. I'm looking for ...
2
votes
0answers
85 views
ERWIN create and use database
Im trying to generate physical database from my logical model using ERWIN 7.
All is well in the script that is generated automatically, there is only the problem that the model is created in the ...
2
votes
0answers
140 views
MySQL database structure: more columns or more rows
I collect how people tag topics with categories in table like:
ID | topic_id | votes_Category_1 | votes_Category_2 |.......... | votes_Category_12
This table holds 1 row per topic and dynamically ...
2
votes
0answers
61 views
QBE Query By Example. How does it handle OR conditions?
I've been looking at implementing QBE into an application but need more information on how more complex queries work.
How does QBE handle "OR" conditions? For example when searching a telephone book ...
2
votes
0answers
234 views
SQLite Performance Tuning
I have the following query, which fetches data from only one table.
It is a query which is supposed to return data for an autocomplete function.
Autocomplete data can be in text1 or text2.
The ...
2
votes
0answers
187 views
SQL fulltext accent insensitive
I am using SQL Server fulltext containstable and the column which is indexed has collation Czech_CS_AS, so why when I have word "byt" it returns records with word "být" too. I thought that the ...
2
votes
0answers
75 views
SQL fulltext indexing ranking combined with ranking used by window's file indexing service
We have a list of records contained within a MS SQL database table, we have enabled "Full Text Indexing" on the table. Also, we have set up a window's file indexing service and added a catalog ...
2
votes
0answers
118 views
Allow users to do anything within his own schema but cannot create or drop the schema itself
I have created a schema in SQL Azure using following permissions on my database role:
CREATE ROLE myrole AUTHORIZATION dbo;
EXEC sp_addrolemember 'myrole', 'myuser';
CREATE SCHEMA myschema ...
2
votes
0answers
77 views
How unsafe is it to change the data source of repl_distributor on a publisher
I have a long story that I will condense to a few bullet points that leads up to my question
Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
...
2
votes
0answers
158 views
How to get SQLCMD to output errors and warnings only?
How can you get SQLCMD, when executing a SQL script file, to just output any errors or warnings it encounters?
I essentially dont want information based messages to be output.
2
votes
0answers
207 views
SQL Developer Data Modeller and Data Dictionary question
I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please?
I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
2
votes
0answers
215 views
What is causing all of the msrepl_tran_version columns to become out-of-sync between locations in transactional replication setup?
I have been having a recurring issue with transactional replication setups at the firm I work for. We use SQL 2008 R2. Seemingly without warning or any replication errors, all of the ...
2
votes
0answers
69 views
sql data to a csv-file via cobol
I 'm using the following code :
string
'insert into ' delimited by size
'tgamGameTeams ' delimited by size
'(Id,Name,RemainingBudget,TeamGamePoints,GameId) '
...
2
votes
0answers
179 views
Oracle faster overlap check
We've a table with two columns beginrange and endrange, which contain hex values.
To this table no overlapping ranges should be inputted.
We had implemented the check by having a composite functional
...
1
vote
0answers
22 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 ...
1
vote
0answers
38 views
Database Timeout Error from VB Application
Recently we are receiving so many database timeout error from different servers
we are using vb application -- which will use ODBC connection to connect database - here no problem
when we run the ...
1
vote
0answers
62 views
Getting LCK_M_S On read committed Snapshot Isolation
I'm getting LCK_M_S on read_committed_snapshot isolation. From my understanding, this isn't supposed to happen since my selects are not placing shared locks anymore.
From my logs, I can see that my ...
1
vote
0answers
45 views
Why is this query creating 300+ temporary tables in Mysql?
SHOW global STATUS LIKE '%tmp%';
set @UID = 132;
set @param2 = 'cde';
set @param3 = 20130331;
set @param4 = 'C';
select p.id, p.column44, p.column42, ue.column35, u.id, p.column43, p.column45, ...
1
vote
0answers
85 views
Collect CPU, reads and writes when replaying SQL Profiler Trace
I'm trying to replay a trace on a test environment with SQL Profiler in order to benchmark a database prior to making some performance tweaks. I intend to replay the same trace at various stages to ...
1
vote
0answers
44 views
Update table mysql and if value is 10 update another table
I've following sql to update results table:
$mysqli->query("UPDATE results
SET result_value = IF('$logo_value' - result_tries < 0 OR '$logo_value' - result_tries = 0, 1, ...
1
vote
0answers
153 views
Is there a Postgres admin GUI that can execute a master file containing multiple sql files
I'm developing a really long script. I'd like to break the script into smaller, more manageable scripts and include each sql file in a master file, then just execute the master file.
example: ...
1
vote
0answers
37 views
Will Startup Procs Run Again After Database Recovery?
We have a number of stored procedures that run on startup via the sp_procoption startup:
exec sp_procoption 'ProcName', 'startup, 'true'
A customer's server started up with a very large database in ...
1
vote
0answers
161 views
Efficiently retrieve big amount of data based on date range
Table EVENTS
TimeStamp |O.Name |Location |Source |
2008-11-12 |Pretorian|Európe |England |
2009-12-24 |Lex Rosa |Európe |Italy |
2010-01-01 |Nasdaq |USA |Whasington |
...
1
vote
0answers
363 views
The Cluster service failed to bring clustered service or application 'SQL Server (MSSQLSERVER)' completely online or offline
SQL Server service restarted/stopped, which cause the production database down n find this errors in System log.
ERROR5:The Cluster service failed to bring clustered service or
application 'SQL ...
0
votes
0answers
19 views
Backup very large table
I'm deeply sorry if this is an amateurish question, but I have to update certain values of a large table (for the sake of a presumed example, it is called 'Resource' and it is over 5M rows) and thus I ...
0
votes
0answers
75 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'
...
