sql-server-2014's questions - Chinese 1answer

2.178 sql-server-2014 questions.

We are not using SQL Enterprise Edition. And we have to do audit trail by ourselves. Throughout the process, we discover that the data we store (json string) is really few times the sizes our original ...

I had a question on Log shipping Manual Fail over Let me explain about environment, Primary Server A (with Cluster setup A-P Mode) Secondary server B(DR server standalone). We had enabled Log ...

I'm having a problem allocating payments to invoice lines. We’re using MsSql 2014 Data looks like this: Invoice lines table (sales): lineId invoiceId value 1 1 100 2 ...

I am trying to troubleshoot the below deadlock situation Looking at the deadlock xml, both session are using read committed isolation level. Question is, in read committed isolation level, in this ...

I have 2 table in my database. Table #1 ------------------------------------------------------------------------- | name | family | phone | email | gender | phone2 | address | birthdate | -----------...

An application server database we use contains many columns (300 +), a lot of these columns contain a default value defined by the application (e.g. 0 or ''). These tables need to be ported across to ...

Tempdb is growing and it's all version store data. When I run: select hostname,elapsed_time_seconds,session_id, transaction_id, is_snapshot, blocked, lastwaittype, cpu, physical_io, open_tran, cmd ...

I’ve been asked to look at a SQL Server 2014 Enterprise VM with 6 cores MAXDOP set to 3, 256 GB Ram. The CPU is running very high but there isn’t enough activity going on to justify the CPU workload....

We have an environment like below: Datacenter 1: FCI -Sqlinstance01 Datacenter 2: FCI- Sqlinstance02 Datacenter 3: FCI- Sqlinstance03 There is database mirroring set up between 01 and 02 and Log ...

We have an existing failover cluster that I would like to have the tempdb in local drive. I'm not sure how to proceed. My thought process is below: Create two drives on each node one for tempdb and ...

As part of my data warehouse project, I'll be transferring data from our OLTPs to the Data Warehouse. Some of the tables are long and wide so obviously, I'll only be transferring required columns. To ...

For a project I'm attempting to move data from a view in source to a table in destination. And this will need to be done periodically. The quickest way to do this seems to be a SSIS package (as this ...

Why would an availability group's number of worker threads in an HADR pool increase well beyond minimum usage of "typically, there are 3–10 shared threads" per replica? In one case we've observed ...

Simple table with an identity table as a clustered primary key. We unexpectedly hit the max value for the column, so I requested our DBA re-seed the table back to 0 to give us some time to examine ...

On Microsoft SQL Server 2014 (SP2-CU3) (KB3204388) - 12.0.5538.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor) almost all events have ...

I manage a database server that supports a C#/VB.NET application and we've had a lot of CPU usage problems. I am using the following dmv query from Glenn Berry at SQLSkills: SELECT TOP(50) DB_NAME(t....

I want to allow a non-admin account the ability to query a linked server. If I create a linked server with the following under a sysadmin account like below. EXEC master.dbo.sp_addlinkedserver @...

Microsoft's two main sources on RBS do not mention SharePoint explicitly: https://technet.microsoft.com/en-us/library/gg316768(v=sql.105).aspx https://docs.microsoft.com/en-us/sql/relational-...

We migrated many instances of SQL Server 2008/R2 on Windows 2008R2 and 2012 on Windows 2012 to newer Windows 2016 with SQL Server 2014 and 2016 versions. The old clusters were configured with either ...

Web Application is High school record management system (HSRMS). Users of the application are High school management (Normal Users) Data verifying users (Admin) User group 2 will allow the User ...

Say we have a production system with several databases encrypted using TDE and a self-generated certificate. We regularly need to take this database and refresh our non-production systems. This ...

We are currently working on a project to move all of our disparate DBs (MySQL, Oracle, older versions of MS SQL) to SQL Server 2014. So far, pretty much everything has gone smoothly, however, there is ...

I get an error when I run this query: SELECT dependencies.referencing_id as object_id, dependencies.referencing_minor_id as column_id, dependencies.referenced_id AS ...

I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box. Regarding the ...

I'm trying to set up transactional replication of a fairly large database (Business Activity Monitor database from BizTalk Server 2013R2) (>500 GB). I have an active/passive cluster which holds the ...

