5
votes
1answer
139 views

SQL Server 2012 Crashes and service doesn't restart

We've been having an issue with our SQL server lately. It seems that the server will run out of memory and then crash. For some reason, the sql service wouldn't restart. I would have to go and ...
6
votes
1answer
1k views

Query Plans Change Performance Worse in SQL Server 2014

We recently upgraded our server from SQL Server 2008R2 to SQL Server 2014. We have a query that ran fine in 2008R2 but now in 2014 runs incredibly much slower and has a bad execution plan. I've done ...
0
votes
1answer
69 views

Problem with UNION ALL

I have to process 200 points (lat, long) to calculate the minor distance of same object (street in this case). So, I made a simple query to obtain 1 result, and replicate the same to the other 199. (...
0
votes
1answer
2k views

SQL Developer - trying to import an excel file into a table

I'm trying to import an excel file into a table. The excel file has dates in the following format: 20/08/2008 12:00:00 AM and I am telling SQLDEV the following: DD/MM/YYYY H24:MI:SS AM To import the ...
1
vote
1answer
115 views

Finding same values and updating rankings

thank you for taking the time to look at this. I have a simple table that I am trying to update based on the entries. table name is TOPUSER and there us a field called tu_total and tu_rank, I would ...
2
votes
1answer
620 views

How to reinitialise /var/lib/mysql files?

Due to a mishap I deleted the entire /var/lib/mysql directory. Since the database did not contain anything important, I do not want to go through the hassle of restoring it from an old backup, but ...
0
votes
1answer
123 views

Error using view to limit data access between databases in SQL Server [duplicate]

I am trying to limit user access to data through a view. I have a database full of replicated data that I do not want the users to be able to access, I also have a reporting database in which I will ...
2
votes
3answers
388 views

How to use “BACKUP DATABASE”, but the database is in a different server.? [closed]

We have 3 servers ( SQL SERVER 2008 ). Is there a way to backup a database, connected in a different server? Example: i'm on SQL1. I want to do something like this: BACKUP DATABASE [SQL2]....
4
votes
1answer
446 views

SQL Server 2008 R2 Lockup for 10 minutes

Last Saturday night, our site went down for about 10 minutes. Analysis of the logs showed the following errors on the principal SQL Server (in a mirrored pair), during the outage and not outside the ...
1
vote
1answer
141 views

Disk Read IO Throttle not showing in perfmon Windows Server 2012 r2

I am working on Windows Server 2012r2,SQL Server 2014. I am trying to create a new data collector to review Disk IO in perfmon. When I get to the step to add the available counters there is no Disk ...
0
votes
1answer
442 views

SQL Server Data File/Log File poor performance

I've been asked to look at a database/application server that's "performing slow". No one could really tell me what was performing slow (except for the database backups) so this has been a discovery ...
0
votes
1answer
53 views

Connecting 4 tables - finding some differences between them

I have 4 tables in a Oracle database: SOL_PUBLIC.SOL_CHEST@RACDB (PUB): ID ... 100 ... 200 ... 300 ... SOL_PUBLIC.COORD@RACDB (PUB): ID FK_ID_CHEST x y 1 100 11 11 2 200 ...
1
vote
1answer
157 views

Querying XML with Unicode data

I'm trying to select attribute value from XML column using XPath with a parameter that can be a Unicode string. Could you please tell me how to make these two examples work? create table #test ( ...
2
votes
1answer
145 views

SQL Server tempdb rogue temporary tables

I've got some rogue temporary tables being generated which is starting to cause disk space issues. The database creating these tables is fairly large and I'm unsure what stored procedure/function etc ...
-2
votes
1answer
183 views

How to determine that SQL Server is really lacking memory

We're running SQL Server Express for our project. I'm trying to prove that we have to move to Standard or Web version of it. Just because I suspect that because of Express edition limitation it can't ...
-6
votes
1answer
329 views

How to select only few columns from a table in database? [closed]

I have a table which consists of around 200 columns where name of each one is col_i (i=1 ,2,..200).Suppose I have to select only first 50 columns, how should I proceed? I found about concat() function ...
1
vote
2answers
180 views

cannot access my DB server on ubuntu

server OS: Ubuntu 14.04 MYSQL Server version: 5.5.43-0ubuntu The output of: select User, host from user is: db % db localhost In my /etc/mysql/my.cnf, I made sure that bind-address is ...
4
votes
3answers
13k views

T-SQL - How to split (char separated) string into rows and columns

What is the best way to split a char separated string into rows and columns? Here is my input string: !1;100;10;200;0;500;2;1000;30!2;100;3;500;1;2000;5 And here is my desired output table: Id ...
1
vote
0answers
110 views

ETL flow in Fact tables

I've got a simple theoretical question... If we discuss the principles, elements, design and implementation of a typical ETL flow for a dimension table then, in my understanding, (in short) I'd say ...
2
votes
1answer
311 views

How to check/know the highest run queries

I would like to gather statistics on the highest run queries in my database. For that I need to know how I can track queries so I can create views or materialized views to cache the results of the ...
1
vote
1answer
84 views

Duplicate records referenced across different databases

I have a table holding 'People' data (about 70K records) that coexists with an 'Address' table so there's one AddressID per every person in the 'People' table. The idea was to centralize the data in ...
0
votes
2answers
702 views

Purge ARCHIVELOG automatically

I have an Oracle 10g XE installation (exclusively used for development) which has accumulated so far 14 GB of files at ...\oraclexe\app\oracle\flash_recovery_area\XE\ARCHIVELOG. I do need that space ...
0
votes
0answers
108 views

pt-online-schema-change with statement based replication in MYSQL

Is it possible/safe to use pt-online-schema-change in a Master slave environment where as the way replication is setup is statement based(SBR). What is the better way of doing it as currently I have ...
3
votes
1answer
528 views

SQL Server DOUBLE keyword

There is a reserved keyword DOUBLE in SQL Server, but I know that it's not a data type (other languages' double is float or real in SQL Server); does anyone know why this is a keyword? I've tried to ...
2
votes
1answer
128 views

