This tag is specifically for SQL Server 2012
0
votes
2answers
32 views
Syncronization with transformation
I have the following scenario: a database in SQL Server 2012 that must replicate changes in a transactional way to a SQL Server 2000 database. Since the schemas of two databases differ, a ...
4
votes
3answers
170 views
Get transactions that failed or were never committed
Is there anywhere I can look to find failed transactions in SQL server 2012?
1
vote
1answer
25 views
Do I need to use -f to fix insufficient max server memory settings?
SQL Server Version:
SELECT @@VERSION;
/*
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
*/
Issue:
So, I was playing ...
1
vote
0answers
44 views
How do I maintain more audit history?
I created a SQL Server audit and when I view the audit logs I only see today’s audit. I am saving it to a file and I want to store audit for one year. Is there a way to store database and server audit ...
2
votes
1answer
50 views
LDAP in SQL Server 2012
In our current system, we query the LDAP using SQL Server 2008R2 but are moving to SQL Server 2012 where we have hit a snag. According to http://msdn.microsoft.com/en-us/library/cc707782.aspx one of ...
0
votes
2answers
49 views
Home rolled gridview search results shows rows that are supposed to be ignored [closed]
Note: I tried posting this on Stack Overflow but didn't get any good bites. I'm still researching this but wanted to see if any db czars can assist here.
I'm in the process of trying to troubleshoot ...
0
votes
2answers
36 views
'skip rows' in a flat file source does not work as advertised
In SSIS(2012 specifically) there is an option in the Flat File Datasource to skip a number of lines at the beginning of a file. The preview appears correctly. However, when trying to execute the data ...
1
vote
0answers
37 views
Accessing environment variables at design time in SSDT?
I'm re-designing some SSIS packages for 2012 and some parameter/variable/configuration issues are not clear to me.
The result that I am trying to achieve is that the user context's temp folder(stored ...
-4
votes
2answers
91 views
What are the advantages of sequences in SQL Server 2012? [closed]
I upgraded my SQL Server 2008 R2 to SQL Server 2012, and I had noticed a new feature was added: Sequence.
I don't know the reason of adding sequences when there is an identity property.
Can someone ...
0
votes
0answers
40 views
What collation to use to store characters from the Character Map? [closed]
I have an SQL Server 2012 database with the default collation of SQL_Latin1_General_CP1_CI_AS. I've noticed that certain characters from the Windows Character Map application namely small letters with ...
2
votes
2answers
43 views
On which server does a query execute?
Given two Microsoft SQL servers:
Say ServerA has a view titled "View1":
SELECT * FROM ServerB.database.dbo.Table1 WHERE Column1 IN (1,2,3)
and a stored procedure "sp_Foo":
SELECT * FROM View1 WHERE ...
0
votes
1answer
30 views
Change server name for SQLLocalDB instance
Is there any way to change the instance name of LocalDB of SQL Server 2012 from (LocalDB)\xxxx to just xxxx?
I need it for an application that needs SQL Server DB instance name to be MSSQLDEFAULT.
1
vote
0answers
24 views
FileTable occasionally missing in explorer
I have created 3 folders by using FileTable.
One of the folders has ~392 GB data (with heavy data read/write) and it is not showing up sometimes. I need to restart to SQL Server to make it appear ...
3
votes
0answers
34 views
Full-text search with german umlauts
I created a table using German (Germany) as the Full-text language, in the settings I tried setting accent sensitivity to both sensitive and insensitive. I, however, get following odd results.
The ...
5
votes
2answers
72 views
Permission required to view a database diagram
I have recently set up SSDT for our developers to use. We enforce changes to our dev databases are made through SSDT by limiting the permissions that each developers has when connected to the server ...
0
votes
0answers
26 views
SQL Server 2012 linked server to SQL Server 2000
I am trying to select through an linked server from SQL Server 2012 to SQL Server 2000.
The linked server has been setup and I can browser the target database through the linked server which ...
2
votes
2answers
58 views
Can I install SQL Server 2012 on a machine with 2008 R2 already?
I have been using SQL Server 2008 R2 for quite a while, and it is working great. Now I need to use SQL Server 2012. Will this effect my existing databases? How much risk is involved in installing SQL ...
4
votes
0answers
55 views
Indexing strategy for dynamic predicate
Assume SQL Server 2012 Standard edition.
My database has a table with 500 million rows. The table has about a dozen columns, none of which are very wide (some varchar(100)'s and some ints).
The ...
0
votes
1answer
37 views
Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012
I have two local SQL Server instances running on my local machine. The first is SQL Server 2008 R2 Enterprise Edition (named MSSQLSERVER) and the 2nd is SQL Server 2012 Business Intelligence Edition.
...
3
votes
2answers
47 views
Create database role to allow read access to all tables; write access to some
We have a database with over 1000 tables. I need to create a role that allows read only on all tables, as well as write access to two specific tables.
I was messing around with database roles, but ...
2
votes
1answer
73 views
Execution Plan not matching Stored Proc
Below is a stored proc to count the number of widgets made in a month. If no widgets are made, no records will exists.
The execution plan shows an INNER JOIN of the M and A tables, where in the ...
1
vote
2answers
72 views
Format function returning minutes instead of months?
While exploring the new function FORMAT I have come across the following issue, would like to know if any one else has faced a similar problem and found the fix for this, or if it is a bug?
SELECT ...
2
votes
2answers
79 views
Does Change Data Capture (CDC) work in a SQL Server 2012 AlwaysOn Failover Cluster Instances setup?
Does Change Data Capture (CDC) work in a SQL Server 2012 AlwaysOn Failover Cluster Instances setup?
There would be two nodes in the AlwaysOn Failover Cluster Instances setup and two Domain ...
0
votes
1answer
35 views
SQL server 2012 upgrade causing reindexing to take a long time / fill up log file
I have a customer who has upgraded their SQL Server from SQL Server 2005 to SQL Server 2012. According to them, no other changes were made. They have an ERP database which does a full reindex once a ...
7
votes
2answers
282 views
Is a geographically distributed application with SQL Server replication a good idea?
We are currently thinking about a target architecture for a geographically distributed application.
This application tracks and schedules the movements of all material units across various production ...
1
vote
1answer
29 views
Sql Server 2012 and native client 10
What is the difference between SQL Server Native client versions 10 and 11? Can I use Native Client 10 with SQL Server 2012 running?
4
votes
1answer
47 views
How much data can SQL Server full text indexing handle?
I realize that the question is vague and it depends on hardware and our needs.
We currently have 5 million rows of data, a total of 5GB of data which we want to index using full text indexing. Our ...
4
votes
3answers
74 views
memory used by Locks
I am kind of curious, one of SQL 2012 enterprise edition with 128 GB of RAM size of database is 370 GB and growing, amount of memory used by locks (OBJECTSTORE_LOCK_Manager) memory clerk showing ...
0
votes
1answer
64 views
Efficient way to fetch records since a given criteria
I'm trying to implement a logic where the user can say give me n records since a given id#. E.g.
SELECT TOP (100) col1, col2, ... colN
FROM Table1
WHERE ID > @id
ORDER BY ID
Performance is the ...
0
votes
0answers
20 views
Aggregate query on multiple values of same field [migrated]
I am using sql server 2012, I have a table of credit card transactions as follows:
CardScheme RespCode
=========================
Visa Declined
MasterCard Approved
MasterCard Approved
...
0
votes
1answer
37 views
Statistical Analysis of Data that has to be done in an order?
Bear with me - that is the first time try that in SQL Server, normally I have been doing that on the front end ;)
I a implementing some analysis on time coded data series. This is not super ...
1
vote
1answer
87 views
SQL Server Memory for Backup Buffer
In SQL Server 2012 memory for backup buffer comes from buffer pool or non buffer pool (VAS)? Is this behavior changed between SQL server 2008 R2 and SQL 2012?
EDIT: Does MAX Server Memory ...
2
votes
0answers
73 views
Why does GO affect my SELECT? [closed]
I am experiencing a very weird behaviour from the Management Studio GO.
I am following the full-Text Search tutorial and I run the following query over adventure works
SELECT ...
1
vote
1answer
32 views
Is there any way to Restore a Database from newer version to an Older Version of SQL Server? [duplicate]
I am having a database backup file from SQL SERVER 2012 and i wanted to restore it on SQL SERVER 2008R2 .
If we can’t restore a SQL Server 2012 database to earlier version what is the next best ...
0
votes
4answers
69 views
How do I deal with FK constraints when importing data using DTS Import/Export Wizard?
I am trying to use the SQL Server Import and Export Wizard to copy data from my production db to my dev db but when I do it fails with the error "The INSERT statment conflicted with the FOREIGN KEY ...
0
votes
1answer
63 views
Remove specific duplicates (all but latest)
When removing duplicate rows, using the below query from this tutorial, how would I go about forcing which of the found duplicates to remove?
DELETE FROM dbo.ATTENDANCE
WHERE AUTOID NOT IN ...
2
votes
1answer
52 views
SQL Windowing function to create a running total
I need some help with windowing functions.
I have been playing around with sql 2012 windowing functions recently. I know that you can calculate the sum within a window and the running total within a ...
1
vote
2answers
43 views
Where should I look for details about 'access denied' errors?
This question derives from Deploying a new database on a new server, an msbuild ssdt rookie issue.
Since I have a permission denied error, I expect to find which user is failing to access so I can ...
3
votes
2answers
81 views
SQL Server 2012 installation silently fails
I am trying to install SQL Server 2012 running setup.exe on 64-bit windows 8. After the "please wait" dialog, the installation center comes up. I chose "New SQL Server stand-alone installation", ...
5
votes
1answer
106 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
61 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
44 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 ...
2
votes
1answer
209 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 ...
3
votes
0answers
31 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 ...
2
votes
0answers
33 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 ...
-1
votes
1answer
51 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
------------- --------------- ...
4
votes
1answer
72 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 ...
2
votes
0answers
47 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
84 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 ...
-1
votes
0answers
28 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 ...
