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

learn more… | top users | synonyms (2)

1
vote
2answers
75 views

Recommended best practice for server naming [closed]

We're currently in the process of upgrading to SQL Server 2012, in the past all servers have been installed with a naming convention which contains a "-" in the middle i.e. TS-DBL01 I'm trying to ...
7
votes
1answer
603 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 ...
2
votes
0answers
151 views

TDP setup for SQL Server databases [closed]

I am looking for any tips/steps used by the DBA's for install and configuration of TDP backup for SQL databases. Hope this meets the criteria for the forum. Thanks
4
votes
3answers
132 views

Enforce Schema-bound views

For reporting purposes, I need to be able to query dependencies between views and underlying tables at column level (via sys.sql_expression_dependencies). One way to get SQL Server to store ...
4
votes
0answers
2k views

High CPU in SQL Server supporting SharePoint databases while running FAST search crawl

I have a a SQL Server 2012 (SP1) #cu5 (X64) instance used as SharePoint 2010 back end and for the most part use only 10 - 30% CPU but there is a high CPU usage when running FAST search crawl(both ...
-1
votes
1answer
1k views

Is my SQL Server 2000 connection string compatible with SQL Server 2012?

Currently I have an application in Visual Basic 6. This application connects to a SQL Server 2000 server using a Data Link file (.UDL) through the OLE DB provider for SQL. The server will be ...
1
vote
0answers
3k views

MS SQL Server - Login timeout expired

I am doing this tutorial of Microsoft: Basic Data Mining Tutorial http://technet.microsoft.com/en-us/library/ms167167.aspx I am using SQL Server 2012 and SSIS - SQL Server Integration Services but I ...
1
vote
1answer
61 views

Changes to main Database during Transactional Replication

Can you please advise how can I keep slave database up to date while it's in transactional replication with master. I mean what If I change indexes, columns, tables or sthm else in master dabase? ...
1
vote
0answers
93 views

SQL Server scheduled backup to Azure Table bacpac

I moved my database from Azure SQL to Windows Server 2008 R2 + SQL Server 2012 Web edition virtual machine on Windows Azure. The Azure SQL provided automated backup to Azure Table as bacpac file. It ...
4
votes
1answer
649 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 ...
1
vote
1answer
300 views

Creating plan guide for query called through sp_executesql

To make a long story short, I have a view called vwRelatives which uses CTE recursion to build family trees. It's meant to be queried for a single person at a time. This runs in about a quarter ...
2
votes
0answers
686 views

Microsoft Sql Server 2012. 100 000 000 rows table select/insert performance [closed]

This is first time i am working with huge database ( 100 million rows in table Events). Use case here is to quickly select and insert x and y for selected Organisation and datetime. My database ...
1
vote
2answers
762 views

Hierarchy of Employee “names” with CTE: Cannot create a correct version

I am trying to create the correct structure of my sql (CTE) query, but I can not. This is a version I want to have . And this is my current version: . As you can see there are duplicates and i have ...
2
votes
3answers
530 views

Uniqueidentifier vs. IDENTITY vs. Material Code --which is the best choice for primary key? [closed]

