0
votes
0answers
2 views

What are the minimum requirements for running a dtsx package on a PC?

One of my clients has some very specific needs to get a spreadsheet run through some ETL processes I have created. I have developed an SSIS .dtsx package which imports an Excel spreadsheet into SQL ...
0
votes
0answers
4 views

How to read the deleted value using a variable

I'm trying to get @OldValue = (select @fieldname from #del) to give me the value. Instead I get the column name for the result. Is there a way to write this so it can output the value. If I write ...
0
votes
0answers
7 views

Multiclient application: several tables or several IDs?

We are designing a common product to serve several companies. The most convenient way to do this, technically speaking, is to deliver a database to each customer. But we predict that, depending on the ...
0
votes
0answers
7 views

How to give a prefix to all columns of a JOINed table in MySQL?

I have a data schema like this: car id type -> ENUM('Tesla', 'AstonMartin', 'Bmw') common_attribute car_tesla car_id specific_attribute_a specific_attribute_b ...
1
vote
0answers
5 views

How to design for scalable set operations?

This is the requirement for an educational application to teach words to language learners: Learner can declare that he/she knows a given word Learner can memorize the given word (to be managed by ...
0
votes
1answer
20 views

Append Records to a fixed number of columns using dynamic data [duplicate]

I have a table with 22,000 records formatted like so: Input [ID],[Cost Center],[Function] 1,01A1001710,GF000001 2,01A1001710,GF000802 3,02R1012000,GF000001 4,02R1012000,GF000059 ...
2
votes
1answer
14 views

How to JOIN a table with a name that equals to a determined value in MySQL?

The model of the (PHP & MySQL based) Zend Framework 2 application I’m currently working on contains a inheritance similar to the one described here. To map this to the database I’m using the ...
2
votes
1answer
54 views

Blockchain (Bitcoin) as a database?

I was reading this BBC News article and the following excerpt, caught my attention. It sounds like Always On Availability Groups or High Availability Mirroring, maybe with security automatically ...
-1
votes
1answer
14 views

Update log table with all table updates

I need to update a log table with old and new updated values. Any ideas how can we do this in a trigger? I need to log all inserts and updates and write a custom message in the column like.. "User ...
0
votes
0answers
12 views

Offsetting reporting Load from one server to another

I have a SQL Server 2008r2 database ( Let's call it "BIG_DB") at 200GB. This server gets hit hard. It is the back end for an application, BIG_DB is a source of a lot of reporting. There are about ...
0
votes
0answers
11 views

Cannot install SQL Server 64bit developer edition [on hold]

I'm trying to install SQL Server 2014 Developer Edition (that MS now gives for free, without any Product-Key) on my Laptop. Laptop configuration as per settings-->System-->About Menu: Processor: ...
1
vote
0answers
5 views

ORA-01017 connecting to example schemas on Oracle VM appliance from Windows host

I'm a software developer and am working on getting an Oracle VM Appliance running for testing purposes (the Database App Development VM with Oracle 12c - ...
-1
votes
1answer
10 views

SQL Server 12 Instance / server name change

I created a sql server instance and the name show up differently in test and prod. How can i change the prod name to not have the names repeating ? Prod : select @@servername EHCPSQL12\EHCPSQL12 ...
0
votes
0answers
11 views

MYSQL refuses to set password for new user

I'm trying to create a MYSQL user/password. And every time I create the user - mysql does not honor my password. It's just blank. mysql> select Host, User, password_expired, Password from ...
0
votes
0answers
3 views

DSE Cassandra decimal type

I generated solrschema with dsetool on a table name seriesdata (its key is composed by seriesmetadata_id, initialtime; two decimal field). These fields are defined as DecimalStrField but they are ...
2
votes
0answers
8 views

Asynchronous Availability Group Secondary Verify Up To Date with Primary Before Backup

I was wondering if there was a way to include a verification step before a backup on a secondary replica under asynchronous commit mode in availability groups to verify that the secondary replica is ...
11
votes
1answer
75 views

Multi-statement TVF vs Inline TVF Performance

Comparing some of the answers on the Palindrome question(10k+ users only, since I've deleted the answer), I'm getting confusing results. I proposed a multi-statement, schema-bound TVF which I thought ...
0
votes
0answers
7 views

MongoDB replication doesn't work using Java driver

I have a three instance replica set and i am using the following code to insert values in my mongodb database constantly. MongoClient client = new MongoClient(Arrays.asList( new ...
-2
votes
0answers
13 views

Please Help for ERROR procedure [on hold]

I have error on create procedure "GetFamilyTree" with copy paste those script on my phpmyadmin tool on localhost this is my error, where is error?? structure table 'category' | idcategory | ...
0
votes
1answer
10 views

postgres full text search modifies ts_query

I have following query: select vec.vec, vec @@ to_tsquery($$'fabr':*A$$), -- true to_tsquery($$'fabr':*A$$), -- fabr vec @@ to_tsquery($$'fabry':*A$$), -- false ...
1
vote
0answers
12 views

Accessing Encrypted SQL Server database through a web-based application

I have secured a database within SQL Server Instance on my local machine using Netlib Encryptionizer. I can access the database by securing my SQL Server instance using the same password as encrypted ...
0
votes
1answer
26 views

Explain plan gives different results depending on schema

I have a query that joins a multi million row table to one containing hundreds of thousands of rows. Schema owner 'ABC' owns the smaller table and schema owner 'DEF' owns the larger table. They both ...
0
votes
0answers
17 views

Always-On Synchronous Mode Possibilty

We have 2 SQL Servers at Production site and 1 SQL Server at DR site. Please correct below things as I am not getting clear idea about these sync mode in Always-On: If I install SQL Server FCIs in ...
-1
votes
0answers
31 views

Inner Join two select statements

I try to apply inner join on two select statments. 1st Select fetches 8K records 2nd Select fetches 8.2k records When apply inner join it fetches 300K something records. I don't know whats wrong ...
-1
votes
0answers
26 views

Hierarchical Query FROM View OracleDB [on hold]

I have a view, which has columns: NODE_1 | PORT_ID_NODE1 | LINK_NAME | PORT_ID_NODE2 | NODE_2 ------------------------------------------------------------ NODE_1(2) and PORT_ID_NODE1(2) ...
-2
votes
0answers
13 views

How can I troubleshoot filetream? [on hold]

I am a fairly Junior DBA, when I say that I have SQL backend for an APP that I support. I need help with SQL Filestream, is there anyway to troubleshoot adding files to filestream without actually ...
8
votes
4answers
90 views

Separate letters from digits in alphanumeric string

I have an alphanumeric string as input and I want to get two results out of it: a string where all the numerals are removed and an integer that is the sum of all the digits in the input string. ...
1
vote
0answers
24 views

Function for matching email address returns full table of emails

I am using Postgres 9.4.6. I have created a Function for finding email address that match an email variable that is passed. However, when I search for 'user@email.com' I get a full table of email ...
0
votes
1answer
10 views

Specify what columns to display in a SHOW COLUMNS statement

Does mysql offer any possibility to specify what columns to display in a SHOW COLUMNS FROM my_table statement ? from this : Field Type Null Key Default Extra ...
0
votes
2answers
33 views

Similar Jobs in two different Servers

Can anyone just help me with a script to find similar SQL jobs in two different instances/servers?
1
vote
0answers
19 views

SQL Server Sharding strategy optimization

I have implemented a sharding solution for our SQL Server databases as per the MSDN documentation here: https://msdn.microsoft.com/en-gb/library/dn589797.aspx This has been running for around 6 ...
0
votes
1answer
8 views

DR site SQL DB server not need Quoraum Disk?

We have two 2 SQL DB Servers and Share disk in production site and 1 DB in DR Site. Production site have Quorum Disk on Share Storage. Production site DB servers can access this share storage, but DR ...
1
vote
0answers
6 views

How To download the Snapsort File using FTPS in the replication Sqlserver 2014. in my case FTP is working

I can communicate with FTP, I am working on SqL Server 2014 I have two data base which is two company data base. Company A is Containing Domain data and other Company is Pulling the Data using Snap ...
0
votes
2answers
27 views

How to find referencing tables? [duplicate]

I'm on SQL Server 2014 and I have a User table: +----+------+-----+ | ID | Name | ... | +----+------+-----+ | 11 | John | ... | | 12 | Jack | ... | | .. | .... | ... | +----+------+-----+ And I ...
4
votes
1answer
20 views

During rollback, is lock escalation reversed

Generally, SQL Server will take locks during updates. It also supports Lock Escalation: Lock escalation is the process of converting many fine-grain locks into fewer coarse-grain locks, reducing ...
4
votes
1answer
294 views

Difference between clustered index seek and non clustered index seek

What is the difference between Clustered Index (CI) seek and Non Clustered Index (NCI) seek? Does one perform better than the other? The reason I am asking this is because I have a table with 50 ...
0
votes
0answers
12 views

Memory usage of MongoDB

I've got Django app with mongoengine, which executes some aggregation-queries often enough. The main problem is that mongod takes all the RAM and then crashes, so no LRU working, mongod just trying ...
1
vote
2answers
29 views

Create view with group by and extra fields

I had a hard time putting the question title together but essentially I want to create a view like this: ALTER VIEW vPlaceStatistics AS SELECT COUNT (TypeID) as Count, TypeID FROM PlaceStatistics ...
0
votes
1answer
12 views

FullText Search

We came across an issue using FullText Indexes and SQL 2008 R2, not sure if it's by design or I am missing something. When we search using a fulltext index, I noticed SQL appears to trim leading and ...
0
votes
1answer
17 views

Can't install Microsoft SQL Server 2016 Release Candidate 3 (RC3) on Windows Server 2008 R2

I am attempting to install Microsoft SQL Server 2016 Release Candidate 3 (RC3) on Windows Server 2008 R2. I have removed all other versions of SQL Server, and removed VS 2015 Community and all it's ...
1
vote
0answers
8 views

How to retrieve the distinct domains of a compound domain from DQS using SSIS?

MS Data Quality Services (DQS) has a concept of Compound Domains, which lets you turn say "'99 Chevy Maliboo" into {year:1999, brand:Chevrolet, model:Malibu} SSIS has a "DQS Cleansing" component. It ...
0
votes
0answers
21 views

How would you migrate a virtual 2012 sql server cluster to a virtual standalone?

I have been tasked with coming up with a plan for p2v and v2v migration. I have never done v2v migration so I'm unsure how to plan it. Specifically, from a virtual SQL server cluster to a virtual ...
-2
votes
0answers
7 views

Mysql 5.1 vs Mysql 5.5+

What is the difference between partitioning 5.1 vs 5.5 version. can someone eleborate the differences because Mysql5.1 also does Partitioning.
0
votes
2answers
33 views

Order by custom filter without certain data

I have a similar issue to the question in: ORDER BY using custom priorities for text columns ...except that I want to only get the data out if I have certain values. To clarify, we have a table ...
0
votes
1answer
23 views

Can't uninstall Microsoft SQL Server 2016 RC3

Microsoft SQL Server 2016 RC3 was installed on our server (not by me) Windows Web Server 2008 R2 64bit. Visual Studio 2015 Community was also installed. When I went to work on the server I could not ...
0
votes
0answers
11 views

hosting mysql server on the cloud or local network pc

I have a question on whether to host a mysql server on the cloud or a local network pc. In the current work environment all users log on to the cloud and work from the cloud. All the work ...
0
votes
0answers
31 views

Knowing the most juicy client!

Good evening! I'm studying business informatics in Paris and I just created an amazing database that will help the supermarket down my street to win the loyalty of its clients. We want to know, ...
2
votes
2answers
64 views

Rules related to Transaction count

I was reading the examples on MSDN for TRY-CATCH blocks. The code listing for example B is as follows: BEGIN TRANSACTION; BEGIN TRY -- Generate a constraint violation error. DELETE FROM ...
0
votes
2answers
28 views

Formatting out a column value - mm:ss.hh

I have a time in seconds and I want to convert it to the following formats possibilities: 121.17 -> 2:01.17 | 34.28 -> 34.28 | 133.56 -> 2:13.56 I am using the following: IF(Time > 60, ...
0
votes
0answers
7 views

Setting values conditionally in on conflict - pgsql

We have an UPSERT feature achieved through on conflict do set. How can I set the values conditionally in the set statement, like if(excluded.col1 is null) col1=table.col1 else col1=excluded.col1 ...

15 30 50 per page