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

learn more… | top users | synonyms (2)

2
votes
2answers
53 views

How do dirty reads at both the transaction and table level provide increased performance?

I ran the following code past our architect as I thought there may have been a tautology between the isolation level and table hint: SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ...
0
votes
1answer
149 views

SSIS Package Validation Error when Executed From Windows Task Scheduler

I have deployed my SSIS package using the project deployment model to the SSIS catalog and experience a strange validation error when I try to execute the package. I believe this is due to a ...
0
votes
1answer
65 views

What should I consider before I upgrade my SQL Server memory? [closed]

I want to upgrade the memory in my SQL Server. What should I check first? Version: SQL Server 2012 64-bit Standard edition
0
votes
2answers
396 views

SQL Server 2012 linked server to SQL Server 2000

I am trying to select through an linked server from SQL Server 2012 to SQL Server 2000. The linked server has been setup and I can browser the target database through the linked server which ...
2
votes
1answer
740 views

“No row was updated error” in SQL 2012 - worked fine in SQL 2005 and 2008

I have a database that currently lives in SQL Server 2005. We are currently looking at upgrading to SQL 2012. I installed 2012 in a test environment (Windows Server 2012 virtual machine). Backed ...
2
votes
3answers
169 views

Collecting Wait Stats

We currently use a monitoring tool which shows us our top wait stats either by number of waiting tasks or total wait time. Below are the wait stats by number of tasks waiting and also wait time per ...
-3
votes
2answers
73 views

SQL Server Management Studio does not load [closed]

I am working on SQL Server 2012 for the past 15 days it was working perfectly but now I am having an issue: Cannot find one or more components. Please reinstall the application
1
vote
1answer
209 views

SQL Server 2012 Publisher SQL Server 2008 Subscriber version issue

So I have a setup where one virtual machine is a SQL Server 2012 publisher and I need to setup merge replication on a SQL Server 2008 subscriber on a different vm. When setting up the subscription ...
4
votes
1answer
136 views

What tables are affected by Change Data Capture

We're looking at using Change Data Capture in SQL 2012. We're trying to work out if there is an easy way to find out what tables have been changed by a given lsn. Is there an inbuilt function, or ...
0
votes
2answers
52 views

Copy DB from SQL Server 2008 to SQL Server 2012

I have several databases on SQL Server 2008 that I wish to transfer to SQL Server 2012. The two servers are on the same network but separate domains. I am attempting a DB Copy from the one server to ...
1
vote
1answer
75 views

After Restore Log_reuse_wait_desc of Replication

I'm wondering if anybody has ran into this issue before and has any suggestions on what's causing it/how to fix it. We are restoring a database into lower Dev environments and after the restore the ...
0
votes
1answer
29 views

SQL Server 2012 Vs PDW [closed]

We are migrating to SQL server 2012 to PDW. Any SQL script for Comparing the data between SQL server 2012 and Parallel dataware house or any tools to compare.
0
votes
0answers
59 views

Database mail “Mailbox unavailable. The server response was: 5.7.1 Unable to relay for…”

I am getting this error on a named instance. I set up the account and profile. It is pointing to our internal anonymous smtp server. The IP address has been allowed to relay on the SMTP server. ...
1
vote
1answer
26 views

Troubleshooting vanishing fulltext index in SQL Server 2012

I am trying to get to the bottom of some weirdness. Yesterday I enabled a fulltext index on a table in SQL Server 2012 running on one of our LAN servers. I used the Wizard and set the index to update ...
0
votes
1answer
33 views

How Do I Gain SysAdmin Access Without Having a SysAdmin Account? [duplicate]

Situation: We recently had a consultant company build new Lync 2013 Servers in a mirror setup. There are two security principles set, SA (disabled), and a AD group that is only associated with the ...
2
votes
0answers
61 views

Stored Procedure slow after weekend

When I come to work on monday some stored procedures take several minutes to execute and STATISTICS IO shows a lot of PHYSICAL READS and READ AHEADS going on. However, after running the procedures ...
3
votes
1answer
33 views

Object Auditing with Availability Groups

We are about to implement Availability Groups and it brought up a question. We currently use auditing to see which objects are no longer used in production. We also take a backup each night to use ...
4
votes
1answer
1k views

Why are queries causing spill to tempdb?

