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

2.112 sql-server-2014 questions.

When getting table properties from a SQL 2014 server (12.0.4449) using SSMS 2014 (12.0.4100) or 2016 (13.0.15600) on any database or table I get the following text for the "Index space" property on ...

Task is to update "main_table" with Content_A and Content_B. If both run at the same time they lock each other. All queries work as expected and can be executed by maintenance plan (let's call them ...

I have a query where using select * not only does far fewer reads, but also uses significantly less CPU time than using select c.Foo. This is the query: select top 1000 c.ID from ATable a join ...

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

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 have two tables with identically named, typed, and indexed key columns. One of the them has a unique clustered index, the other one has a non-unique. The test setup Setup script, including some ...

We have a reporting SQL (2014 R2 Enterprise) system with a Reporting and Staging DB on it. The reporting DB is pre-provisioned at 4 TB across 8 data files. Currently it contains just shy of 1 TB of ...

SQL Server 2014 (if it matters) When I am migrating SSIS packages and jobs between environments, I need to update the /ENVREFERENCE parameter to the command for each job step. Is there anyway to ...

I struggled with how to ask this question. This is from a piece of software that we have used for well over a decade. For the life of me, I can't figure out why it works. There are 3 objects in ...

Scenario: SQL Server 2014 (v12.0.4100.1) .NET Service runs this query: SELECT name, base_object_name FROM sys.synonyms WHERE schema_id IN (SELECT schema_id FROM sys.schemas ...

We have a archival job which is set up in all three replicas which are part of AOAG (SQL Server 2014). Here the connection string is AOAG Listener (which connects to only Primary Replica). I have ...

I am tasked with troubleshooting a stored procedure which normally runs for less than 100ms and sometimes it takes about 800ms to a sec. Now I have experience troubleshooting SQL but not at this ...

I'd like to work around instances where a database were changed to simple and then reverted back to full or bulk logged recovery models. This is for my backup maintenance plan, as obviously any ...

On a dev machine running Windows Server 2012 R2, I just upgraded SQL Server from 2012 to 2014. Using SQL Server Management Studio 2014, when I right-click a database and go to Tasks -> Restore -&...

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 have a partitioned table which is partitioned based on col1 int. I also have a covering index for the query that I am trying to troubleshoot. https://www.brentozar.com/pastetheplan/?id=BkNrNdgHm ...

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've had back to back Saturdays where our SQLServerAgent (Test Instance) has stopped with an Event ID of 17052. The times do differ as the initial week was 21:00 and last Saturday was 19:00. Having ...

I am going nuts trying to understand the meaning of the different time columns in the sys.dm_hadr_database_replica_states system table. We have a three node Always On Availability Group, where two of ...

I have a query the first part of which looks like this - With CTE AS ( select DISTINCT A.col1, A.col2, . . . from tableA A JOIN tableB B ON ( ...

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

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

Performing a large index reorg on a mirrored SQL Server 2014 TDE database creates a large redo log on the mirror and the mirroring monitor displays an infinite restore time. The exact same process ...

I have two SQL Server DB instances on the same machine with one hosting a replica of the other. In addition, I have transaction replication setup for all tables on the main instance to the replica. I ...

Fail over not happened from AG wizard, selected "select new primary replica" and it is not allowing to move next step to "connect to replica" where to look to identify the cause

I need a query to get the user databases not added or configured for Always On Availability Groups in SQL Server 2014.

I'm in the process of re-writing our maintenance plans (backups atm)and as part of that, I'd like to encrypt our backups for security purposes. I have managed to get the process working but have ...

We have a 2 Node AlwaysOn Availability Group in SQL Server 2014 running on Hyper-V (VM). Current setup: SRV01: Role: PRIMARY READABLE SECONDARY: NO SRV02: Role: SECONDARY READABLE SECONDARY: ...

Sql Server Database on Azure (Sql Server 2014/12.0.2000.8) I have numerous stored procedures that all had the same basic select properties and joins, so I decided to generate a view that encompassed ...

I have three versions of the same select query (SQL Fiddle here): CREATE TABLE MainTable(ID INT) CREATE TABLE SubTable(ID INT, Type CHAR(2)) CREATE TABLE SubTableType(Type CHAR(2)) INSERT MainTable ...

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

Every time something fails the publish, assuming it passes the preview generation, the error line and executed script sample are completely useless at helping me trace the source of the error, since ...

I am mainly a .NET developer using Entity Framework ORM. However, because I don't want to fail in using the ORM, I am trying to understand what happens within the data layer (database). Basically, ...

I have an execution plan which when I open in Sentry One Plan Explorer has areas dimmed out. However, when I check the cumulative costs, these are the same areas that contribute to 99 pc of the ...

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'm trying to copy data from one table to another table in a different database. After right clicking I have got an option Tasks, under it there are only the two options: Export Data... Import Data......

I'm studying about "Transaction and concurrency","Deadlock" and related stuff for some time. I have a question regarding this matter. The situation is that two records (AccountNumber AW00012597 and ...

By using a mix of several PoSH scripts I managed to get a working script that generates, copies and remotely executes a script to create the basic structure for a given database with all its objects, ...

I'm currently trying to get an application to use memory optimised tables instead of temporary tables, but have hit an issue. The issue is related to permissions, as users of the application are only ...

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

SQL Server 2014, Std Ed I have read that percent_complete in dm_exec_requests does not work for CREATE INDEX, and in practice, percent_complete sticks at 0. So that doesn't help. I currently use the ...

I'd like to be able to calculate the amount of free space I have for offsite backups so I can prevent any jobs from running should there not be the relevant space and also be able to send alerts when ...

I'm having some issues with SQL backups which are being written to an SMB share on a AWS Storage Gateway Appliance from an EC2 SQL Server. I'm consistently getting the same error in the SQL Event log ...

We have a 2012 Windows failover Cluster set up for SQL Server 2014 on VMWare ESXi, 6.0.0, 3620759. A couple weekends ago, our Server Admin made some updates to the the UCS Manager software, which in ...

We have transactional replication setup in our environment. Recently I installed latest service pack (SQL Server 2014 sp2) to lower environments. After the upgrade we are seeing so many issues with ...

I have a table table A that is being created as part of a transaction. One of the columns in this table A has a foreign key reference to a column(columns) in table B. Now another transaction is ...

I have the following table with student enrollment data: CREATE TABLE [dbo].[Enrollments]( [SequenceID] [bigint] NULL, [SchoolYear] [int] NULL, [StudentID] [varchar](8) NULL, [...

Does MSSQL support an operating mode on the failover partner / mirror that is functionally equivalent to Oracle database's Snapshot Standby mode? ie A temporary active copy of the replicated ...

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

Related tags

Hot questions

Language

Popular Tags