This tag is for SQL Server 2012, major build version 11.00.xxxx.

learn more… | top users | synonyms (2)

1
vote
2answers
276 views

Automatic Failover in Availability Group

I have 2 nodes in my SQL server fail over cluster. I use SQL Server 2012 Availability Groups for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! ...
1
vote
1answer
352 views

System table missing in SQL Server 2012

I restored a SQL Server 2000 database to 2005 then to 2012. I am not able to see system tables that existed in SQL Server 2000 now. Can somebody please let me know what is the reason. Thank you
1
vote
1answer
558 views

Does MAXDOP affect the number of tempdb data files I should create?

From what I have read, best practices for configuring tempdb includes creating multiple data files. The rule of thumb as I understand it is if you should create the same number of data files as you ...
1
vote
2answers
961 views

Expose temp tables to SSRS in stored procedure

Problem: Compare data of a given date range to the same data of up to 3 previous years, and display the tabular data and a graph in an SSRS report. However currently, my stored procedure that I have ...
0
votes
0answers
33 views

How to install SQL Server 2012 Management Studio Books Online in Help Library Manager

I tried to install the SQL Server 2012 BOLs however my Help Library Manager is all greyed out except the "Choose online or local help"
1
vote
2answers
203 views

SQL Server 2012 is database name mandatory for logon?

is the database name mandatory SQL Server 2012 logon - like SERVERNAME\DBNAME ? On 2005 Server the servername for logon with Windows credentional has been sufficient. Thanks in advance, Tom
2
votes
5answers
10k views

Cannot start SqlLocalDB instance with my Windows account

I'm the administrator and simply run the command: sqllocaldb start v11.0 Result: Start of LocalDB instance "v11.0" failed because of the following error: Error occurred during LocalDB instance ...
0
votes
2answers
6k views

Couldn't install SQL Server 2012 on machine with Windows 7 SP1, VS 2010 SP1

I am trying to install SQL Server 2012 RTM on my pc, I have installed Windows 7 SP1, VS 2010 SP1 but it again and again giving this error: A network error occurred while attempting to read from ...
0
votes
2answers
35 views

Transactional Replication Update process

I need to create report using ssrs. for that i create the main table contains the values from nine other tables which is the Source tables. Now the new source tables which are used for main table are ...
1
vote
1answer
872 views

Best Format to Bulk INSERT/UPDATE Data to SQL SERVER using C# [closed]

Can anyone tell me what is best way to bulk insert/update data to SQL SERVER 2012 using C#? I have an excel file which I am passing as TVP(table value parameter) to a SP. But this is little bit ...
0
votes
2answers
104 views

MS SQL Server 2012 Error on TLog Backup

I have a MS SQL Server 2012 installation on which I am restoring a SQL 2005 .bak which includes some full-text catalogues The original .bak has no conflicts with 2012 (as the migrate advisor was used ...
3
votes
1answer
173 views

Transactional Replication: can create 52 publication, but creating 53rd leads to problems

My apologies in advance for a long post, but I was really trying to make sure I do my due diligence before turning to the community for help, so here it goes. I am working on a proof of concept with ...
3
votes
2answers
719 views

SQL Server 2012 - password for services during silent installation

I am a database developer and I have a task to prepare silent installation of SQL Server 2012 using configuration file. I have a problem with passwords for server services like: RSSVCACCOUNT="NT ...
6
votes
1answer
197 views

Any way to reduce sysallocunits contention under a heavy concurrent INSERT workload?

I have a database which is being inserted into by a large number of independent sessions. Each session writes to a different table, so you would naively expect that they would all proceed in parallel. ...
1
vote
1answer
105 views

Statistical Analysis of Data that has to be done in an order?

Bear with me - that is the first time try that in SQL Server, normally I have been doing that on the front end ;) I a implementing some analysis on time coded data series. This is not super ...
4
votes
2answers
306 views

Strategy to deal with multi billion row simulation results and partitioning