Background I am in the process of migrating a 160gb database from MSSQL 2008 (standard) on a Win 2008 server with 48gb RAM to a new server running MSSQL 2012 (64-bit web edition) on Win 2012 with ...
0
votes
0answers
56 views

CDC auditing - Unanswered questions

EDIT: Added some comments from the stuff I was able to find out, in case future onlookers are interested. I'm completely new to CDC, and am in the process of implementing it to a large DB for the ...
0
votes
0answers
35 views

Is there any way to avoid SSMS 2012 allocating extra 1.5 GB RAM for non-standard color scheme?

SSMS 2012 allocates 1.7+ GB of RAM if the colors for Text Editor are different from default. Every few keystrokes GUI freezes for 5-10 seconds, which does not occur with standard color scheme. When ...
0
votes
0answers
25 views

Simple full text search on 5000 rows is very slow

I am running this full text search on an indexed view and it is taking 20 seconds to query across 5000 rows and return 0 rows. I believe it has something to with the forward slashes because all other ...
2
votes
0answers
219 views

How to do unattended install of SQL Server 2012 Express from the Enterprise media?

I have a requirement to install SQL Server 2012 Express on some machines, and SQL Server Enterprise on some others, and I'm attempting to avoid using separate packages to do so. It's pretty simple to ...
2
votes
1answer
72 views

Can I replicate a database from SQL Server 2012 to SQL Server 2014 (with 2014 distributor)?

I am planning to have database replication running from SQL Server 2012 (publisher) to SQL Server 2014 (both distributor and subscriber) -- pull replication. Has anyone done this type of ...
7
votes
1answer
349 views

Why would you use a managed service account rather than a virtual account in SQL Server 2012?

In SQL Server 2012, service accounts are created as virtual accounts (VAs), as described here, as opposed to managed service accounts (MSAs). The important differences I can see for these, based on ...
1
vote
2answers
86 views

How to remove a table partition

I would like to remove a partition from a table in a SQL Server 2012 database. The table has a primary key but the partition column is not a primary key. I would also like to keep the data structure ...
-2
votes
2answers
39 views

Can I Inner Join 2 tables based on multiple values for a column

This is what I want, TableA Inner Join TableB on TableA.ColumnA = TableB.ColumnA OR TableB.ColumnA = NULL I tried it and it returns empty ds? Edit Why I cannot use Right Outer Join and Left Outer ...
1
vote
2answers
81 views

Using UNION (ALL) in a WHILE loop with SELECTto merge the result set for each iteration

When I am looping with WHILE in SQL Server 2012, if I use a SELECT statement it prints the column name for each iteration. Can I UNION all? Here is my sample query: CREATE PROC spGetChar @start ...
0
votes
2answers
77 views

Cannot Copy Database [closed]

I am working with SQL server 2012. I want to copy a database along with all the data. I just want to create a dev DB. I know SQL Server 2012 has a Copy Database... wizard. But when I run that wizard, ...
0
votes
3answers
113 views

How to uninstall SQL server 2012 not showing in control panel's “Programs and features”

I am frustrated to the core. While fixing my Sql Server I've made the situation worse. Here is the problem: initially my master database was corrupted, so the MSSql service was not starting. I tried ...
1
vote
2answers
1k views

Create database fails with Microsoft SQL Server Error 5133, Operating syste, error 5 (Access is denied)

I just installed SQL server 2012 on Windows 2012 today. After the install, I changed the database settings to create database files in f:\mssql instead of the default. i verified the confired and ...
0
votes
0answers
44 views

SQL Server 2012 Slow Remote Connection and SSRS Manager

I am running SQL Server 2012. Everything was running fine until a couple days ago. The SSRS Web Manager Interface is extremely slow even after initial load, even just navigating folders can take ...
4
votes
1answer
213 views

SQL Server AlwaysOn Error_number 35206

I've joined a Ecommerce business where they use SQL Server 2012 AlwaysOn for HADR and this is the first time I've come across supporting this technology. The Sql Server log on both nodes gets ...
10
votes
4answers
6k views

SSMS Tools Pack Alternative [closed]

Are there any tools out there comparable to SSMS Tools Pack 2012? The licensing ($30 per machine, $100 for any number of machines... for 3 months) leaves a lot to be desired and I wasn't sure of what ...
1
vote
1answer
55 views

