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

learn more… | top users | synonyms (2)

0
votes
1answer
34 views

How can I restore ##MS_SSISServerCleanupJobLogin##?

At some point the SSIS cleanup job login (##MS_SSISServerCleanupJobLogin##) got deleted from my sql server (2012). I'm trying to upgrade to SP2 and I'm getting an error message I believe is related to ...
0
votes
0answers
35 views

Inserting INTO XML Column shows nothing at all

I am trying to populate xml in table by, Declare @docy xml = N'<elements>..... 6000 character file </elements>' SET IDENTITY_INSERT TableName ON INSERT TableName(Id, ID_A, ID_B, Xml) ...
2
votes
1answer
41 views

What is FT BATCH CMPLETE in the cmd column for sysprocesses?

I was trying to figure out what was causing high cpu usage in our sql server and found two processes that were consuming high CPU. When I queried sysprocesses to see what the spid was doing, it had ...
5
votes
2answers
132 views

SQL Server: Create New GUID Values for Existing Index

I have an existing table with about 6 million rows. The relevant columns are: ID int not null PK Key uniqueidentifier not null Read/write on this table by Key lookup is probably something like 100 ...
4
votes
1answer
88 views

Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012 [closed]

I just read the Brent Ozar Weekly Links email (July 28th Edition), and noticed the "Kendra's Link" talking about "Fix: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL ...
4
votes
2answers
79 views

Sql Server Management Studio login prompt will never forget other sql user than SA

When I login to a database, using some other user than SA, that username will stick the next time I login. If I then input the username SA and password and logs in, the next time I open the login ...
2
votes
2answers
76 views

Help reading deadlock XML

Even with reading the Bart Duncan blog about reading deadlocks I still struggle with this. I have included the XML from a particular deadlock. <?xml version="1.0" encoding="utf-8" ?> - ...
0
votes
2answers
66 views

Transaction Log Shipping across multiple SQL Server versions

I'm lead to believe that TLS is only appropriate/supported across the same versions of SQL Server. What I'm trying to do is to maintain a reporting (read only) version of a production transactional ...
-1
votes
2answers
85 views

SQL Server 2012 Browser Service doesn't appear [closed]

I've installed SQL Server 2012 and Management Studio Express. I attached the database that belongs my previous Project in Visual Studio. But I am having SqlException Error , I think the reason of the ...
0
votes
1answer
60 views

Page compression not working?

I have created a table where I have around 100 partitions (per month), all of them are configured to use page compression. After that I'm inserting data to this table month by month. I now would ...
2
votes
1answer
56 views

Performance impact of Extended Events filter [like_i_sql_unicode_string]

I have created an extended events session in which I wanted to see all queries using nolock hint. I have decided to use it instead of sql trace in order to minimaze possible performance impact. ...
2
votes
3answers
91 views

Should I shrink my database?

I have a 1.2Tb SQL Server 2008 R2 database which is more than 50% empty, because I migrated a lot of functionality to PostgreSql. The database is still in use, and still somewhat growing, but I do not ...
0
votes
0answers
25 views

Error in 'Master Database Restore' in SQL Server 2012 (Because of difference in SQL Server Build)

I have a backup of a master database that was taken from SQL Server 2012 11.00.2218 build. Now I have a new SQL Server installation with build 11.00.2100. I tried restoring the master database after ...
1
vote
1answer
27 views

Workload Groups in SQL Server 2012

I have been looking for an answer about "Workload Groups" in SQL Server? What exactly it is Workload Groups? Could you explicit a real world situation when this term is used? Thanks in advance ...
0
votes
1answer
69 views

SQL Server slows down on one expensive query

I have a Sql Server 2012 with lot of CPU and memory. When I run a query with a bad plan the server slow down and all other query, even of other databases, become very slow. When I run the query: - ...
3
votes
2answers
121 views

How to figure out Disk I/O by table

Is it possible to figure out which tables contribute the most to read / writes operations if all of them in same file? I been looking at the following DMV SELECT * FROM sys.dm_io_virtual_file_stats ...
5
votes
0answers
88 views

SQL Server AlwaysOn log_send_rate

On all our AlwaysOn setups, running Windows 2012 and SQL Server 2012 in virtual machines and on bare-metal, I find that the log_send_rate in sys.dm_hadr_database_replica_states is consistently ...
2
votes
2answers
56 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
69 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
2
votes
3answers
213 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
211 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
0
votes
0answers
102 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. ...
0
votes
1answer
34 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.
2
votes
1answer
65 views

SQL Server 2012: NUMA node shown as offline without special affinity settings

My main production server has four NUMA nodes with two SQL Server 2012 instances on it. One of the instances has the CPU affinity set to use only one NUMA node, and sys.dm_os_nodes reflects that ...
0
votes
1answer
35 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
66 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 ...
1
vote
1answer
33 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
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
30 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 ...
0
votes
2answers
60 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 ...
2
votes
1answer
135 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 ...
-2
votes
2answers
46 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
127 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 ...
2
votes
0answers
516 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 ...
0
votes
0answers
62 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 ...
0
votes
1answer
380 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 ...
1
vote
1answer
81 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
42 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
0answers
61 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 ...
1
vote
1answer
243 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
1answer
35 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 ...
0
votes
1answer
48 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 ...
2
votes
3answers
95 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
0answers
92 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
2answers
108 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 = ...
0
votes
1answer
41 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.
0
votes
2answers
35 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
32 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
65 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 ...
0
votes
2answers
37 views

How do I set a database back to 'Restoring…'?

Sorry if this is a noob question. I have transaction log shipping set up for a failover scenario. All the databases are in 'Restoring...' state until I do restore database x with recovery. At this ...