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

learn more… | top users | synonyms (3)

0
votes
0answers
12 views

Log shipping restore delay of a minute between iterations

On a test database running Log Shipping jobs the initial Restores to catch up performed the first time I run the Restore job seem to have a 1 minute or so Wait time built in. I would have expected ...
1
vote
0answers
14 views

SQL 2012 Always On AG - DBEngine Service account locking

I am having a strange issue and am hoping you guys might be able to help! Problem: I have a 2 node SQL Server 2012 Availability Group Cluster utilising a FSW. Both nodes are using the same DBEngine ...
1
vote
0answers
20 views

SQL Server: dm_exec_requests.wait_time vs. dm_exec_sessions.last_request_end_time

We have a third-party Microsoft Access application that uses SQL Server 2012 as its data store. It is a well known issue that Access often does not tell SQL Server that it has received the results of ...
4
votes
1answer
49 views

Identity column in columnstore index

I have an extremely large table IMO (~137 million rows) with lots of repeated data, lots of NULL columns, and such. I am considering exploring this using a table with a COLUMNSTORE INDEX and I have ...
3
votes
0answers
32 views

Permissions on a database object when it does not have any permissions associated to it

I want to find out the permissions of a specific object in the database. I have found many scripts on the internet, and developed my own too. Something like this: select dp.NAME AS principal_name ...
3
votes
0answers
14 views

Unable to uninstall Sql Server 2012 Express (With SP1)

My Stack: . Windows 10 Enterprise . SQL Server 2012 Express (with SP1 bundled). ISSUE: . Installed SQL to test for backward compatibility. . When I tried to Un-Install the following prompt is ...
1
vote
3answers
39 views

SQL Server 2012 window function

I've the following table which holds status of jobs in a history table. JobHistory jobOrderId | dateAdded | Status -----------|-------------------------|------- 4909 | 2015-08-26 ...
8
votes
3answers
529 views

NOLOCK hint changes order of records returned

There is a clustered index on a table Client field LastName. When I simply dump all records from the table, they appear in the alphabetical order unless (nolock) hint is used as in the query in ...
1
vote
1answer
31 views

Management Studio licensing issues

We have a licensed SQL Server 2012 Standard Edition instance, that for some reason keeps getting license expiration messages in Management Studio. Sometimes it gets this message: Your Microsoft ...
-2
votes
1answer
28 views

How to give a user “create any database” permission in SQL Server? [on hold]

Is it different from the dbcreator permission? Can anybody explain the process?
1
vote
0answers
15 views

Migrating SQL 2012 Analysis Services to another server

We have a SQL Server 2012 installation that was built on...let's say a compromised Windows installation. It's had so many installs/uninstalls done on it that nothing runs consistently, and we're ...
1
vote
2answers
54 views

Index planning for many columns with different usage

I've a table with 80 columns and that is a base table for most of the application. Daily load inserts almost 8,000 records and update upto 2,000 records. This table is now having more than 5 million ...
2
votes
1answer
56 views

RAID 10 array configuration for SQL Server

I have a question regarding RAID 10 and SQL Server. My plan is to purchase an HP DL380 G9 with the 24 drive config. The question is how to break up the array. The drives will be divided between the 3 ...
2
votes
1answer
34 views

SQL Server 2012 Mirror in a Disconnected state - how do I fix it?

We had a hardware failure last night and we got our servers up and running. After logging into SSMS I find all the mirrored databases in a disconnected state. I've done some searching with ...
1
vote
0answers
14 views

How to trace an SSIS package using Extended Events?

I'm trying to figure out how to trace only SSIS packages accessing a database. I think one way (albeit probably not perfect) to find these queries using SQL are using sys.dm_exec_sessions and checking ...
4
votes
4answers
150 views

Routing data from one SQL Server to another

Is there a way in SQL Server 2012 to have data being written to one table routed to another SQL Server on another host? To clarify, we are using Hibernate Envars to write audit logs. Hibernate Envars ...
1
vote
1answer
45 views

How is an idle SQL Server connection causing blocking?

I have a busy, transactional SQL Server (2012) which is having intermittent problems with blocking (every couple of days or so). I've been using extended events to capture blocked-process reports, but ...
1
vote
2answers
56 views

