Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-server-2012]

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

SQL Server 2012 was introduced in March 2012. Current build versions include:

  1. 11.00.2100 – RTM
  2. 11.00.3000 – Service Pack 1, released November 2012
  3. 11.00.5058 – Service Pack 2, released June 2014

SQL Server 2012 left mainstream support on 2017-06-11, and will leave extended support on 2022-07-12.

See tag wiki of for more details.

4534 questions
15
votes
2 answers

sp_dboption is not available in SQL Server 2012

The system stored procedure sp_dboption is not available in SQL Server 2012 anymore. How could it be replaced?
msh
  • 329
  • 1
  • 2
  • 7
12
votes
1 answer

SQL Server 2012: Security_error_ring_buffer_recorded: ImpersonateSecurityContext

a couple servers I manage are recording a lot of events in the system_health XE session. name: security_error_ring_buffer_recorded api_name: ImpersonateSecurityContext calling_api_name: NLShimImpersonate error_code: 5023 The error_code 5023 should…
Jens W.
  • 1,219
  • 1
  • 8
  • 16
9
votes
4 answers

Moving rows from one table to another

I am moving records from one database to another, as a part of archiving process. I want to copy the rows to destination table and then delete the same rows from the source table. My question is, what is the most efficient way to do a check if the…
Dina
  • 1,487
  • 4
  • 25
  • 42
9
votes
1 answer

How do I fix SQL Server assembly optimization errors and memory exhaustion?

The .NET Runtime Optimization Service (mscorsvw) keeps consuming all my workstation's memory since I installed SQL Server 2012 Service Pack 1. It consumes about 1.6 GB of memory before exhausting all available memory: I can kill the process, but it…
Iain Samuel McLean Elder
  • 2,328
  • 4
  • 25
  • 39
8
votes
1 answer

Unrecognised system process saturating CPU

We have switched to our backup DC today as primary site Bandwidth has gone. We are getting issues with the most powerful DB server; it is spawning the following process for several db's on the server. One database is simply a small scratch db that…
DamagedGoods
  • 2,591
  • 6
  • 33
  • 48
8
votes
1 answer

performance impact when renaming a column in 100M rows table

We are running SQL Server 2012 Standard Edition. Need to change the name of a column in a table with +100M rows. This table is heavily used at all times. I can't say at this moment if the column in question is part of an index (should I expect…
Horaciux
  • 250
  • 4
  • 17
7
votes
2 answers

Alternatives to AdeptSQL Diff (for MS SQL Server 2012)

It seems AdeptSQL Diff is not compatible with SQL Server 2012 (at this time). And it is my preferred tool for deploying changes. I realize this is a shopping list but I hope SE won't mind. I am wondering what are the best alternatives out there and…
Dina
  • 1,487
  • 4
  • 25
  • 42
6
votes
1 answer

DBCC TRACEON (652) does not disable read ahead reads

Refering to this StackOverflow question: https://stackoverflow.com/questions/13307485/sql-server-clearing-cache-has-no-effect-on-io-stats I used the trace flag 652 which had, at the time disabled the read ahead function properly. I came back to it,…
Akash
  • 1,032
  • 1
  • 9
  • 25
6
votes
2 answers

ALTER TABLE SWITCH

I have two columns that I want to convert from computed to non computed. I have the code for that. However, it was suggested to me to use the ALTER TABLE SWITCH. I believe the individual who suggested it, didn't want to put the database in…
lcerni
  • 61
  • 1
  • 1
  • 3
5
votes
1 answer

How to display rows that are missing from aggregations?

I create a view to display ValueRange like this: ... ValueRange=case when Value1>60 and Value1<=65 then '60-65' when Value1>65 and Value1<=70 then '65-70' when Value1>70 and Value1<=75 then '70-75' END ... But…
Bünyamin Atik
  • 57
  • 5
5
votes
1 answer

Lock Timeouts with low Lock Waits

On a production SQL Server 2012 database we are getting some odd locking statistics that I don't understand. Lock Waits/Min: 0.2 Lock Timeouts/Min: 197.4 Deadlocks/Min: 0.0 @@lock_timeout is set to -1 How can I have Lock Timeouts without having…
JustinDoesWork
  • 478
  • 1
  • 5
  • 14
5
votes
1 answer

Why is the install of SQL Server 2012 in Windows Server 2012 taking over previously accessible hard drive's?

This is a harder one to ask since I don't really have a clear picture of what I'm asking. But, in a plain vanilla install of Windows Server 2012 (with only Web Server role/features enabled), installing SQL Server 2012 on top of it is taking over…
Kevin
  • 313
  • 4
  • 8
5
votes
2 answers

QUERY - join two tables based on date and filter results

My apologies for the cryptic title. I guess my inability to condense my question into a title is indicative of my inability to come up with an answer to the following: I have data in two tables (MS SQL Server 2012). A table produced and packaged.…
tmachielse
  • 133
  • 1
  • 2
  • 8
4
votes
1 answer

SQL Server Management Studio 2012 separated toolbars

In SQL Server Management Studio 2012, is there a way to get the toolbars separated, so there is space between them? I can do this with 2008 R2 by just dragging the toolbar handle. But in 2012, I can snap them to a different row, but if I just drag…
goodeye
  • 143
  • 4
4
votes
2 answers

SQL Server 2012 Compatibility

I'm converting some stuff over to be compatible with SQL Server 2012 and had a couple of questions. I'm taking out all of the sp_dboption commands and making them ALTER commands instead, but there were a few options I haven't been able to tell the…
user1427105
1
2 3
…
13 14