for SQL Server 2012, major build version 11.00.xxxx. Released April 1, 2012 with a projected end-of-life date of 7/12/2022.

learn more… | top users | synonyms (2)

1
vote
2answers
2k views

Possible to run multiple Reporting Services (SSRS) instances on different machines with databases on same machine?

With SQL Server 2012, can SSRS instances be setup on two different machines, with both instances using the same machine for their SQL Server databases? Machine 1 SQL Server 2012 Database Server ...
0
votes
1answer
303 views

Full-text Search XML Properties

I'm trying to determine whether I can retrieve a property (attribute) value from an xml blob stored in a FILESTREAM-enabled column using Full-text search. Here is a sample where message is a ...
3
votes
4answers
1k views

SQL Server Min Server Memory

using SQL 2008 R2 with SP2 with a server with 64 GB of RAM. I have set max server memory to 58GB considering SQL Server is limited to only database engine related service only. I have a question ...
1
vote
0answers
306 views

Merge Replication Update Statement Timeout

I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
3
votes
3answers
517 views

Simple XML .query SELECT statement times out on 1 SQL SERVER instance

I dropped and recreated a stored procedure on a DB on a SQL Server 2012 instance (SERVER1/INSTANCE1), after which the sproc started hanging on a line. Using profiler I have reduced a recreateable ...
1
vote
2answers
118 views

Targeting MSX with job on Multi-Server Administration

I am using Multi-Server Administration to execute jobs on multiple targets. This works well, but I am not able to enlist the master as a target. I receive the following error when attempting to enlist ...
3
votes
2answers
3k views

Connect to SQL Server 2012 from an Windows XP client

We have an SQL Server 2012 Standard database, to connect to it we use SQL Server 2008 Management Studio (since 2012 SSMS is not supported on Windows XP). The problem is that SQL Server 2008 gives all ...
3
votes
3answers
709 views

Select rows after a specific ID

I have the following query, it chooses from a news articles table. Due to multiple sorting factors, I cannot locate the next page of date. The parameter I have is the last ID in the query result set, ...
4
votes
1answer
67 views

Transfer logins to another server

I moved a database from SQL Server 2005 to SQL Server 2012. Is there any way of restoring all the logins on the new server?
1
vote
1answer
421 views

SQL Server Management Studio 2012 - horrible blue background [closed]

I've just installed SSMS 2012 and when I loaded it up I was presented with a nasty blue background - it looks so bad that I honestly thought something was broken, but apparently it's supposed to look ...
2
votes
0answers
141 views

always on availability group with different speed disks

I'm looking to set up SQL Server 2012 installation with an Always On Availability Group, where the 'passive' replica will be hosted at another site on the WAN and using synchronous data commit - the ...
0
votes
1answer
213 views

Full text query slow on first run [closed]

I have SQL Server database which has size of 65GB and 6 million rows. We have essays in tables and the average size of an essay is 450 words. When I run a query for the first time, it takes 3-10 ...
2
votes
0answers
191 views

A Tool to Manage Tracking Query Performance Improvements [duplicate]

I'm building a BI system on SQL Server 2012. I have a test set of data with some tens of millions of rows. Currently many functions and stored procedures are unacceptably slow. I'm looking for a tool ...
1
vote
0answers
131 views

What are some light-weight clients of SQL Server 2012 that can utilize SQL spatial functions? [closed]

We're building our new enterprise database and it will include SQL server spatial (native) data (moved from ArcSDE). This is great news for our SQL analysts who will now be able to consume our spatial ...
1
vote
2answers
769 views

How can I “shift” certain column values to different rows in an existing table?

I'm implementing a queue as a ring buffer in a table along the lines of what Thomas Kejser talks about here: Implementing Message Queues in Relational Databases If the ring buffer fills up, I have to ...
5
votes
1answer
225 views

How to get output from trigger on linked server

Fair warning, I know this isn't the best way to do this, but I'm trying to extend some existing code without needing to do a rewrite. Anyway, I've got two SQL Server 2012 installs, one local in my ...
0
votes
2answers
85 views