I am trying to come up with a good way to deal withthe results of statistical simulations from a dba point of view. We generate about 500 million rows per day, most of which are "garbage" (i.e. the ...
1
vote
1answer
101 views

bulk insert for loas data

declare @DATADIR varchar(128) set @DATADIR= 'C:\SQL2012\SH_DATA' msg:Command(s) completed successfully. EXECUTE('bulk insert CHANNELS from '''+@DATADIR+'\CHANNELS.txt'' With (firstrow = ...
5
votes
1answer
3k views

How to changes or update local server connection in Maintenance plan job

Two days back our client changed one of our Dev Server name After Server Renamed, All my maintenance jobs and other jobs are failing because server name mismatch. We are using sql server 2012 ...
3
votes
0answers
120 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? ...
2
votes
1answer
43 views

What is the difference between node types and atomic types in XML

Im Studying TSQL and I came to the chapter regarding XML, and here a question that I cannot find an answer: "What is the difference between node types and atomic types"? Thank you!
0
votes
0answers
42 views

performance improvement - left join

How do I rewrite to improve performance of the below query. select S.col1, S.col2, MaxDDate from s_tbl s left join (select col1, MAX(DDate) MaxDDate from F_tbl group by col1 ...
4
votes
2answers
2k views

Log sizes unexpectedly large: log_reuse_wait_desc == “log_backup”

I've been reading posts and manuals all day, I need help. My problem: transaction log sizes after data and transaction log backups will not shrink, and grew to be unexpectedly large. The system is ...
2
votes
2answers
132 views

fragmentation for non cluster index growth very fast to 30

i have table with about 7 milion records.index fragmentation was about 90 . i try rebuild index for all index. and it works fine but after nightly job fragmentation for one of none cluster index ...
2
votes
0answers
143 views

How to use Blob Storage as shared storage in a Windows Azure Failover Cluster?

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster composed on ...
1
vote
1answer
55 views

Automatic Failover without data replication

I have a need to be able to automatically failover my databases and most need data replication. However, one database does not need data replication and so, for performance reasons, we do not include ...
2
votes
1answer
446 views

Two “Connect SQL” permissions in SQL Server 2012

What is the difference between these two "Connect SQL" permissions in SQL Server 2012?
0
votes
0answers
178 views

How to setup subscription to publication for SQL Server replication to SAP HANA?

I previously posted on stackflow.com and was told to post here. Here is the original post if you're interested: ...
3
votes
1answer
2k views

Why is SQL Server using a clustered index scan for a self referencing FK cascade delete

I have made an example to allow me to show what my issue is: Setup: CREATE TABLE [dbo].[Test]( [TestId] [bigint] IDENTITY(1,1) NOT NULL, [ParentTestId] [bigint] NULL, CONSTRAINT [PK_Test] ...
7
votes
2answers
91 views

Need to include FKs in SQL Indexed View clustered index?

I'm using a SQL Server Indexed view to improve performance of a join that filters a (very) large table by a category on a small table. eg: CREATE VIEW BigTableSubset WITH SCHEMABINDING AS SELECT ...
0
votes
0answers
76 views

SQL Server 2012 Profiler - ShowPlan XML Batch ID

I have an application that makes RPC calls for a single procedure, most calls run in a few miliseconds. Occasionally the call takes 5-7 seconds. I'm trying to catch an execution plan for one of the ...
4
votes
2answers
2k views

SQL Server auto-trim of varchar value in equal comparison but not like comparison

I came across some interesting behaviour on SQL Server (observed in 2005 and 2012) today that I was hoping someone could explain. A query doing a comparison using = on an NVARCHAR field ignored the ...
0
votes
0answers
33 views

Trouble migrating a MySQL database to MS SQL 2012 using the migration assistant

I am trying to migrate a MySQL server database to Microsoft SQL Server 2012. I converted the schema and synchronized the databases, but when I try to do the migration, it doesn't work and I get this ...
3
votes
1answer
2k views

Downgrade database from SQL Server 2012 to 2008 [duplicate]

Hi guys got a problem with a database. I've been asked to perform some indexing and delete queries on a live database, so first of I wanted to get the database to our dev server so I can test out ...
3
votes
1answer
800 views

How do I get SQL Server agent to show up in SSMS for a non-sysadmin user?

I have already mapped the user to the msdb database and assigned him the role of SQLAgentOperatorRole, but the user still can't see the SQL Server Agent listed when he connects. The Agent show up fine ...
5
votes
1answer
292 views

Disabling SET Statements / Forcing SET Options in SQL Server 2008R2/2012

I am currently working with a MSSQL 2008R2 Database which uses the following SET-Commands frequently: SET ANSI_NULLS { ON | OFF } SET QUOTED_IDENTIFIER { ON | OFF } SET ANSI_PADDING { ON | OFF } ...
3
votes
2answers
4k views

How to create a server alias in SQL Server 2012

We have a Windows Server 2012 server running with 2 instances of SQL Server 2012 installed on it - Live and System. Both instances are accepting connections on 1433 & Live is the default instance ...
0
votes
1answer
57 views

What are the compelling resons to update SQL Server name to a real one after its changing?

Took the job of monitoring and tuning a few dozens SQL Server 2012 Enterprise Ed. SP1 (64 bit) on Windows Server 2008 R2 Standard Ed. running inside virtual machines. All of them on running ...
1
vote
1answer
569 views

Package deployed in SSIS 2012 catalog fails with timeout error

I created an SSIS package in Visual Studio 2008 and deployed it to SQL Server 2012 by using Integration Services Catalogs. When I run the package from BIDS it completes successfully. When I schedule ...
0
votes
2answers
67 views

SQL Server replicated databases swap

I have a SQL Server 2012 database. I would like to be able to make changes to this database or to it's replication, then make the replica, the real one. The point here is to have 0 downtime on ...
0
votes
0answers
1k views

SQl Server 2012 Powershell script to generate database with schema and data

Using Sql Server 2012, could somebody be so kind and show me a simple powershell 3 script that generates my entire database (schema and data)? I tried this one: $Filepath='d:\b\t' # local directory ...
1
vote
3answers
134 views

Creating a copy of primary database and attaching the copy database in the same sql instance

I just got into a project in which we have only one SQL Server 2012 copy. We have 12 databases attached to the primary instance of SQL Server 2012. As I don't have SQL Server 2012 or supporting OS, I ...
7
votes
1answer
444 views

Specific TempDB insert of UserDB select results in SOS_SCHEDULER_YIELD to ENCRYPTION_SCAN

One of our production systems has exhibited a problem with a single insertion statement into a temp table from our user database. When I comment out the insert/select, the stored proc in question runs ...
1
vote
1answer
260 views

Running parallel delete statements

Problem: I have a massive table - occupies a whopping 9.5 TBs. I need to delete around 5 mil rows from it. The best method I have come up with deletes 1 million records in 2 hours! Since I can not run ...
1
vote
2answers
2k views

Select all data group by 1 column and functioned by another

I have the following table in SQL Server 2012 : ID int priority int type int other data columns I want to query the table for the following result : grouped by 'type' get the id of top 1 max ...
1
vote
0answers
295 views

SQL Server: Principal DB becomes unavailable after problem with mirror DB, even with Set Partner Safety Off?

We've got a very simple mirroring setup here: just a principal DB and mirror DB, no witness, running in high-performance mode with SET PARTNER SAFETY OFF. This problem has happened to us twice now: ...
1
vote
3answers
297 views

Trouble with SQL Server authentication in SQL Server 2012

I am working with a SQL Server 2012 database. I am able to log into the server using Windows authentication. Although I have the SQL Server authentication username and password which is provided to me ...
0
votes
0answers
435 views

SQL Server 2012 Free Pages in Buffer Cache Not Being Used

SQL Server Version: Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 ...
0
votes
0answers
818 views

SQL Server 2012: Login failed for user. Reason: Failed to open the database configured in the login object

Every so often, my SQL Server 2012 throws the following errors: Error (likely related to the one below): Source: spid99 The client was unable to reuse a session with SPID 99, which had been ...
1
vote
0answers
43 views

Turn xact_Abort on for specific applications or user

We have a 3rd party application that requires xact_abort to be turned on, however we have other applications that require it to be turned off. The service that requires it turned on always logs in ...
0
votes
1answer
2k views

Export a SQL Server 2000 database to Server 2012

I have a production environment running Windows Server 2000 and a development environment using SQL Server 2012. I need to make updates to the DB and implement some new features using .ASP. Is there ...