Questions tagged [sql-server-2012]

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

615 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
2k views

SQL Maintenance Plan 'Could not find part of the path' - where is it getting the path from?

I have a SQL Server 2012 maintenance plan which backs up all of the databases. Today I had an issue with a failed backup which I was able to resolve by viewing the detail in the 'Log File Viewer' ...
3
votes
0answers
275 views

SQL Server 2012 Resource Governor and memory used by CLR

In SQL 2012 memory used by CLR is now part of what is controlled by "MAX Server Memory" a) Does Resource Governor in SQL 2012 Enterprise (MAX_MEMORY_PERCENT for resource pool) governs CLR memory? b)...
3
votes
0answers
261 views

custom population of full text index

Is there any way to populate a full text search index without storing the backing information in the database? I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
3
votes
0answers
994 views

SqlDependency permissions

The db is SQL Server 2012. All data tables are in the dbo schema. All data access is done via stored procedures in a different schema (user rt). I want to add query notifications for some tables, so I ...
3
votes
0answers
188 views

How to use a foreach loop with project deployment model

I have a SSIS project that is configured to project deployment model, within this I have two connections one for a flat file and one for a sql db. Both connections are in project mode. Now I want to ...
3
votes
0answers
655 views

Uninitialized Merge replication subscription

I have 3 separate SQL Server 2012 databases running on 3 VM's. I have successfully configured one pull subscription to the distributor but when I add a 2nd subscription on another SQL Server the ...
3
votes
0answers
302 views

SQL Server fulltext_semantic_languages

When trying to install a semantic search example, I'm running into a problem. There are some steps in the example to check if the 'new' Semantic Search and Full Text Search are installed. ...
3
votes
0answers
1k views

Event Notification / Service Broker - no inserts anymore, “previously existing connection with the same peer”

I've been working on getting several servers to feed Event Notifications to a central server. Had everything working yesterday, then managed to break it. Dropping and recreating the endpoint/route/...
3
votes
1answer
100 views

Does MERGE updates when not needed?

In SQL Server 2012, Does a merge statement like this : WHEN MATCHED THEN update SET A.len = B.len updates a row even if A.len equals to B.len ? Or does the SQL SERVER knows to ignore this ...
3
votes
1answer
1k views

Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012

I have two local SQL Server instances running on my local machine. The first is SQL Server 2008 R2 Enterprise Edition (named MSSQLSERVER) and the 2nd is SQL Server 2012 Business Intelligence Edition. ...
3
votes
1answer
2k views

SQL Server performance issue (CXPACKET wait type)

I have a performance issue with production SQL Server 2012 which has 24 cores and 32 GB of RAM. From wait type I can see CXPACKET is on the top based on the following SQL Server metrics, should I ...
3
votes
1answer
1k views

SQL Server 2012 - Large backup file size

We have the following setup: Once a week (Sunday at midnight), a full database backup is performed. A new BAK file is created for this purpose, let's call it Backup1.bak. From then, a transactional ...
2
votes
0answers
84 views

Database stuck in recovery pending but can't set to ONLINE or EMERGENCY

We have a database server who's data drive filled up see error log: Error: 17053, Severity: 16, State: 1. D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MyDb_log.ldf: Operating ...
2
votes
0answers
29 views

How to handle normalizing the concept of a grid, and also plan for data versioning?

I have inherited a database that has a normalized structure, except for its data tables which are aggressively denormalized. Our system mostly renders grids into a browser, and the previous developer ...
2
votes
0answers
53 views

Recommendations around managing large amounts of data that needs to be aggregated (SUM)