sql server listen on multiple ports

I have a push subscriber in transactional replication (and the distributor is the publisher), in this subscriber I configured sql server port on 1433, and I have a web application which connect to ...
2
votes
1answer
101 views

Innobackupex apply-log should be done before emergency restore or after each backup?

Basically Percona Innobackupex consist with three steps: 1. Backup 2. Apply log 3. Copy back restore during emergency My question: When should I do apply log? Is it after each backup or before ...
1
vote
1answer
161 views

Data type and Operator type Errors

i am following learn sql the hard way tutorial, in tutorial tutor suggest to use sqllite 3 but im using MSSQL 2008 and i have a problem, tutor ask from me to find something using AND or OR operators, ...
0
votes
1answer
14 views

Couchbase Ghost entry - Have it in view, not in data itself

I have a 4 server setup. In them I have a view like this: function (doc, meta) { if(meta.type == "json") { if(doc.type && doc.type == "saveDocument") { emit(meta.id, ...
1
vote
1answer
276 views

fn_dblog not showing up deleted table data

I unintentionally deleted 4 rows from a table. I tried to fetch back the deleted data using a stored procedure (got from internet). However, I was able to see my data in the result of stored procedure....
5
votes
1answer
257 views

Server roles in SQL Server 2016

There are 3 new server roles in SQL Server 2016: mediumrc largerc xlargerc Any idea what these are for? Google doesn't give any information about these.
0
votes
2answers
83 views

DB Re-index failure

I'm managing a DB (SQL Server 2008) with a two step SQL Agent job that is triggered to initiate a DB Re-index. However on the second step the SQL Agent job fails. Where can I find logs that detail the ...
1
vote
1answer
353 views

CLR Assemblies and SQL Server Availability Groups

I have a SQL 2012 Availability group. On that I also have a database with a .Net assembly that is using PERMISSION_SET = UNSAFE. CREATE ASSEMBLY drawing FROM C:\Windows\Microsoft.NET\Framework\v4....
1
vote
1answer
38 views

Problem passing rows results to columns names

I have a table with following data: ID IDALUMNO ALUMNO IDTIPOEVALUACION TIPOEVALUACION NOTA 1 682 ALVITEZ MIRANDA, KAREN LIZET 1 PR1 ...
0
votes
0answers
345 views

Can't connect to an Active Node in an Active/Passive cluster

While being logged into an active node SQL Server 2012 node, I tried connecting to it from within the SQL Server Management Studio but was unable to do so. I tried the fully qualified name and the IP, ...
9
votes
1answer
401 views

What is the different between compression on the PK vs. on the Table?

Data compression can be set on the table: CREATE TABLE dbo.SomeTable( SomeId [bigint] NOT NULL, OtherId [bigint] NOT NULL, IsActive [bit] NOT NULL, CONSTRAINT [PK_Some] PRIMARY KEY ...
1
vote
2answers
87 views

Choosing what table fields to partition on

I'm having a tough time deciding whether or not to partition my table based on a unix timestamp or by a descriptor attribute. It's just over a billion rows currently. My table basically contains: ...
2
votes
0answers
129 views

SQL User Entitlements - Combining Multiple IDs

New to SQL, first time poster. I searched a bit for what I was looking for. Couldn't locate. I appreciate your help...I'm still learning terms and commands. Consider this: User XYZ has access to ...
0
votes
2answers
27 views

Find constraint disabled in SQL Server

i'm doing an audit of constraints in SQL Server. How to find all constraints that are not enabled? This, after using the next declaration: alter table mytable nocheck constraint all
0
votes
1answer
293 views

Trying to phpMyAdmin import a database with a different name

I've been searching for answers and couldn't find anything suited for my exact situation : I have a magento website and i'm trying to "duplicate" the website into another one selling other types of ...
1
vote
2answers
121 views

Large database design

I am new to database design and despite my research I can really only find basic examples on design which does not help for my situation. Currently using MySQL The problem I have is as follows: I ...
-1
votes
1answer
307 views

Permission Denied on a database created by the same user

I run this command: psql --username=openerp --dbname=sf_template_20150608111121 --no-password \ --command="update pg_database set datallowconn = false \ where datname = '...
0
votes
1answer
36 views

Postgres DB user permission

I'm logged in as a user in postgres with PgAdmin tool in Linux connecting remotely but I don't think the user has enough rights. I'm a MySQL experienced user but not so much in PostGres. When I select ...
0
votes
2answers
605 views

Analysis Services not allowing other/remote connections other than localhost

Analysis services not allowing any connections except localhost. Authentication box is disabled and only allow windows authentication. How can I connect to different remote analysis servers using sql ...
3
votes
2answers
147 views

Online index rebuild snapshot location and impact of filling index drive

My understanding of a rebuild index online operation is that the index will have a snapshot taken and the rebuild is started on the snapshot index. My question is where does the snapshot index ...
-1
votes
2answers
77 views

Getting a total value for items obtained in the current quarter

I've been working with MS SQL Server Management Studio and have a problem I can't fix. I am currently able to get the total for a set of values (Volume and Activity) from my SQL Server database. ...
-1
votes
1answer
362 views

Unable to start SQL Server Agent

We are unable to start SQL server Agent and it fails with below error: SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)...
0
votes
1answer
112 views

SQLite optimizations for possible huge data storage

I want use SQLite database as the storage for possible huge data size, I need some comments about optimization to keep stability (like unexpexted epic fails, BSOD for example) with fast access speed. ...
0
votes
1answer
182 views

Joining two database tables into one

I have a database with two tables. Each table has different structure but they do share few common fields. Simplified example: Table1 field structure: Field1, Field2, Field3, Field4 Table2 field ...
3
votes
1answer
177 views

MySQL Workbench team strategy

I'm considering to use MySQL Workbench at work, mainly because of the modelling tools and to easily sync the development and the production DBs. I work with another developer on the same project, and ...
0
votes
2answers
1k views

Percona xtradb cluster node2 won't start

I have configured Percona Xtradb cluster 5.6. The first node starts fine when bootstrapped, but the second node seems to have an issue with this variable setting: wsrep_provider=/usr/lib/...

15 30 50 per page