This tag is specifically for SQL Server 2012
1
vote
1answer
26 views
Data Migration from Oracle to SQL Server [duplicate]
If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice?
Our database has about 100 million rows and a total of 52 ...
2
votes
0answers
19 views
How to configure SSRS (SQL Server 2012) to run on a different instance, but same server as SharePoint
I have an instance of SQL Server 2012 running on Windows 2008R2 along side another instance of SQL Server 2012 that is running SharePoint (I think it is SharePoint 2010).
When I try to access the ...
0
votes
1answer
13 views
In SQL Server 2000 or greater is their a system primary key associated with each row
Does a system primary key or unique identifier for each row in a table exist? Like @@ROWID, @@IDENTIFER, or some other identifier that uniquely identifies each row regardless of how it was created. ...
1
vote
1answer
64 views
SQL Server clustered index high fragmentation
I've got a Table with an Integer (4bytes) as primary key. it's defined as an identity. it is also the clustered index.
Inserts are working perfectly fine. After inserting 2000 rows the fragmentation ...
-1
votes
1answer
29 views
Manually Entering Data into a SQL Server Management Studio 2012 rather than through the Insert Query
How can I enter data through the GUI interface rather than the SQL "insert" query statement in SQL Server Management Studio 2012. I simple can't find it anywhere whereas there used to be an option in ...
1
vote
3answers
65 views
Improve performance by partitioning
I'm using SQL Server 2012. I’m using CTE to create an orders table from the items table. The final count for the orders table is around 120 million. It is taking about 2 hours for the whole process.
...
1
vote
2answers
72 views
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong
I have 2 missing records in SQL server and I am trying to identify the problem that caused this issue.
New records are inserted using a Stored Procedure, which will return an error code to the ...
-2
votes
1answer
21 views
Adding Roles in SQL SERVER 2012 failover clustering [closed]
Is the Application Role required for SQL Server failover cluster
2
votes
0answers
28 views
Batch mode in SQL Server
I want to try the column store index in SQL Server and im trying to get my queries to run in batch mode, i rewrote my query this way( it had an outer join before) but the execution plan still show ...
1
vote
1answer
20 views
Restore a Single File from FileStream
We have an document management application uses SQL Server 2012 to store document index information and uses a Windows file share to store the documents. We are working on migrating to store the ...
5
votes
2answers
86 views
SQL Server 2012 Simple Recovery Model with LOG_BACKUP log_reuse_wait_desc
While I'm doing my own investigation, does anyone know why a database in SIMPLE recovery model has a LOG_BACKUP for the log_reuse_wait_desc?
SQL Server 2012 SP1. No replication, no mirroring, no log ...
0
votes
0answers
24 views
Abot SQL Server's Tabular
Goal:
The goal is to view if SQL server 2012 tabular and its in-memory ability with can be used in relation to PowerView, Excel and Reporting service at the same time. No different instance shall be ...
0
votes
2answers
35 views
Remove collation from all database columns
I have a SQL Server database where the collation is set on it. However I am running into problems as the collation on some columns in the database varies from the database collation.
I would like to ...
1
vote
4answers
73 views
SQL Server simple model database transaction log full 'CHECKPOINT'
I have a SQL Server 2012 SP1 database which has a problem that the transaction log is full. It consists of a single data file and a single log file, both about 800MB.
I had 5GB free disk space, and ...
0
votes
3answers
139 views
AlwaysOn Architecture - SQL Server 2012 for creating a dev environment?
I was thinking if the AlwaysOn architecture in SQL Server 2012 can be leveraged somehow to create a replica for DEV and QA environment properly in addition to setting up HADR using the same ...
0
votes
0answers
29 views
SSMS 2012 error message: evaluation period expired despite Edition Upgrade
Problem similar to this one only with SQL Server 2012. None of the suggested registry edits have worked. This problem was supposed to have been fixed back in 2008 SP1.
Here's the sequence of ...
1
vote
1answer
46 views
Merge Statement + Replication difference for SQL Server 2012
We have a SSIS package that will pull from a source database and run a merge statement to put the data into a "Master" database. (Eventually the "Master" database will be the source of truth, but we ...
3
votes
0answers
47 views
SQL Server Browser uses NT AUTHORITY\SYSTEM account and logon failure error in SQL Log
Using SQL Server 2012 on Windows 2008 R2
I have been getting errors in SQL Logs for failed login for NT AUTHORITY\SYSTEM.
All of SQL Server's services are running under their own Domain accounts, ...
3
votes
0answers
40 views
Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing
We are using SQL authentication & .net 4.0 Connection strings to connect to an Enterprise Edition 2012 SP1 SQL Server on a windows 2008r2 Enterprise Server. We use about 50 Servers split into 8 ...
0
votes
0answers
26 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
1
vote
1answer
82 views
Total Memory used by SQL Server (64 bit)
My knowledge on the subject suggests that perf counter SQL Server:Memory Manager: Total Server Memory only gives you buffer pool memory. There is a column called physical_memory_in_use in a DMV named ...
0
votes
0answers
82 views
How to create table set from several XSD in SQL Server 2012 or with VS 2012
Is there any solution in T-SQL or in C# how to create XML schema collection in T-SQL or C#?
Problem is I cannot use:
USE Database_test
GO
CREATE XML SCHEMA COLLECTION Collection_from_XSD AS
N'
...
1
vote
1answer
49 views
Can I use Try_Cast to give me a query result column with different datatypes?
I have a column that is varchar(max). It contains mostly valid XML. But sometimes it has invalid xml (that I still need).
I am trying to make a view for this table that allows the value to display ...
3
votes
1answer
44 views
Selective Xml Indexing
I have recently been researching Selective Xml Indexing and have been trying to figure out how to index a .query method
If I have the below query
WITH XMLNAMESPACES (Default ...
0
votes
2answers
49 views
What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
During the installation of SQL Server 2012, in the Collation tab, i can choose between French_CI_AS and French_100_CI_AS.
What do they mean and which one is newer? When there's no Code, is it newer ...
2
votes
2answers
87 views
Restoring differential backup from SQL Server 2005 to SQL Server 2012
We are migrating a client to a new server. Their old server has SQL Server 2005. I have attempted to perform a differential backup however I received an error about the LSN chain being broken.
Please ...
1
vote
1answer
70 views
Service accounts for SQL Server 2012 only allow pre-Windows 2000 name?
I've just set up SQL Server 2012 with domain service accounts. I found that the account name would not validate unless I used the shorter user name.
Is there any way of using the full names?
2
votes
2answers
59 views
SQL Server: The multi-part identifier “xxx” could not be bound
The following is a HAVING clause from a small part of a very large stored procedure which I have inherited from some other devs (external);
HAVING (SELECT COUNT(*) FROM
(
SELECT *
FROM ...
0
votes
3answers
64 views
DB comparer field by field for all tables
I have a liveDB and I have a development DB. Now when I make a change to development DB, I want to find out the changes later when I am deploying my application on server. For eg. I may have added ...
1
vote
1answer
59 views
Restoring SQL Server 2012 database onto 2008
I am trying to restore a SQL Server 2012 database after I set the compatibility level to SQL Server 2008 by following the instructions as listed on: ...
2
votes
0answers
89 views
Why does CREATE INDEX … WITH ONLINE=ON block access to the table over a period of minutes?
I have an existing table:
CREATE TABLE dbo.ProofDetails
(
ProofDetailsID int NOT NULL
CONSTRAINT PK_ProofDetails
PRIMARY KEY CLUSTERED IDENTITY(1,1),
ProofID int NULL,
...
0
votes
1answer
25 views
How to access SQL Server 2012 on EC2 server from my ASP.NET website published on the same EC2 server?
My site is not able to establish a connection to the SQL Server 2012 from EC2. My connection string is as follows:
Data Source=AMAZONA-2SSRDM3;Initial Catalog=MyDatabase;Integrated Security=SSPI;
...
4
votes
0answers
54 views
“Arithmetic overflow” when initializing SQL Server 2012 replication from backup
I'm initializing SQL Server replication from a backup, by following instructions from here:
http://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/
...
3
votes
0answers
32 views
Database mirroring - worked once?
I setup SQL Server 2012 Standard on 2 different servers and installed SQL Server 2012 Express on a Witness server. All 3 servers are running Server Enterprise 2008 R2.
I'm using these instructions:
...
3
votes
1answer
39 views
tempdb logs on same drive as tempdb data or with other logs?
For many reasons I only have 3 hard drives (RAIDed and in an Always-On AG) for all my database files:
D: Data
E: Logs
F: Tempdb
Should the tempdb log file go on F: with the data file(s) or on E:?
...
1
vote
2answers
70 views
Will SSIS 2012 work with SQL Server 2008R2 (not integrated)
Our company has SQL Server 2008R2 and plans to upgrade to 2012 in late 2013 or early 2014. I would like to use SSIS 2012 now as we do have the software.
We have a company policy where we cannot run ...
4
votes
1answer
70 views
SQL Server 2012 indirect checkpoint
I am trying to understand where to draw a fine line for Indirect Checkpoint that was introduced in SQL Server 2012.
Based on my understanding
SQL Server does checkpoint to flush dirty pages out to ...
4
votes
2answers
70 views
Transactional Replication Concerns
We are debating an architecture that employs sql server 2012 and transaction replication. Idea is to offload reporting activity to a secondary server and have the ability to include/exclude what is ...
5
votes
2answers
115 views
How do I change SQL Server 2012 Availability Group DNS subdomain?
Questions: how can I get my availability group to be registered as ag-ewgtest.sql.company.com given that my server thinks of itself as server.company.com.
Setup: my SQL Server 2012 availability ...
1
vote
2answers
45 views
Can we Configure Change Data Capture in another Database?
I want to apply Change Data Capture(CDC) to database DB1's tables and want to log everything in DB2.
So, could it be possible to capture table DB1's changes to DB2?
1
vote
1answer
88 views
how to create a database backup in network drive along with local drive in sql server 2012 Standard Edition
--local drive and mirror
BACKUP DATABASE [xxx]
TO DISK = N'XXXX.bak'
MIRROR TO DISK =N'Network path \XXX.bak'
WITH INIT
--directly to network drive
BACKUP DATABASE [xxx]
TO DISK = N'Network path ...
5
votes
2answers
117 views
How best to maintain SQL log file sizes
I'm somewhat of a new DBA and I'm managing a SQL Server 2012 instance that has a fair amount of activity. I'm running in Full Recovery mode because we need point in time recovery.
Right now, I'm ...
1
vote
1answer
58 views
Paging in SQL Server 2012 vs. previous versions
I have used lot of paging code in SQL Server 2008. The format is
With CTE(
-- SQL With RowNumber
)
-- SELECT ALL Page N
This is working fine. But I have heard that SQL Server 2012 has better ...
0
votes
1answer
33 views
Change SQL Server 2012 Version from registry?
I am creating an automated build of SQL Server which is run from a batch file. Is there any way to change the registry, or other methoid, of deciding which SQL Server version (Either Enterprise or ...
1
vote
1answer
42 views
How can I identify the number of times a View is called in SQL Server?
How can I identify the number of times a View was called in SQL Server?
I am looking for an answer that is similar to this below which shows how it can be done for stored procedures.
How can I ...
3
votes
3answers
91 views
Conditional WHERE Clause in a Table Valued Function
I have a table valued function
CREATE FUNCTION [dbo].[DateRange]
(
@StartDate date,
@EndDate date,
@Location varchar(25),
@Device varchar(25)
)
...
2
votes
2answers
75 views
Identity proceeds as normal, but with a leading 10…?
So I noticed a very strange thing when tinkering with my database.
I had just inserted a row which was ID 47, then after inserting some more, I realised that somehow my Identity had skipped all the ...
6
votes
2answers
126 views
How to flatten results of a table with two related “many” tables?
I've reorganized some tables in my database to be more flexible but I'm not really sure how to write the SQL to extract meaningful data from them.
I have the following tables (somewhat abbreviated ...
1
vote
0answers
32 views
Does SQL Server place shared locks on scanned records when using REPEATABLE READ [duplicate]
Assume a SQLCmd session which is using transaction isolation level REPEATABLE READ.
In this session I start a transaction and execute an UPDATE statement with a WHERE clause on a non indexed column. ...
6
votes
1answer
98 views
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR
We have a process that generates an inventory report. On the client side, the process splits of a configurable number of worker threads to build a chunk of data for the report that corresponds to one ...
