Questions tagged as 'sql-server'

Tagged questions
2
answers

Modify a datafile, but in the OS it still has the same space. SQL SERVER

Hello people, I have the problem that I have modified a datafile: use master ALTER DATABASE tempdb MODIFY FILE (NAME = 'tempdev', SIZE = 10240) But within the OS in the path the file keeps occupying the previous space, because this happens...
asked by 30.05.2016 / 16:04
1
answer

How to get physical memory and quickly available? (Windows)

I would like to get the full and available physical memory of Windows to store them in a SQL Server table or by CMD and send them in a report. Ideally, the CMD would show something like this Memoria Total Memoria Disponible 3,509...
asked by 18.05.2016 / 16:16
1
answer

Slow Queries SQL Server Full-Text

I have created a catalog for Full-Text searches in SQL Server: CREATE TABLE [dbo].[full_text]( [client_id] [int] NOT NULL, [file_id] [bigint] NOT NULL, [page_number] [int] NULL, [contents] [nvarchar](max) NULL, [ID] [int] IDENTITY(1,1) NOT NUL...
asked by 18.05.2016 / 09:57
1
answer

SQL INSERT SELECT ordered

I have created a temporary table @TablaTurno , which I insert data in the following way: insert @TablaTurno select ROW_NUMBER() OVER(ORDER BY tturno)+@idturno as IDTurno,mci.IDCaja as IDCaja,@idestado as IDEstado,@idlocal as IDLocal,......
asked by 03.01.2017 / 17:25
2
answers

Compare two tables, one of sql server vs. another one of pl / sql

How or where can I do a select comparing two tables from different databases? Example: I have two databases, one in SQL Server 2008 r2 and one in Oracle There is a table of ventas_cabecera in both Which of the platforms...
asked by 08.03.2016 / 14:36
1
answer

Query to compare record against previous SQL? [closed]

Hello, I need to compare the records of a column in a single table. It is worth mentioning that the records do not follow an order Columna1 type int 123 1213 13313 12 12 1213 1213 Something like that should be the query: select (case when...
asked by 05.01.2019 / 20:42
0
answers

Help to replicate MSSQL in MariaDB with SymmetricDS

I am trying to configure the SymmetricDS tool to replicate a database hosted in SQL Server in a new table in MariaDB (or MySQL). I have the nodes running but the synchronization does not start because I have to create some records in the table...
asked by 03.01.2019 / 12:45
0
answers

Does not show data in the select query

good morning, I have this query for my front of users, with PDO connection but in SQL SERVER but it does NOT show me any result as if it had nothing in the user table, but when I make an insert it is possible to insert the new user . What could...
asked by 02.01.2019 / 11:04
0
answers

Change a field from NULL to NOT NULL in SQL Server

I am structuring a DB in SQL Server 2017 and I had a question about whether I could do the following in this case: I have 4 Tables: Maestro , DetalleMaestro , Seccion , SubSeccion . The structure is this: Maest...
asked by 28.12.2018 / 05:17
0
answers

Uploading data from Excel to SQL Server using BulkCopy

generate a Windows Forms application, in which I upload data from an excel file in csv format and insert them in SQL Server with BulkCopy, the problem arises when I try to copy a file with more than 59000 records, because in register 25119 all i...
asked by 27.12.2018 / 17:49