This tag is specifically for SQL Server 2012
2
votes
1answer
52 views
Start service error code 3417 with SQL Server 2012
I cannot start the SQL Server 2012 service. The event log says the service-specific error code is 3417.
In the Event Viewer:
The SQL Server (MSSQLSERVER) service terminated with the following ...
4
votes
0answers
30 views
Troubleshooting SOS_Scheduler_Yield wait
Running our corporate ERP (Dynamics AX 2012), I noticed our production environment seemed much slower than our development systems.
After performing the same activities in both the development and ...
2
votes
2answers
35 views
Performance effect of indexing foreign keys
My database is for an HR application with performance reviews and I am interested in whether I should index my foreign key.
There are two tables involved. The first is a ratings table with 2 columns: ...
1
vote
1answer
40 views
Startup procedure for availability replica becoming primary
Is there any way how to create a startup T-SQL script/procedure for starting availability replica (when state has changed from secondary to primary)?
I want to disable SSIS jobs specific for related ...
1
vote
0answers
18 views
PowerPivot doesn't install in SharePoint mode on an Active/Passive Cluster
We a provisioning a new SQL Failover Cluster. We have successfully configured the SQL instance, and have moved on to configuration of the PowerPivot for SharePoint instance. We run the configuration ...
3
votes
0answers
21 views
custom population of full text index
Is there any way to populate a full text search index without storing the backing information in the database?
I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
-1
votes
1answer
28 views
Why does fn_my_permissions return empty rowset? [closed]
If I run this query:
select * From fn_my_permissions(NULL, 'SERVER')
This is what I'm getting:
entity_name subentity_name permission_name
------------- --------------- ...
2
votes
0answers
28 views
Server permissions of an activation stored procedure of a Server Broker queue
I have a stored procedure that queries the sys.dm_exec_requests view. In the stored procedure the view only returns one row, while the stored procedure needs to see all of them. The MSDN article on ...
3
votes
1answer
44 views
Convert SQL Server 2012 SSIS package to 2008
I've created a few SSIS packages in SQL Server 2012 that I need to run on SQL Server 2008. I've been told that it is impossible in their current state.
Is there a way to convert the 2012 packages to ...
1
vote
4answers
83 views
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 ...
2
votes
0answers
32 views
Coerce columnstore to operate in batch mode
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 ...
2
votes
2answers
145 views
Best practice for tempdb log file
I have read many blogs here and there about how to configure tempdb data files but i didnt found any information regarding the tempdb log file.
Here's the strategy that I'm presently using with my ...
1
vote
2answers
103 views
How to backup to local drive and network drive simultaneously?
I can backup to a 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 ...
6
votes
0answers
95 views
+50
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 ...
1
vote
2answers
51 views
SQL Server Memory Clerk Description
Trying to understand different memory clerks reported by sys.dm_os_memory_clerk however, not able to find description of the each individual memory clerk either on web (google and binged) or in SQL ...
2
votes
0answers
29 views
Failover only working for Classic ASP, not ASP.net
Setup:
All machines run Windows Server 2008 Enterprise
SQL Server 2012 Standard (Primary)
SQL Server 2012 Standard (Mirror)
SQL Server 2012 Express (Witness)
Root issue: Our ASP.NET application is ...
1
vote
2answers
49 views
Dictate edition during unattended install?
I am creating an automated build of SQL Server installation which is run from a batch file. Is there any way to change the registry, or other method, of deciding which SQL Server edition (Either ...
-1
votes
0answers
27 views
DAX's level of Business Logic [closed]
From what I have seen about DAX's ability, is it used for doing advanced business logic to be enable to do advanced calculation in the same level as a C sharp developer?
Would you see that DAX's ...
1
vote
2answers
48 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?
2
votes
2answers
65 views
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 ...
1
vote
2answers
85 views
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 ...
0
votes
1answer
36 views
Manually entering data using Management Studio
How can I enter data through the GUI interface rather than an insert command in SQL Server Management Studio 2012? I can't find it anywhere whereas there used to be an option in the previous versions. ...
0
votes
1answer
17 views
Is there 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? ...
2
votes
2answers
194 views
Accessing a network share via a SQL Server 2012 Availability Group
If you have a SQL Server Cluster called CLS, with machines CLS1 and CLS2, accessing:
\\CLS\network\path
is equivalent to accessing either
\\CLS1\network\path
or
\\CLS2\network\path
depending ...
1
vote
1answer
39 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 ...
3
votes
0answers
27 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 ...
1
vote
1answer
68 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 ...
2
votes
2answers
80 views
Suspended in index rebuild
In SQL Server 2012, an Index Rebuild job is taking a very long time (up to 8 hours). However, not even one Index rebuild completed, so I stopped the index job.
In monitoring SQL task:
state = ...
1
vote
3answers
70 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.
...
6
votes
2answers
103 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 ...
-2
votes
1answer
23 views
Adding Roles in SQL SERVER 2012 failover clustering [closed]
Is the Application Role required for SQL Server failover cluster
2
votes
2answers
166 views
SQL Server service shutdown due to 'bad?' SSL cert
This morning it transpired that SQL Server 2012 service running on Win2012 had shut itself down. When I logged in as the server admin and tried to access SSMS, after entering my credentials I got the ...
1
vote
1answer
21 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 ...
0
votes
2answers
42 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
votes
0answers
34 views
Abot SQL Server's Tabular [closed]
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 ...
1
vote
1answer
224 views
Alternative tools to export Oracle database to SQL Server?
I've got an Oracle database that I need to export (schema and data) to SQL Server.
I am trying the Microsoft SQL Server Migration Assistant for Oracle, but it is horribly slow, grossly inefficient ...
0
votes
3answers
143 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 ...
1
vote
1answer
53 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 ...
0
votes
0answers
31 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 ...
6
votes
1answer
105 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 ...
3
votes
0answers
58 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
1answer
45 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
0answers
33 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
83 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 ...
1
vote
1answer
73 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?
3
votes
1answer
163 views
Cross Database transactions - Always on
Recently we are working on a POC to get Always on work and happened to see this article in BOL
http://technet.microsoft.com/en-us/library/ms366279.aspx
This article suggests that there would be ...
0
votes
0answers
97 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'
...
0
votes
2answers
53 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 ...
1
vote
1answer
51 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 ...
2
votes
2answers
93 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 ...