Defragmenting Indexes Bloats Log Files

I'm having difficulty "defragging" indexes as a minimally logged operation. Before defragmentation, the database recovery model is switched from FULL to BULK LOGGED. Depending on the fragmentation ...
4
votes
3answers
145 views

Setting maxdop 1 vs setting the threshold for parallelism high

I am looking at a possible fringe case for parallelism settings. I've long since followed the credence that maxdop 1 is a viable option for Microsoft Dynamics CRM databases. As the nature of the ...
0
votes
0answers
9 views

Cant restore cube in ssms [closed]

I have a cube that I cant restore in my SQL server management studio. Can you guide me how to resolve it?? what are the steps to be done? Thanks Ranjan DS
2
votes
1answer
92 views

how to get the information about sleeping processes that are causing blocking?

I have a procedure that allows me to see what is currently running in my sql server. This procedure does not use sys.sysprocess because it has been deprecated. However, I am struggling to find ...
4
votes
1answer
31 views

Update queries slower after enabling SQL Server Full-Text Index

I have an asp.net website with many insert, update, and delete queries running against my database. A few days ago I create a Full-Text Index on two columns of one of tables. After that I realized ...
0
votes
0answers
22 views

How can install Microsoft SQL Server 2012 Developer on a Windows 10 machine? [closed]

Title says it all, I need to install an instance of Microsoft SQL Server 2012 Developer licensed software on a work laptop running Windows 10. Thanks!
1
vote
3answers
68 views

SQL Server 2012 - Can't use AlwaysOn HA. What other options do I have?

I have 2 SQL Server 2012 machines. One is production and the other will be for backup. I was looking at using the AoHA but it requires SQL Server 2012 Enterprise for server OS an AD domain I ...
4
votes
1answer
129 views

Count the nodes in a binary tree structure

I need to count the left and right nodes in a binary tree structure (output grouped by joiningDate), given a particular starting node parent id (pid). The tree is stored in the table shown below: ...
2
votes
1answer
52 views

Converting old SQL Server outer join syntax

I'm a Power Builder (PB) developer. I've migrated PB from 10 .5 to 12.5, and now I need to migrate the stored procedures from SQL Server 2005 to 2012 as well. I get a invalid expression error when I ...
0
votes
0answers
22 views

Overwrite TEST db results in PROD db changing to “restoring” state - SQL Server 2012

Using Studio, I've backed up a database from a SQL Server 2008R2 machine that we intend to move to a SQL Server 2012 cluster. The data is from a database that I will call PROD. Using the backup from ...
5
votes
2answers
66 views

Using Left or substring with wildcard in SQL

I am looking to retrieve information from a field, but am having troubles getting exactly what I want. The information I want has no set order and I am also looking for two different things. Here is ...
0
votes
1answer
53 views

SQL Server 2012 Exclude a value

I'm teaching myself SQL, and I ran into a scenario that I cannot seem to solve. Please any help. I have a table called tblRecord with a column called BuyerID, in this case there are two BuyerIDS, and ...
1
vote
0answers
39 views

Change Root Directory on server properties page in SQL Server 2014 SSMS

We did in inplace upgrade from SQL 2012 to SQL 2014 (I know it wasn't the best choice, and it won't happen again, so no need to beat that horse). I have both the MSSQL11.MSSQLSERVER and ...
1
vote
1answer
22 views

Show the error message, after I accidentally clicked “Yes” on “don't show error again”

I was trying to alter an existing Maintenance Plan, but received an error on doing so. Before actually reading it I clicked it away, too late realizing that the text said "Do you wish to hide this ...
1
vote
1answer
32 views

Why is my Target Server Memory slightly higher than my Total Server Memory?

I'm doing a performance test on a high traffic (16000+ users, estimated 1000+ concurrent at peak) Microsoft Dynamics database. The server has gone on line a few months ago, and I'm doing some tests to ...
5
votes
2answers
80 views

Combining data from multiple rows

I am relatively new when working with queries so let me apologize in advance. This is a MS 2012 Server that I will be working with. This data has been brought into a staging table through a nightly ...
1
vote
1answer
44 views

SQL Server After Insert trigger does not perform actions

