Tagged Questions
0
votes
1answer
19 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
34 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
49 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
48 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 ...
-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
39 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 ...
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.
5
votes
2answers
71 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
24 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
54 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
36 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.
...
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
77 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
279 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?
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
86 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
68 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
61 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 ...
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
80 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
103 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
43 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
202 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
46 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
83 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
vote
1answer
43 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 ...
1
vote
2answers
102 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
vote
3answers
81 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
99 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 ...
-2
votes
1answer
28 views
Adding Roles in SQL SERVER 2012 failover clustering [closed]
Is the Application Role required for SQL Server failover cluster
2
votes
0answers
35 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 ...
7
votes
2answers
159 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
2answers
61 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 ...
0
votes
3answers
158 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
45 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
69 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
103 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, ...
1
vote
1answer
51 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 ...
