The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [sql-server-2012]

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

625 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
24 views

Snapshot replication from SQL Server 2012 to SQL Server 2008R2

We are using snapshot replication as a standby to replicate prod data for a month from 2012 to 2008R2 after migration from 8R2 to 2012, just as a rollback process. Using snapshot replication for 10 ...
0
votes
1answer
324 views

Is it possible to support multiple snapshots / store a snapshot / restore from a snapshot to a state with another snapshot?

So, I would like to have a snapshot structure like the following: A snapshot 1 is taken. Some code is run, then a snapshot 2 is taken. Then some more code is run, and the database is reverted to ...
0
votes
0answers
136 views

When restoring logs in log shipping, when does the restoring stop

We are using LS for reporting purpose. LS backup runs on primary every 15 minutes. On Secondary nightly restore via LS restore job is done daily at 10 PM. While the nightly restore job is running, ...
0
votes
1answer
77 views

Better approach to optimize query

We have a previously designed query that functions fairly well but I am thinking there has got to be a better way of performing the following. Here is the query... WITH CTE1 ( COL1, COL2) AS (...
0
votes
2answers
254 views

Granting a SQL Server database only user execute on xp_instance_regread fails

So I'm not finding an answer to my specific issue. SQL Server 2012 database SSMS 17 admin tool Log on as a database (not domain) user foo. Receive sys.xp_instance_regread no permission errors. In ...
0
votes
0answers
246 views

Oracle to SQL Server Conversion help: sys_connect_by_path, listagg, regexp

I've been tasked with converting a process from Oracle to Sql Server 2012. I've converted most of the query over to SQL Server but am having a hard time translating over these queries to SQL Server ...
0
votes
1answer
26 views

Copy database wizard - any change in lsn number of source database

After Copy database wizard - database restore in another server . Any change in LSN number of source database . is it same as copy only backup?
0
votes
1answer
45 views

Getting replication status for snapshot replication

Is there a way we can get stats on how the snapshot replication is working in an easier report format to check on actually how many objects like tables or sps have been replicates followed by health ...
0
votes
1answer
33 views

Failover from Primary to Asyn Secondary Replica

In my environment we have 1 Primary 1 Synchornous Secondary and 1 Asynchronous Secondary Replica (Off site). We are planning to do a manual failover to the Asynchronous Secondary Replica (Off site) ...
0
votes
1answer
58 views

Change Data Capture SSIS not picking changes

I am trying to implement change data capture in SQL Server 2012. I enabled it at database and table level. when i try to update the table, CDC_CT captures the changes. However when i am using SSIS CDC ...
0
votes
1answer
194 views

Email SSMS Log Shipping Status Report

We use Log Shipping to allow Business Analysis users to query data. I would like to email the Log Shipping Status report to users to see last time data is refreshed. When I Right Click on Server--&...
0
votes
0answers
153 views

Affinity Masking

One of the servers I'm responsible for now was set up under the wrong license so can only use 40 cores on the server. This has led to an imbalance in the NUMA node schedulers. I'm planning on using ...
0
votes
1answer
113 views

Log Shipping Server Restart Problem

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...
0
votes
1answer
35 views

Best High Availability Solution for SQL Server 2014

Please we are about to implement High availability for for SQL server 2014 on our new infrastructure but i need to know which is best between SQL Failover Clustering and Always On High Availability ...
0
votes
1answer
50 views

Trigger reading from two view tables and write on a different table takes more than 12 seconds, what might be the issue here?

Trigger reading from two view tables and write on a different table takes more than 12 seconds, what might be the issue here? In my case, I am using a trigger to read from two view tables (Decisions2 ...
0
votes
0answers
85 views

Snapshot Replication Hangs

I have two servers, SQL Server 2012. I have snapshot replication set up. Pull subscription. Publisher, distributor, same box, subscription is a different box. Lately, I have been running into some ...
0
votes
1answer
280 views

Job Agent sysjobhistory run_status=0 failure but which last step was a failure?

I am getting confusing results from sysJobHistory. The message can sometimes say last step was 2 but the row from instance_id says 0. Below are some examples below when run_status=0. Any idea how ...
0
votes
0answers
106 views

Convert subquery to join or other performance improving solution

This is direct continuation of this question, then solved with this answer. The problem lies with the logic here: ,case when Cast(o.[CreationDate] as time) > '16:00:00' then (select top 1 ...
0
votes
1answer
54 views

Increasing tempdb data files on 2 node Availability Group

I am planning to create additional tempdb files for 2 nodes in a SQL 2012 Availability Group. Unfortunately we do not have Instant File Initialisation turned on so the growth of the tempdb data files ...
0
votes
1answer
47 views

Avoid PLE drops while performing DELETE operations

If my quesion is not specific enough please tell what details are missing. We are runing daily archive operations on the whole database where we keep data from the last 30 days. We are deleting data ...
0
votes
0answers
41 views

How does the data move within a filegroup for its respective secondary data files

I am confused or do not have better understanding on how SQL works in below scenario and need some views: For a database X, we have a FILEGROUP named FG which has 4 data files tagged to it as below ...
0
votes
0answers
987 views

SQL Server Agent job fails to run SSIS package, but the package runs fine manually

SQL Server Agent job fails to run SSIS package, but the package runs fine manually The SQL server is SQL Server 2012. The job has been working for a long time fine. This is the first time when it ...
0
votes
0answers
1k views

Extended Event Reported Error Login Timeout

While poking around for a specific event I found myself discovering an error happening every second. At the moment I cannot find any more information about the error as it only gets displayed in the ...
0
votes
2answers
1k views

How to Solve the Failed to initialize the CLR

I Have a Following Error .. Failed to initialize the Common Language Runtime (CLR) v4.0.30319 with HRESULT 0x80004005. You need to restart SQL Server to use CLR integration features. How To ...
0
votes
1answer
35 views

MSSQL Transactional Replication

I have an application that almost continuously works with inserting or updating data. Since multiple requests are handled asynchronous I wrote my queries like below. I used an example based on SO, but ...
0
votes
0answers
243 views

Recover data from .mdf file, and no correct version of SQL Server

I have an 80gb .mdf file that I need to open and get the data out of. It was on a computer running SQL Server 2008 R2 Express that died, but I was able to pull the file off the half dead HDD. I don'...
0
votes
1answer
22 views

Always On reaction in specific scenario

I need to upgrade my Sharepoint2013 Farm, and the SQL2012 servers are in AlwaysOn mode. I was wondering if I could use Always On in the following catastrophic scenario: Take a VM snapshot of ...
0
votes
0answers
296 views

High disk usage by Windows Server when executing SSMS

Every time we execute SSMS on Windows Server, there is a high disk usage System process for ntuser.dat.LOG, as seem at Resource monitor: The write rate is between 2 MB/sec and 8 MB/sec. Why do we ...
0
votes
1answer
584 views

Drop a replicated subscription table that has been orphaned after restore migration

We restored a database on a new server for a migration. When attempting to set a subscription to a transnational publication, we get the error: Can't drop the table because it is set for ...
0
votes
1answer
24 views

In-place up-gradation of SQL server on Azure with pre-image installed.

We have migrated our SQL server 2012 infrastructure from on-premise to Azure cloud recently where in all the production VM's are build with pre-images of SQL 2012 enterprise edition. So,here is the ...
0
votes
0answers
72 views

Table partitioning in SQL Server

I've implemented Table Partitioning for one of our Tables which contains loads and loads of data. About 10-20K records are saved every 2-3 minutes. User will want access to the latest 3 months data ...
0
votes
0answers
255 views

Same Domain Linked Server Login Failing

I have several SQL Server instances. All of them are setup in the same domain, and have been working for years. One of these instances serves as an aggregator for the data of the others, and a sync ...
0
votes
1answer
107 views

Secure Symmetric key from sa

Can I secure SQL Server symmetric key from [sa] account? Can I create symmetric key using local user certificate via MMC? Thanks
0
votes
0answers
63 views

SQL Server 2012: How do I capture server activity during a specific time frame?

SQL Server Gurus, I have a situation on one of our servers. This server's sql agent job executes an SSIS flow every hour 24/7. The SSIS flow boils down to inserting/updating/deleting multiple tables ...
0
votes
0answers
52 views

How to handle frequently outdated statistics dealing with an ORM?

We have a vendor application that uses Hibernate ORM (an object-relational mapping tool). It routinely generates queries returning hundreds of columns out of 10+ tables at a time. By logging the ...
0
votes
1answer
29 views

Safe to use odbc link betw Filemaker 11 Server & SQL Server 2012?

I’ve established a successful odbc connection between filemaker 11 Server and SQL Server 2012. Filemaker, inc has not certified this compatibility between the two but I have had no problems importing ...
0
votes
1answer
460 views

Pulling data on SSL expiration from SQL server

I am trying to figure this out and seems to be out of thoughts and need your inputs to help me figure out on this. We have implemented SSL across our 200+ servers, SQL2012 & 2014. These cert are ...
0
votes
1answer
66 views

SQL Server '12 Using RAM equal to 2x size of the only user database

Only user database on instance is ~8.5GBs. MAX Mem set to 16GBs, which is ALL being consumed. Virtual server has 24GBs RAM and 2 vcpus Insert Poltergeist meme "What's happening?!" ***Side notes**** 2 ...
0
votes
1answer
75 views

OSQL RTM on SQL Server 2012 SP2?

I have a situation that I've never seen. OSQL crashed in a scheduled job which has always worked. Windows event viewer shows an exception code: 0xc0000005. the version of OSQL.exe also showing in ...
0
votes
1answer
842 views

SQL Server Average Lock Wait time Historical data

Monitoring software has indicated average lock wait times rising to 500ms during the night. Is there any way of confirming which locks these were as we currently do not log any performance data to a ...
0
votes
1answer
267 views

LSN numbers query regarding Differential backups

We have the following backup regime in place which I am not 100% sure about. Full backup each night at 18:00 taking approx. 6 hours Transaction log backup upon completion of full generally about 10 ...
0
votes
1answer
77 views

SQL Server Licensing for training, small scale development

I am currently undertaking SQL SERVER 2012 Training for the exam 70-461. I currently have SQL SERVER 2008 running on my laptop but I'm looking to upgrade to 2012 and I'm having trouble trying to get ...
0
votes
1answer
38 views

alter table which is under the load (sql server)

we have table that being used for sending sms and other notification for confirmation as second factor. Some changes in business logic requires us to alter table to make some columns NOT NULL. Our ...
0
votes
0answers
1k views

Error: 9602, Severity: 16, State: 1.The error is printed in terse mode because there was error during formatting

From today onward i am getting the below error in SQL Server 2012 Error: 9602, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. ...
0
votes
1answer
109 views

Keeping my database updated every 30 minutes using Log files

I have a situation where I get a full nightly backup and trans log backup every 30minutes starts at 7:00 am ends at 2:00 am. I need to restore them every 30 minutes into a database and replicate this ...
0
votes
0answers
260 views

Reporting Services report that runs quick locally and in development, but not in production

I have a Reporting Services report with the following characteristics. The stored procedures used run fast in SSMS. This is true in production and development databases. The report renders quickly ...
0
votes
1answer
256 views

When is dm_exec_procedure_stats updated?

I just created a new proc and ran it, but it is not showing up in my query: SELECT schema_name(schema_id) SchemaName, name ProcName, last_execution_time LastExecuted, last_elapsed_time ...
0
votes
1answer
44 views

Server and Database role memberships required to add columns and constraints

I have a user with the following server and database role memberships: securityadmin (server) public (server) db_owner (database) db_accessadmin (database) db_securityadmin (database) When running ...
0
votes
1answer
41 views

Creating rows in a table based on columns from another

I have an MS SQL 2012 DB with a table in the following format: account_id site_id IRA RFI XSS SQLi BDP Month 32501 112233 1 4 4 3 0 August,2016 32501 ...
0
votes
1answer
49 views

Find the Sharepoint application server based on Sharepoint Databases

I'm doing some cleanup in my SQL Server farm and I found on one of our SQL servers (2012) several databases that I believe belong to a Sharepoint server. No one knows in the company what is the SP ...