I have a problem with 2 After Insert triggers and 1 Instead Of Insert trigger. The After Insert triggers should perform some actions but that actions are not fired. When the Instead Of trigger ...
0
votes
0answers
34 views

SMO Not Scripting DB Objects

I have a PowerShell function included in the allusersallhost profile. It is basically scripting linked servers. When I execute the function from a PowerShell session, it scripts the linked server ...
0
votes
1answer
33 views

SQL Azure Migration Wizard - Duplicate Primary Key

Just did a test at migrating a 120gb database onto RDS using SQL Azure Migration Wizard Because we can't afford any downtime for "just" a test we ran the tool on the live database (meaning data was ...
7
votes
3answers
311 views

Find the identity of the client firing a query in SQL Server without using triggers?

I'm currently using Change Data Capture (CDC) to track data changes, and I wish to track the host name and IP address of the client submitting the query that made the changes. If there are 5 different ...
-1
votes
1answer
35 views

SQL query is in “Execution” status and it keeps on running

I try to run a simple query in SQL 2102 select count(*) from cab_details , but it keeps on executing. If i restart the sql service , the result is shown in just one second. (Count is around 250,000 - ...
0
votes
1answer
36 views

Creating index for large table is taking forever

I am trying to create Index for a large table with row count of 496,000,000 and the database is on SQL Server 2012 Enterprise edition. I know how to create index but its taking forever and would like ...
3
votes
1answer
85 views

ASP.NET & SQL Server 2012 timeouts once a month

We have an intranet site which works fine, except one day a month. There are slow queries, unoptimized tables, tables with ~8 million records, etc. but daily usage is fine, although some ...
5
votes
2answers
142 views

SQL Server 2012 - SA account probe

On one of my servers (Win 2012 R2), SQL Server 2012 is constantly under attack with the SA account being hit like 10 times per second with different passwords. I don't have an SA account but still I ...
1
vote
1answer
13 views

Feature of database-level audit in SQL Server 2012 Express edition

Like in SQL Server 2012 Enterprise edition, can we have database-level audit in SQL Server 2012 Express edition? Can we have Audit Folder in Security Tab?
2
votes
1answer
24 views

Non Buffer Latch - Forefront Identity Manager

We are using Forefront Identity Manger and we are doing an initial load to which we are experiencing slow performance. I always start with wait types for such things and can see %30 CXPACKET, %25 ...
0
votes
0answers
33 views

Hard Limit to SQL Server 2012 Memory Usage [duplicate]

It seems that even in SQL Server 2012, the maximum memory usage settings is not a hard limit. I've read some SQLOS Team blogs about this, and those as well as several MSDN articles seem to state that ...
2
votes
1answer
125 views

Order by values with most incidence

I have a table as this example: CREATE TABLE customerEvent( customerID int NOT NULL, eventID int NOT NULL ) customerID may appear in many records. I use the following query to identify ...
3
votes
2answers
95 views

Queries on database migration

I have a SQL Server 2008 database of size around 1 TB. I want to migrate it to SQL Server 2012. I have few queries: To migrate, I will take full backup of 2008 and restore it on 2012. I want to know ...
2
votes
1answer
25 views

Microsoft TDE Permissions For Changing Keys

I am setting up roles as a layer of protection inside of MSSQL. One of the roles will only have the ability to change database encryption keys for TDE on the database server. The server will be using ...
1
vote
0answers
82 views

SQL Server 2012 memory issue [closed]

I am having performance issues on a Windows 2012 Server running SQL 2012. When I run the DBCC MEMORYSTATUS command I receive the following. Process/System Counts Value Available Physical Memory ...
3
votes
1answer
38 views

Scripting Microsoft Data Warehouse Wizard

I am trying to automate the MDW setup process in my environment. Currently I have everything complete except for enabling the data collectors (usually uses a wizard as seen ). Has anyone seen or ...
3
votes
2answers
88 views

8Kb row size limits ignored - but only sometimes!

As a result of poorly tested code (not mine!) I've ended up with a table containing 319 VARBINARY(MAX) fields, plus two DATETIME fields and two UNIQUEIDENTIFIER fields. Obviously this is not ideal, ...