Stack Exchange

My SQL Server database has the initial table named Lead. This table has all kinds of info about a lead person. It has 3 foreign key columns: IndustryId, BusinessTypeId and ReferenceId. I have a problem in the architecture conceing the tables Lead and Reference. This is the script of the table Lead: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Lead]( [LeadId] [int] IDENTITY(1,1) NOT NULL, [LeadName] [nvarchar](100) NOT NULL, [CompanyName] [nvarchar](100) NOT NULL, [Phone] [nvarchar](50) NOT NULL, [Address] [nvarchar](max) NOT NULL, [DOB] [date] NULL, [IndustryID] [int] NOT NULL, [BusinessTypeID] [int] NOT NULL, [IsDeleted] [bit] N...

I have a situation for which I would appreciate any valuable pointers. I have sql transactional replication configured as below. sql01sqla ---> publisher sql01sqlc --> subscriber sql01sqle ---> distributor. I am testing if I can recover my replication flow , in the event of losing the distribution host, I have put distribution database in full recovery model and am taking log backups every 15mins. After configuring transactional replication, and ensuring a table is in sync, i stopped the agents (log reader and distribution ) on the distribution host. inserted a few records on publication and ensure the log back job of the publisher db is disabled as well. Now restored distribution d...

i have a micro sd card from an old phone from years ago. i put it in my computer an found a backup.sbf file on it. ive looked everywhere but i caot open it, it should have old pictures, contacts, call logs etc on it. Can someone point me in the right direction please? Let's block ads! بخوانید...

Books online has says this to say about query optimisation in PolyBase: The query optimizer makes a cost-based decision to push computation to Hadoop when doing so will improve query performance. It uses statistics on exteal tables to make the cost-based decision. Pushing computation creates MapReduce jobs and leverages Hadoop's distributed computational resources. My question - how and when does the optimizer collect these statistics? Inside the SQL Server relational engine statistics can be created implicitly or explicitly, they age as writes occur, and can be refreshed explicitly or during table maintenance. Are there similar strategies employed in PolyBase? Given the data may be loaded...

The operating system retued error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAbanking_sys_log.LDF'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. (Microsoft SQL Server, Error: 823) Let's block ads! بخوانید...

I have a cube, called metric_cube, with a measure of Metric and a dimension Week with the given output on SSAS from SQL Server 2014. Current Output: Week Metric ---- ------ 1 6 2 5 3 4 4 3 5 2 I want to get the cube to output the sum of the Metric for all combinations of a from Week and to Week, where the from Week <= the to Week. Desired Output: Week(F) Week(T) Metric ------- ------- ------ 1 1 6 1 2 11 1 3 15 1 4 18 1 5 20 2 2 5 2 3 9 2 4 12 2 5 14 3 3 4 3 4 7 3...

I have six SQL Server 2014 servers. I am not using TDE, Transparent Data Encryption, on any server. I would like to be able to take an encrypted backup of a database on ANY server and restore that backup to ANY OTHER server. What actions do I need to take on each server with the service master key, master database key, and certificate? I would like to use the minimum number of keys, certificates, and backup files for these keys and certificates. What actions do I need to take if I add an additional SQL Server 2014 to the group? Thank you all. Server Fault and Stack Overflow have helped me many times in the past. Let's block ads! بخوانید...

Suppose I have two simple models, Sentences and Persons, where each Person is a reference to person mention in a Sentence. Let's say they have the following normalized schema: CREATE TABLE sentence (id INT, doc_id TEXT, text TEXT) CREATE TABLE person (id TEXT, sentence_id INT, name TEXT) Let's say that a significant fraction of all my queries filter persons on doc_id. When, if ever, should I denormalize my schema and replicate doc_id as a field in Person? CREATE TABLE sentence (id INT, doc_id TEXT, text TEXT) CREATE TABLE person (id TEXT, sentence_id INT, doc_id TEXT, name TEXT) If this case, would you recommend I use triggers or some other feature with postgres to ensure consistency? ...

What I have currently done. I have created an Oracle Virtual box and install XP SP3. Install Oracle 9.0.1 on XP SP3. Restore my database on Oracle 9.0.1. Test database using SQL Plus tool. These above things work file. On my local Machine, I have already install visual studio 2015 community. And I am trying to coect Oracle database and I got the below error. Can you please help me how to sort out this issue: On the XP machine, I have a tnsnames.ora file. below is the content of that file. # TNSNAMES.ORA Network Configuration File: C:oracleora90networkadmintnsnames.ora # Generated by Oracle configuration tools. EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =...

I need the brief explanation between Multi-AZ and Read replica with exact different on it , I'm deep looking for both . ...