I am looking for alternatives to redesign a part of our system that needs to perform cumulative SUMs over large data sets of rows based on user and dates. How the system works We are running a web (...
2
votes
1answer
78 views

Spike and time out errors every x th minute

I have very complicated situation here. Application team was reporting that they see spikes and errors every 20 mins. We checked what was running and found log backups. So we tuned log backups using ...
2
votes
0answers
36 views

To cluster or not to cluster? That is the question!

I have a table with just one (nvarchar) column for tracking IDs that have been used, to ensure they aren’t duplicated. Should I use Clustered or Non-clustered Index for this? The only two operations ...
2
votes
0answers
871 views

Use LIKE in column with arabic

I have a SQL Server 2012 DB with a column that includes Arabic text. The column is nvarchar(MAX) with collation Arabic_CI_AI_KS_WS. To test if LIKE searches are working I copied some of the text ...
2
votes
1answer
137 views

SQL PROFILER Replay statistics event interpretation

I tried capturing a replayable trace on a SQL Server 2012 production environment and then replay it against a SQL 2016 test environment. After doing so , I got the following results : Can anyone ...
2
votes
0answers
227 views

SQL server never uses all the memory

I have 1 TB Dynamic Axapta DB on the SQL Server 2012. I have 128 gigabytes of memory. Version : Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Oct 19 2012 13:38:57 Copyright (c) Microsoft ...
2
votes
0answers
183 views

Poor SQL query optimization of Recursive CTE with iTVF, environment specific

I'm developing a recursive CTE which utilizes an inlined TVF. In our dev environment, the recursive CTE executes exactly as expected. In our production environment, the first iteration of the CTE ...
2
votes
0answers
55 views

Queries running on snapshot database that causes high redo queue

I am trying to troubleshoot mirroring issue where we are getting threshold exceeded for unrestored log too high on mirror server. On the mirror server we have database snapshot created for the ...
2
votes
0answers
378 views

StartTime and EndTime for the Attention Extended Event

The documentation says that the "Attention" extended event class has StartTime and EndTime as part of it. But I can't seem to figure out how to get at it or record it... Here is what I am using to ...
2
votes
0answers
524 views

How Can I Ignore Partition Schemes in my VS SSDT Database Project

We use SSDT in VS 2015 to manage our database project code. Recently, we've been implementing partitioning on some tables in databases that are managed with SSDT. I need to include the partition ...
2
votes
0answers
57 views

Veeam HotAdd causing Worker Thread Exhaustion

I have a SQL 2012 Always ON AG with 2 nodes and a file share witness. We have 207 Customer DBs in the AG on a box with 12 Cores and Instance configured for 60 GB RAM. I have 1 Secondary configured ...
2
votes
0answers
420 views

Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)

sp_spaceused, when executed without any parameters, produces 2 result sets database_name, database_size, unallocated_size reserved, data, index_space, unused Usually when you execute some SP, you ...
2
votes
0answers
73 views

Linked servers not ignoring case after reboot

We have a SQL Server 2014 database with collation SQL_Latin1_General_CP1_CI_AS, which is case insensitive. It is linked to another SQL server database with the same collation. The second database ...
2
votes
0answers
500 views

Master Database Occasionally Gets Corrupted