Replicate to a secondary database that also allows edits

I have a client with a somewhat odd requirement. They want to be able to take a snapshot of their sales database that their accountants can then use once it's disconnected from the live database. That ...
1
vote
1answer
44 views

Foreign Key off of a UNIONed View

I have a view that looks like this: CREATE view reference.Test WITH SCHEMABINDING as SELECT reference.HighlevelTestId as TestId, Name, IsActive, cast(1 as bit) as ...
1
vote
1answer
355 views

MS SQL Server 2005 DB backup with partitioned tables to non-partitioned SQL Server 2012

I have a database with several partitioned tables on MS SQL Server 2005 Enterprise, and I have to restore this DB on MS SQL Server 2012 Standard. Since Standard doesn't support partitioning - it's a ...
2
votes
1answer
373 views

Inline edit SQL Server database rows from Visual Studio

I'm pretty sure Microsoft have pulled one of the most useful features for performing quick edits on a SQL Server Database within the Visual Studio IDE. It seems to have only affected SQL 2012 ...
2
votes
1answer
81 views

Can you direct Availability Groups to fail over to a particular node?

Can you direct Availability Groups to fail over to a specific node in the cluster?
2
votes
2answers
2k views

After update triggers that deal with multi-row updates

Currently working on an database Audit project based on triggers that are fired on update on specific tables. The triggers write the changes into a table; information written are: table name, updated ...
0
votes
0answers
32 views

The client was unable to reuse a session with SPID XX, which had been reset for connection pooling [duplicate]

We have a recurring problem with one of our MS SQL Servers (Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) ). The error message from the application log: Event Type: Error Event Source: ...
2
votes
1answer
787 views

Ignore login mappings during Dacpac compare

We're trying to automate the deployment of databases through development, testing and production. Our approach, using SSDT, is to compare DACPACs from the different environment to generate update ...
0
votes
1answer
1k views

SQL Server does not exist or access denied from a VMWare guest

I've made the configuration to allow remote connections to SQL Server 2012, however I still cannot connect to it from a VMware Workstation Guest (using both NAT and Bridge). I can ping the host ...
8
votes
1answer
486 views

SSIS 2012 Create environment variable fails

I'm working a script to port an Environment from one server to another. I am running into an issue calling catalog.create_environment_variable wherein I get the error "The data type of the input value ...
1
vote
1answer
784 views

Run job once a minute, every day, except during a certain time

I have a Sql server 2012 agent job which currently runs every minute, every day, etc. I'd like to modify it so that it will run every minute, every day except on Saturdays between 7:00 pm and 11:30 ...
1
vote
2answers
462 views

How do I migrate varbinary data to Netezza?

I got a warning message while migrating DDL from SQL Server to Netezza: Warning: [dbo].[spec_binarymessage].[blobdata] data type [varbinary] is not supported the target system and will be scripted ...
7
votes
1answer
516 views

SSIS organization

I'm familiar with SSMS, but I've never used .net, c# or visual studio (been doing other things: Assembler, c, unix, vi, oracle, etc). I'm trying to figure out basic 2012 SSIS ETL (no BI or data ...
3
votes
1answer
394 views

Sql Server 2012 Extended Events for Selective Xml Indexing not showing results

I created a Extended Event to monitor and tune a Selective Xml Index CREATE EVENT SESSION [SelectiveXmlIndexing] ON SERVER ADD EVENT sqlserver.selective_xml_index_no_compatible_sql_type, ADD EVENT ...
1
vote
0answers
227 views

Can SQL Server 2008R2 SSIS packages access SQL Server 2012 databases with driver updates only?

We have two products running on SQL Server that we will be upgrading to SQL Server 2012 on a staggered schedule. Product B uses SSIS packages (using ODBC drivers) to extract data from Product A's ...
4
votes
2answers
267 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 ...
2
votes
2answers
1k views

Greyed out menu options, broken activity monitor

I recently installed SP1 on my 2012 SQL Server. Ever since then SSMS has behaved a little weirdly when I connect from my pc rather than from the local server itself. I no longer see the green ...
3
votes
0answers
199 views