MS SQL Server 2012: once a day full replication (automatic backup/restore) for reporting

Our company is w/o a DBA, and it has fallen on me (a complete DB noob) to handle some critical database tasks. I'm looking for the best solution for us to be able to "copy" a full database to another ...
0
votes
0answers
39 views

Full Outer Join on 3 conditions

I am in a situation where I need to Full Outer Join two table based on three conditions but I am not sure how to, SELECT DISTINCT TableA.* FROM TableB INNER JOIN TableC ON TableC.IDB = TableB.IDB ...
0
votes
2answers
58 views

Error 9002 state 3 after RESTORE DATABASE

I'm trying to restore a database from a validated backup (through RESTORE VERIFYONLY). The command I've used : RESTORE DATABASE [RESTORE] FILE = ...
1
vote
1answer
132 views

Use NOLOCK hint when calling table valued function

Suppose the following function: CREATE FUNCTION [dbo].[ufnTest]() RETURNS TABLE AS RETURN SELECT 1 AS Nr My actual function will select actual data from many different tables. I (mostly) understand ...
2
votes
3answers
84 views

Looking for a utility to move data between databases (prod to dev) SQL Server 2012

I am looking for an easy way to copy table data from a production SQL Server 2012 machine to a development machine (same version, level). We currently just do an export from within SSMS, but we have a ...
2
votes
1answer
32 views

Cannot start SQL Server replication as already running

I'm trying to configure a sql replication on the sql server 2012 . I am logged in as "sa", when I attempt to start replication i get the following error : How can I stop this job and restart the ...
5
votes
1answer
89 views

SQL Server 2012 Unable to Utilize Defined Amount of Locks

So I've been beating my head against the wall for two days about this and I can't find a solution. I'm running a script to stage a large amount of data. This script requires roughly 35 million locks ...
2
votes
0answers
76 views

Slow query execution using ODBC 32

When executing a simple select query on a SQL Server 2012 system, the execution time is very different if I use OLE or ODBC 32bit. Unfortunately I am forced to use ODBC 32bit. The Query: SELECT ...
0
votes
1answer
30 views

Where can I get the master.dacpac file for SQL Server 2012?

I am using Visual Studio 2012 Professional with SQL Server Data Tools with a SQL Server 2012 standard edition database instance. I have been unable to locate a master.dacpac file on either my ...
0
votes
1answer
40 views

Sending one email when all jobs completes successfully

I need to create backup jobs over several instances, I wonder if there is any way to send a single notification via mail only when jobs from all instances completed successfully.
30
votes
8answers
7k views

Is select * still a big no-no on SQL Server 2012?

Back in the days of yesteryear, it was considered a big no-no to do select * from table or select count(*) from table because of the performance hit. Is this still the case in later versions of SQL ...
2
votes
3answers
161 views

Transaction log back up

Another accidental DBA question. We have a DB instance that host 10 databases. This DB server doesn't have any maintenance plan set up. I want to set up a decent maintenance plan that will do a full ...
0
votes
2answers
49 views

All queries on the server have slowed down, cpu is normal, plenty of free memory but SQL is using very little

The other day I logged onto our server to see SQL was using 100% cpu and the server was slowed to a crawl. I decided to stop SQL and restart it. However, it refused to stop properly and stopped ...
0
votes
2answers
30 views

Insert data into a column where other columns have constraints

I want to insert data into the zipcode column of the employee3 table. SQL says write - INSERT INTO Employee3 (ZipCode) VALUES (28279);, however I keep getting this error message: Msg 515, Level 16, ...
1
vote
1answer
25 views

How do I resume log shipping?

I was log shipping. I disabled the jobs, and restored the database on the secondary machine and used them for a bit. Now I want to undo this. I don't care about history or syncing, I simply want to ...
1
vote
1answer
54 views

Dealing with large transaction logs in a cluster

Disclaimer: I'm a dev, not a DBA. I've gleaned what I can from MSDN, but could do with some expert guidance! I'm working with a SharePoint 2013 installation on a SQL Server 2012 cluster of two DB ...
3
votes
1answer
2k views

How to check connection string in SSMS2012?

I'm connected to database. I use db by Management Studio 2012 Express. Can I check connection string by click something in Management Studio?