I've been experiencing an issue with our Windows Update server where the master database appears to occasionally get corrupted at random times. We're running a Windows Internal Database (which seems ...
2
votes
0answers
2k views

SQL Server CLR 'Failed to create AppDomain' debugging

I am having the 'Failed to create AppDomain' issue in a production instance. This is typically attributed to memory pressure(not the case here) or pending .Net updates. The OS has been restarted and ...
2
votes
0answers
67 views

Need Clarification of SQL Server Blocking-Process lastbatchstarted

My understanding is that a SQL Server batch consists of 1 or more statements that will be executed sequentially. The last batch time should be the time when the batch was started. Also, multiple ...
2
votes
0answers
451 views

Column attributes error while importing to MS Sql Server from MUMPS

I'm attempting to import data into MSSQL from a MUMPS database. I've configured an ODBC connection to the MUMPS database and can see the expected table structure in the MSSQL Import / Export wizard. ...
2
votes
0answers
115 views

Permissions on views/stored procedures and the referenced base tables in linked servers

I need help setting up security division between SELECTing and EXECUTEing from views and stored procedures and access to base tables referenced by those objects on linked servers on SQL Server 2012SP3....
2
votes
0answers
32 views

SQL Server 2012 - Is There a Log That Captures DB Maintenance Type Activity?

I had a backup maintenance job setup for all system databases. I also have another job that sends me an email whenever a job fails. After receiving notification of the system database backup job ...
2
votes
0answers
244 views

Unexplainable behavior of SQL Server under Windows Authentication

The versions affected are SQL Server 2005, 2008, 2008 R2. If we grant CONNECT SQL to public server role, any AD account can log in to server. So we'll have all the AD members on the server without ...
2
votes
0answers
3k views

BCP Error SQLState = S1000, NativeError = 0 , Unable to open BCP host data-file

I am trying to execute the below BCP query in my TEST Server, where BCP has a connection string to the production DB, so my destination folder is in my Test Server and I am getting an error, I think ...
2
votes
0answers
464 views

Databases in 'Recovery Pending' and 'Backup:CommitLogArchivePoint' not committing

I've got a bit of an odd one that I'm wondering if anyone's seen before. Last week I had a bunch of databases showing as 'Recovery Pending'. Some digging at the time found that SQL was ...
2
votes
1answer
396 views

Add shared folder to AlwaysOn AG Failover

We have setup a 2 node Synchronous AG with automatic failover to provide HA for our ERP application (Dynamics GP) The GP desktop client loads a number of shared reports and dictionaries from a file ...
2
votes
0answers
894 views

SSAS different results between database process-full and dimension process-update

I have an Analysis services database with several cubes in it. We have a nightly job that extracts data from our source database to some staging tables, and another that performs a "Process Full" of ...
2
votes
0answers
1k views

SSIS Script Component as Source AddRow Null Exception

I have a SSIS package with single Dataflow Task. The first step in this Dataflow is a Script component setup as a source, the default 'Output 0' has been renamed to 'Out' and it has a single column '...
2
votes
0answers
110 views

Quite possibly a stupid and long authentication question

First off, I am not remotely a DBA. But I'm basically responsible for the application and we don't have a DBA, so here I am. There's two separate errors that may be related but occur at separate ...
2
votes
1answer
459 views

NUMA configuration

We have clustered servers, each of which has 32 CPU cores and 512 GB memory. The cluster is home to 7 instances of SQL Server 2012 Standard Edition. With Standard Edition allowing a maximum of 64 ...
2
votes
0answers
889 views

SSIS or SQL Agent weird error

We are like SSIS heavy shop and there are more than 30+ packages that runs in that 24 hr cycle. However, lately every few other weeks we are noticing that the packages fail to execute and throws out ...
2
votes
0answers
207 views

Why is our select statement using a predicate clause with string concatenation running faster than our select statement using a single field?

We have been working on an application that utilizes a view with several tables in our database. This view is utilized throughout the application, and although significantly more complicated than the ...
2
votes
0answers
39 views

Securing SQL 2012 column data strategy

I am working on a project that requires a column that is currently in plain text to be encrypted. As part of the project i still need to be able to run a SP from SSMS and the plain text data. I was ...
2
votes
1answer
335 views

SS2012 Export Wizard Access is denied

When a user exports to a flat file she gets an access denied error. The wizard allows her to preview the data so she has access on the db side. From Windows she can create a new file in the target ...
2
votes
0answers
88 views

Mysterious alwaysOn breakage on SQL Server 2012

I've just bumped into a new situation regarding alwaysOn availability. We have a setup with a large database (terabyte range) with one primary and one secondary replica. Geographically the servers are ...
2
votes
0answers
313 views

Data Security for SQL Server 2012 Standard Edition

I just wanted to know what my options were for securing and encrypting data for SQL Server 2012 standard edition? We originally were going to use Transparent Data Encryption for restful encryption, ...
2
votes
0answers
2k views

Troubleshooting Preemptive_Xe_Dispatcher wait type

While looking for a reason behind slowness of the database server I accidentaly came across Preemptive_Xe_Dispatcher wait. Could you please suggest how this type of wait should be troubleshooted? ...
2
votes
0answers
356 views

What could empty our cache (plan and buffer)?

If I execute sp_BlitzFirst in my server, sometimes it tells me 2 things: Plan Cache Erased Recently (indeed my plan cache is around a few hundreds MBs) (sometimes) Page Life to low (indeed my page ...
2
votes
0answers
128 views

Why does optimizer estimate 1 row for this plan?

Here's my plan I'm having trouble with: https://www.brentozar.com/pastetheplan/?id=r168tltbe I'm betting this is something easy I'm not seeing. I have a query that is running very slowly because ...