SQL Server 2012 Management Studio Books Online - Help [closed]

When I use F1 in my SQL Server 2012 Management Studio, it opens Microsoft Help Viewer 1.0 but there is no help content. Adding content is not possible due to the fact that install online and install ...
0
votes
1answer
44 views

Best What's new book about just changes and new features in SQL Server 2012 [closed]

I want to read about new changes and new features in SQL Server 2012.I found some E-Book in the internet but they have basic topics (like create Tables,Views,...) I want a book that just cover new ...
0
votes
2answers
2k views

What is the difference between TCP port and TCP dynamic port?

Can anyone tell me the difference? I tried to set either 1 port and left another blank also can work. I wonder what is the difference, or anything I missed out?
3
votes
1answer
362 views

Will table partitioning speed up my queries?

My database is set up with what we call our staging tables and our live tables. Currently for we have about 2 million rows for a table called products. Our customers we call manufacturers load their ...
2
votes
2answers
235 views

Where to store versioned/historized records?

In our application we are using versioning records using triggers. The application is supposed to handle millions of records in the future and the history/versioning tables are there to ensure that ...
0
votes
2answers
2k views

How to select rows which have max and min of count?

I have the following table in SQL Server 2012: CREATE TABLE [MyTable] ( [Id] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT NEWID(), [MyGroup] INT NOT NULL ); I want to output a table of the ...
-1
votes
0answers
743 views

Setup has encountered the following error: Value cannot be null. Parameter name: doc [closed]

I have SQL Server 2008 R2 installed on my server. I want to upgrade it to SQL Server 2012 Service Pack 1. I got this Error during the installation: SQL Server Setup has encountered the following ...
1
vote
1answer
222 views

Full-text Catalog Corruption

I have a SQL Server 2005 database that I backed up and restored onto a new server running SQL Server 2012. So far so good. This morning I had a really bad power outage and the new server went down. ...
1
vote
0answers
278 views

SQL Server 2012 Failover Cluster and attached SAN

I have three servers in a Windows Server failover cluster. SQL Server 2012 Failover Cluster is installed on all nodes. I have an issue with shared disks attached from SAN. overview with the same ...
2
votes
1answer
217 views

Deploying to SSIS catalog and get permissions error

When I attempt to deploy to SSIS 2012 Catalog on new server I get an error. I have researched it on the web for several hours and all of the information available online does not fix my issue.
1
vote
0answers
121 views

What is an incremental checkpoint (in the context of indirect checkpoints)?

I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this: And the details of the selected event are: The ...
4
votes
1answer
2k views

Mapping a shared physical folder to filestream

We are working on a project where we have large amounts of images, texts etc which we need to work on in SQL Server. We were thinking of using Filestream and filetable functionality. However, even ...
0
votes
1answer
260 views

Create Log Shipping Step Failed After ServerName Changed

I was doing some test on server name change and encounter some errors. Here is the original setup: Server name - ServerA, SQL Server default instance - ServerA Changes: Server name - ServerB Before ...
2
votes
1answer
2k views

Problem adding a new node to a SQL Server 2012 Failover Cluster

I tried to add a new node to SQL Server (2012 Standard) Failover, that is already installed on another node in Windows2012 Failover Cluster I have an issue with non editable field wiht input for SQL ...
1
vote
1answer
77 views

Strategies to archive high frequent data in SQL Server

I have a database that stores high frequent data, the data has a complex data model. Now I want to offload/archive this data in 15 minute intervals to another database server so user can do reporting ...
-2
votes
1answer
257 views

How to enter multiple checkbox list items into database for eventual reporting [closed]

(I tried posting this on SO but went unansered. I'll just post these theory type questions here from now on) I'm in the process of creating the first of a few CheckBoxList for a manually created ...
0
votes
1answer
271 views

How can I send HTTP requests from SQL Server 2012 to a non-.Net application? [duplicate]

I know basic only concepts (DDL,DML queries) of the SQL Server 2012. I explain the workflows of both my application and the database below. Workflow of the application: I build web application in ...