Which one is the best choice for primary key in SQL Server?There are some example code: Uniqueidentifiers e.g. CREATE TABLE new_employees (employeeId UNIQUEIDENTIFIER DEFAULT NEWID(), ...
1
vote
1answer
1k views

Fastest mechanism to move data between tables in SQL server

We are building a data warehouse. For some of our target tables, the only way to manage the process correctly is to re-transform all the data every time something changes. Currently we do this using ...
9
votes
2answers
3k views

SQL Server's READ COMMITTED SNAPSHOT vs SNAPSHOT

I was researching the differences between SQL Server's READ COMMITTED SNAPSHOT and SNAPSHOT isolation levels and came across the following resource: Choosing Row Versioning-based Isolation Levels ...
8
votes
1answer
1k views

Using SQL Server 2012 Standard with Bitlocker

We're trying to use Bitlocker to secure an SQL Server 2012 database. We don't have any issue getting bitlocker to work... the issue we have is that once the drive is locked, SQL Server can no longer ...
9
votes
2answers
427 views

Improving the performance of STIntersects

Table T_PIN has 300,000 pins and T_POLYGON has 36,000 polygons. T_PIN has this index: CREATE SPATIAL INDEX [T_PIN_COORD] ON [dbo].[T_PIN] ( [Coord] )USING GEOGRAPHY_GRID WITH (GRIDS =(LEVEL_1 = ...
2
votes
2answers
1k views

SQL Server Transactional replication failed due to snapshot agent failure

I'm trying to set transactional replication between 2 SQL Server 2012 named instances. I've followed a step by step manual and created a Publication. But once I look into Replication Monitor I Get ...
4
votes
2answers
567 views

SQL Server 2012 CPU spike due to LinkedServer - how to find the offending query?

As part of another question (SQL Server 2012 performance issues (maybe due to linked server)) I've identified a CPU spike to be directly related to a spike in Bytes Received, which leads me to believe ...
0
votes
2answers
67 views

SQL server 2012 on Windows server 2012

I know this is a basic question. but I can't find any answer on the internet. I know SQL server 2012 is running on Windows 2012 server but when I look at the start page (it has IE, Control panel, task ...
1
vote
1answer
1k views

SQL Server 2012 Express Report Services report builder button not visible

I am trying to run SQL Server 2012 Express Report Services on Windows 7. I finally have it configured, but I'm not sure the missing steps that is preventing the Report Builder button from being ...
11
votes
1answer
1k views

SQL Server 2012 Standard server with 50 instances won't uninstall instances

I suspect this is an issue because we hit the 50 instance max limit of SQL Server. At the limit it won't install more instances, naturally. However, it seems it won't UNinstall them either. That's ...
0
votes
1answer
240 views

Issues installing SQL Server 2012 [closed]

I am trying to install SQL Server 2012. During the install I get an error saying Error installing SQL Server Database Engine Services Instance Features A network-related or instance-specific ...
1
vote
2answers
40 views

Fail plan on a release to production with differential backup

I am currently looking into a fail plan when we do a release to our production server. The context Currently we have one single production database (also production and testing but they are not ...
6
votes
0answers
926 views

SQL Server 2012 performance issues (maybe due to linked server) [closed]

Summary of the problem We've spit our one database server environment into two servers. We are now having intermittent performance issues I am hoping someone can offer clues - perhaps direction ...
2
votes
2answers
806 views

How to configure data collection in SQL Server 2012?

In SSMS of SQL Server 2012 Enterprise on Windows Server R2 Standard, each time I am trying to set sub-option "On demand" of option "Non-cached - Collect and upload data on the same schedule" of Data ...
1
vote
1answer
241 views

Why is my database becoming suspect?

Here is my situation: restored a known good backup (works fine on other machines) that originated on Sql Server 2012 onto a local 2012 install. Created DB as part of the restore. No errors reported. ...
1
vote
1answer
821 views

Removing Secondary Replica from SQL Availability Group Causs Large Log File

Due to an unforeseen hardware error, I had to take our secondary replicas down for maintenance. This was really due to a storage issue and, it was decided at a higher level, to purchase a new storage ...
4
votes
2answers
458 views

SQL Server 2012 autoupdate statistics default behaviour

I found, that since SQL Server 2008 R2 there is a trace flag 2317 available. It turns on dynamical autoupdate statistics threshold, instead of default threshold of 20%. So, it greatly improves ...
1
vote
0answers
1k views

How to debug problems with SQL Server multiserver (Master and Target server) administration?

I've tried to set Mater and Target Servers on various cobinations of SQL Servers 2012 R2 on Window Server 2008 R2 and Windows 7 machines but always getting one or 2 of the following errors during ...
3
votes
1answer
283 views

SQL Server: Can Page Verify be set to Checksum on any database, or must I check compatibility?

In Microsoft SQL Server, I have some older databases set to "Torn Page Detection" rather than "Checksum" page verify. Do I need to determine if a given SQL Server database is 'compatible' with the ...
5
votes
1answer
6k views

Access Denied error in CREATE DATABASE … FOR ATTACH

I'm attempting to attach a copy of msdb to my workstation SQL Server 2012 Developer Edition on Windows 8.1 in an attempt to mimic the problem detailed in this question where the OP is attempting to ...
4
votes
1answer
5k views

Comparing two queries in SQL Server 2012

I am comparing two queries in SQL Server 2012. The goal is to use all of the pertinent information available from the query optimizer when choosing the best query. Both queries produce the same ...
-1
votes
0answers
7k views

Errors trying to install SQL Server 2012 on Windows 7 [closed]

I am getting the above error message when i try to run the setup file. Microsoft SQL Server 2012 Service Pack 1 Setup The operating system on this computer does not meet the minimum ...
0
votes
1answer
180 views

Which index types do not support online index rebuilds?

In SQL Server 2012 Enterprise Ed., which index types do not support online index rebuilds? and why? and which activity-operations can prevent online index rebuilds?
1
vote
2answers
59 views

What does enabling containment on server incur?

Having read in a book of Patrick LeBlank "Microsoft® SQL Server® 2012 Step by Step": "Benefits and limitations of contained databases As with most features, there are benefits and ...
2
votes
1answer
2k views

VS2012 setup spoils SQL Server 2012 Data Tools for everybody or just me?

On Windows 7 Prof I have installed SQL Server 2012 R2 with, as I am pretty well remember, client tools. Then, I tried to install Visual Studio 2013 Ultimate but failed. Then I've installed VS2012 ...
0
votes
0answers
509 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
1answer
310 views

sys.dm_os_volume_stats return no result

Version - SQL Server 2012 SP1 CU3. I have been using sys.dm_os_volume_stats for a while and it was working. Recently I have not been able to return any result from this DMF on one SQL Server 2012 ...
1
vote
2answers
1k views

How to get columns from system tables or views like sys.database_files (SQL Server 2012)

How can I write a query to return all columns of, for example, the sys.database_files table? I see many suggestions for using information_schema.columns for getting table names for user ...
5
votes
3answers
430 views

How do I find all tables in a DB that have no explicit primary key?

A Google search spewed forth millions of hits on how to find tables without clustered indexed, the PK normally being the clustered index of a table. However, a table could easily have a natural key as ...
0
votes
0answers
1k views

SQL Server 2012 - The application has failed to start because its side-biy-side configuration is incorrect

When opening Sql Server Management Studio I'm getting the following error message: Then when I have a look at the Event Viewer the following message is displayed related to this: Activation ...
10
votes
3answers
650 views

Optimizing a CTE hierarchy

Update below I have a table of accounts with a typical acct/parent account architecture to represent a hierarchy of accounts (SQL Server 2012). I created a VIEW using a CTE to hash out the hierarchy, ...
2
votes
0answers
25 views

optimizing a CTE Hierarchy [duplicate]

I have a table of accounts with a typical acct/parent account architecture to represent a hierarchy of accounts (SQL Server 2012). I created a VIEW using a CTE to hash out the hierarchy, and on the ...
1
vote
0answers
276 views

I can not seem to turn this while loop in a recursive cte

There is a very frustrating side after 2 days ... but hey, I submit myself and I ask: o (   I Can not Seem To turn this while loop in recursive CTE ... If someone could help me please. I would like ...
0
votes
0answers
298 views

Speed of one big insert vs multiple small inserts on SQL Server

I have a write-heavy application in which my initial testing has shown that one large insert into a table with four "large" columns is significantly faster than four inserts (in a single transaction) ...
1
vote
1answer
3k views

Any way to import-export-migrate-save-restore a maintenance plan without having SSIS installed (and running)? [duplicate]

I am having dozens of MSSQL Servers 2012 R2 on Windows Server 2008 R2 with similar setup, configuration (in virtual machines) in production. Neither has SSIS installed. I have to similarly maintain ...
0
votes
2answers
184 views

Using IF and other conditions in T-SQL (trying to import data from Oracle using SQL Server SSIS)

I am using SQL Server 2012 SSIS package to fetch data from Oracle and insert it into SQL Server 2012. I am doing it for the first time and every thing is fine i.e. all data from a particular table ...
1
vote
1answer
154 views

Multi-server administration - force poll on target fails, server needs to be registered locally without FQDN

I'm experimenting with multi=server administration on my SQL lab. Running SQL 2012 Enterprise SP1 on Windows 2008 R2 on a domain. I've created a domain account for my sql server agent user on each ...