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

2.051 sql-server-2014 questions.

I have a virtual machine that was built by our IT department to host various processes. They named the computer something incomprehensible like "XYSVC105" and I am not allowed to change it. I have ...

I know it sounds crazy. However its just a thought given by DBA,s and management to check on. We are going to use LS to do migration of around 10 TB Db from 2008R2 to SQl 2014. This DB is 24*7 in ...

I have a little trouble with SQL Agent Job. It should execute program in network directory like \\x\y\z.exe. Job Step uses proxy account with credentials of a user, which can full access that ...

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've been tasked to try to recover a database which suffered from corruption (due to I/O failure, which has been fixed since). I'm not familiar with the database or what it contains. I've been given ...

I have a 2 node Always On Availability Group cluster where we are planning to take backups to a file share which will then be moved to Azure cloud. We have a service account from the Windows team for ...

Last night, I received some error messages in my SQL Server instance stating: "Logon failed for login 'sa' due to trigger execution." The instance has a number of logon triggers enabled, but after ...

I'm consistently getting variations on this error when I process the cube in my first SSAS project: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: '...

We have a table with products and a table with a current selection/assortment of products. Now need to join them create an export file by some .net code. Currently using query like this: SELECT * ...

Let's say I have a table A, that has two columns: one is an ID for ThingA, and one is an ID for ThingB. The primary key is (ThingA, ThingB). Next, I have a second table, but this time it's restricted ...

I have a SQL Server table that contains over 20 billion rows, with 13 billion rows in the last partition. The table is currently partitioned 6 ways by a "Time" field: 2011 2012 2013 2014 2015 2016/...

Let's say I have a table A, that has one column: just an ID. This is obviously the primary key. Next, I have a second table, which has an ID for table A, and then a second ID. The primary key is on ...

Configuration: LSPrimary01 - Log Shipping Primary LSSecondary01 - Log Shipping Secondary OddServer03 - This server is not part of the LS configuration, the odd man out Sean\LSServiceAccount - The ...

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 need to check the data is identical between SQL Server. For that I need following details. Let me know if this is possible. All Database Names table Names column Names Column Max Length in a table ...

I'm trying to configure a SQL Server 2014 (12.0.5000.0) instance to use a regular user account in AD and Kerberos auth. During installation the default accounts (local system ones) were used, and the ...

I found lots of ShrinkD, ghostcleanuptask, and BTree Split/Shrink in my SQL Server logs. At the time of these logged events, the performance counters showed that lazy writes were very slow, the log ...

I am trying to set up database mirroring for 10-15 databases . All these are around 1-2 TB in size. They have multiple groups and hence are scattered on multiple mount points on their primary server. ...

Recently I have upgraded my development machine to Windows 10 and SQL Server 2014 SP1 Express (12.0.4213). Then I noticed that my application sometimes crashes with a timeout exception. It is quite a ...

When accessing SQL Server with SSMS versions (2012/2014 and 2016), opening the databases list from the object explorer is really slow. If I try it using SSMS 2008 R2 on the same instance the result is ...

I Have configured the Database Mail in INSTANCE1 and INSTANCE2. Whenever i try to send a mail using the following code, i get output as "Mail queued" in INSTANCE1. EXEC msdb.dbo.sp_send_dbmail @...

We are running push transactional replication in our production environment ( SQL server 2014 (x64) Default configuration). It hangs when thousands of live transactions flows in and this continues for ...

I am looking for small advice. My database has 12 log files and x_log11 is showing file type as Rows data instead of Log and file group as primary. I am using SQL 2014. I need to change it from rows ...

I am planning migration from old SQL server 2000 db to 2014 (through 2008 extra step). I Wonder if stored procedures will work with no tweaks or arrangements are required

i need your help because we have a performance issues. I would like to update a temporary table that contains a join to the partitioned view. Schema: create schema SCHEMA1 go create schema SCHEMA2 ...

