Top "Sql-server-2012" questions

Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.

Constant SQL Server 80% CPU Utilization

We have a small (for now) Asp.Net MVC 5 website on a dedicated VPS. When I go to the server …

asp.net performance sql-server-2012 cpu-usage sql-server-performance
Use Collate in CONCAT

I was trying to concatonate 2 columns with a whitespace in between and got a collation error: SELECT DISTINCT p.PERSON_…

sql-server sql-server-2012 concat collate
SSAS cube processing error about column binding

This is an error message I get after processing an SSIS Cube Errors in the back-end database access module. The …

sql-server ssas sql-server-2012 cube
How to view data in table variables during debugging session in MS SQL Management Studio 2012?

I would like to debug a complex T-SQL script using SSMS 2012. I can run the script in debug mode and …

debugging sql-server-2012 ssms table-variable
Special characters displaying incorrectly after BULK INSERT

I'm using BULK INSERT to import a CSV file. One of the columns in the CSV file contains some values …

sql sql-server-2012 bulkinsert nvarchar
SQL Server LCK_M_S only happens in production

I have a stored procedure that is called by a SQL Server 2012 report that is taking an age to run …

sql sql-server reporting-services sql-server-2012 blocking
Best Practices for Computed Column in SQL Server

I'm working with a user table and want to put a "end of probational period date". Basically, each new user …

sql-server sql-server-2012 calculated-columns
How do I copy SQL Server 2012 database to localdb instance?

I'm looking to copy a SQL Server 2012 Standard database to my localdb instance. I've tried the wizard which complains that …

sql sql-server sql-server-2012 localdb
Can't Export Data-tier Application for Azure

I am trying to create a .bacpac file of my SQL 2012 database. In SSMS 2012 I right click my database, go …

sql azure sql-server-2012 ssms-2012 bacpac
Can't save database default locations in SQL Server

I'm trying to change the default directories for data and logs using SQL Server Management Studio. I change the path …

sql sql-server sql-server-2012