Our MSrepl_errors table is around 15GB and got records from the beginning of time. What is the correct way of cleaning up this table. Do we simply delete from it? Edit The distribution agent clean ...

I have created log shipping and the primary server is also used for transactional replication. Now after creating log shipping I have noticed the publisher shows up on the secondary and it wont let ...

Under Windows 2012 R2 Standard (Fully Updated): When trying to start my SQL Server 2014 Service I get in Application event viewer: "there is insufficient system memory in resource pool 'internal' to ...

We have a SQL Server 2014 with 140 user databases, each of which have approx. 180 tables. A maintenance plan was scheduled for once a week but it was discovered that the Check Database Integrity (DBCC ...

I have 40 databases in AlwaysOn group.I need to move MDF file of 1 database to a new drive.Please help me with your suggestions SQL Server Details: 12.0.2269.0 RTM Enterprise

Recently I realized by default, scripting the database does not including indexes, and I have to change the option every time. Could anyone please explain the reason? Is there any insight about this ...

I am trying to track a slow performing SQL and I am trying to capture the parameters that are passed in for the slow runs. I am tracing module_end and rpc_completed. The stored procedure is run as ...

Good morning! All my previous jobs have been single instances. We currently have a client that has a production, backup (secondary) and a test server. The have a particular type of job that runs that ...

I am completely new to Transparent Data encryption and please help me on below questions related to enabling the TDE on existing PRODUCTION Databases. Primary Question: What are the things which I ...

Currently I'm working with windows credentials, when i trying to create a user with SQL Authentication encountered the attached error. I have seen it is due to empty login name. How to resolve this ...

I am writing a custom JSON parser in T-SQL†. For the purpose of my parser, I am using the PATINDEX function that calculates the position of a token from a list of tokens. The tokens in my case are ...

Recently we've been having high disk latency issue and wanted to benchmark one of our mount points on a preprod server to get an idea of how much IOPS, Throughput and latency our SAN is capable of. ...

I'd like to reduce database size by removing some data that is not useful anymore from a SQL Server Express database - 10 GB database size limit. So I have a table that is 5783 MB and has 4 columns ...

If I have multiple insert into commands going and some of the column names are the same, do I still state them? For example: insert into MOVIE (MOVIE_ID, TITLE, RATE) values ('00001','Titanic', '...

I was reading ALTER PARTITION FUNCTION best practices which says - Always keep empty partitions at both ends of the partition range to guarantee that the partition split (before loading new data) ...

We have a stored procedure which calls an SSIS package from the SSISdb database. It works when run as myself using my domain account, however the VB6 application which will call this connects to the ...

I have a custom eCommerce web site, using third-party web services, that is processing dues payments for our members. Twice in the last day a specific data row for 50,000 users is having two of the ...

I get this error message occasionally when I execute a stored procedure that pulls information from multiple linked servers and aggregates the data. It looks similar to what I have below. DECLARE Cur ...

I'll describe the problem in terms of loading a fixed number of trucks with orders, as evenly as possible. Inputs: @TruckCount - the number of empty trucks to fill A set: OrderId, OrderDetailId, ...

I am attempting to query a maximum of 65,000 records in a database (minimum of 0). The server is using MS SQL Server 2014, and I have no way to change the hardware on the server. Schema [Id] (PK) ...

Ive been searching to find any script or a method for below: Case1 : we have litespeed backups running without checksum and verify backups taking x mins for an instances with TBs of dbs Case 2: we ...

We have an oltp application and I am trying to troubleshoot why insert into one of our table is taking close to a second. Not all inserts are taking this much time but there are some which does take ...

I've been doing some reading on the improvements that Trace Flag 2453 can give on the performance of Table Variables by maintaining statistics and was wondering what would be the reasons you would ...

I ran DBCC CheckDB and got some consistency errors in the database. In an attempt to recover all the data I have exported out all the data from the database to a new database except for one table. ...

Can I get some help to understand below questions: We have a ETL job running (Datawarehouse Server) and weekly index operations (Production Server)(Ola Hallengren script) , below questions are ...

Related tags

Hot questions

Language

Popular Tags