We have an old workstation running Windows 2000 that must connect to MSSQL14 running on Windows server 2012 R2. When i try to create an ODBC using: sa TCP/IP (ex. 123.456.789.012) not dynamic port ...

Error : TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to ...

This might be a simple one, but i searched a lot and unable to find one. Is there a sql query or a way i can run on registered server to find the list of all sql related services running like, ssis , ...

I've recently become a DBA of sorts for our company's ERP system. I've been making small changes to the server & improvements have been steady. One area I'm concerned with is the index fill factor....

I bumped into a use case where I wanted to write a SQL query to retrieve a row based on 2 MAX values of the table. I tried a couple of combinations but no luck as of yet. Here's a sample table and the ...

I'm trying to tweak the "Server Activity" Data Collection set as outlined in this blog post (I wrote the post, btw. Sorry--it's kinda long). It is working in SQL 2008 R2 and also in SQL 2014. However,...

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 ...

I have a problem with Transaction Log Shipping on the SQL Server 2014 edition. I have to log ship 4 databases, 2 of them are fine and the other 2 ALWAYS fail but not at first. When it fails, SQL ...

I've received a database that was previously on SQL Server 2008R2 but was just put on a SQL Server 2014 instance. There were no maintenance tasks run of any kind run on the database since 2014 (e.g. ...

Here is a simplified version of the database I am attempting to create: create table Worker ( ID int, constraint PKW primary key (ID) ) create table Business ( ID int, W int, ...

This is my issue. I've set up a test environment with SQL Server 2014, 2 named instances, WSFC and AG. They're set up like this. sqllab04\inst01 - sqllab05\inst01 - Listener VT-DB-LAB02 (port 1433) ...

I have a table with a unique key that includes an NVARCHAR(50) column (correct or not, but is there). So, when trying to insert Șc or C (doesn't matter the order of the insert) it breaks on the 2nd ...

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 ...

for this specific case, that I will try to explain below, using a table variable is performing better than not using a table variable. I would like to know why, and if possible, get rid of the table ...

I have a database DB in simple recovery mode with filegroups PRIMARY, A, B, and C. Each filegroup has a single file, PRIMARY.MDF, A.NDF, B.NDF, and C.NDF, respectively. First, I run: ALTER DATABASE [...

This week our database on a SQL2014 SP2 CU11 server started throwing fatal errors (severity 20), on the FETCH statement of code, which could be reduced to: DECLARE @dummy int DECLARE CurName CURSOR ...

I am running Availability Groups on SQL Server 2014 with one database in the group. Today, the server was responding very slowly and when I got on the server I found that the Availability Groups ...

In a previous question of mine, Is it a good idea to disable lock escalation while adding new calculated columns to a table?, I am creating a computed column: ALTER TABLE dbo.tblBGiftVoucherItem ADD ...

Today I came through the weird issue for which I need your help. Basically, I am copying a table(temp_a) into table (temp_b) using below query. select * into temp_b from temp_a where cast(...

I currently have a relatively large MTVF returning a set of data, the code I have provided below is a small subsection of what I have in place. All but 1 part of my function is built from a Cte chain ...

Receiving an error message using SQL Server 2014 & SQL Management studio 2014. Trying to create a database and its erring with message: =================================== Set owner failed for ...

while downloading sql i can that another instance named acronis is installed on my pc preventing me from re downloading sql server. showing failure in installing some features such as reporting ...

I'm using SQL Server 2014 and I have a table with one column containing a CSV string: 110,200,310,130,null The output from the table looks like this: I want to select the second column as multiple ...

I am trying to create view CREATE VIEW MySchema.NewView AS SELECT ColumnA, ColumnB FROM MySchema.MyTable But I receive error message: The metadata could not be determined because statement '...

In SQL server 2014 we are using sequences for some integer surrogate keys. They begin in the negative values counting up. Can we program the sequence to skip zero when the time comes? The reason is ...

Related tags

Hot questions

Language

Popular Tags