SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

learn more… | top users | synonyms (3)

0
votes
0answers
37 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
148 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
221 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
63 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
107 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 ...
4
votes
1answer
50 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
383 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, ...
1
vote
1answer
630 views

Import data from one Database to another script

As part of a data migration I would like to script a data transfer from the existing to a new database. I used to do this with DTS on older versions of MS SQL. I am currently using SQL 2012. Note the ...
1
vote
1answer
44 views

What are the default fixed server role members for SQL Server 2012

What are the default fixed server role members for newly created SQL Server 2012 instance using all default options. As given by EXEC sp_helpsrvrolemember
0
votes
1answer
1k views

SQL Server Management Studio backup not shown when restoring

I am trying to restore a database from a backup taken on another server. I am doing this by using SQL Server 2012 Management Studio. After I have taken the backup on server 1, I go on to select the ...
1
vote
1answer
194 views

Monitoring SQL Server 2012 slow queries/queries which are causing blocking

I am using SQL Server 2012 and I want to get hold of the queries which are taking longer to execute along with the queries which are causing blocking on the server. When I look at the server for the ...
1
vote
0answers
99 views

Unable to insert explicit value in table due to IDENTITY_INSERT is ON Error

I am trying to insert explicit values in one of my Real time Audit Production database. There are more than 80 columns, I have just taken here 5 columns. I am writing syntax is as below: use ...
0
votes
2answers
100 views

Random selection of a row within a function

I am trying to write a function so it can be used as a default value for a column in a table. It exists as a procedure at the moment (which cannot be used as a column default) and uses ORDER BY newid()...
1
vote
1answer
83 views

SQL get row based on condition [closed]

Hi all please see attached data below. I'm trying to get a row based on various conditions. scenario 1 - get highest row if no hours exist against it that has (setup + processtime > 0). scenario 2 ...
1
vote
0answers
35 views

CDC and datamodel updates, best methodology?

We're about to start using CDC to track changes to a large number of tables in our db's. But since our datamodel is rather frequently updated, I'm wondering what is the best method for easily keeping ...
4
votes
1answer
110 views

SQL 2012 insert data into a table from another table and custom columns

I'm trying to insert data from one table into another table and I also have 4 columns that are not in the source table but need to be populated in the target table. Here is the Insert statement SET ...
3
votes
1answer
147 views

SQL server restore readonly file group without backup from .ndf file

We have SQl Server database with ReadOnly file group. Common file groups except readonly are backuped regulary. We restore the database from backup but readonly file group has not restored, its *.ndf ...
3
votes
0answers
116 views

DBCC TempDB Space Usage

We are using DBCC CHECKDB on a VLDB 1TB in size. Previously when on our 2008 platform the check ran successfully on a drive that was 150GB in size for TempDB, but since moving to SQL 2012 and ...
0
votes
1answer
95 views

SQL Server 2012 AlwaysOn Availability Group

We have an application that needs access to the database all the time to work properly and we are planning on deploying SQL Server 2012 AlwaysOn Availability Groups on Windows Server 2012. We have ...
1
vote
1answer
50 views

Nightly Excel Spreadheet import into mssql database

I am currently working with a nightly import that I need to create, but am not sure what the best route would be to update/insert into the current table. This is all done in MS SQL Server 2012 and ...
2
votes
4answers
416 views

WHERE NAME LIKE ( A SET OF NAMES )

I would like to drop all the jobs related to a set of specific databases. So I have added all the names into a table variable and I was trying to generate the scripts to drop the jobs. how can I ...
2
votes
2answers
608 views

Why would a job call a batch file with dtexec.exe instead of just calling the SSIS package directly?

I've inherited a SQL 2012 server with a number of jobs that call SSIS packages. Instead of the more obvious solution (calling them directly from a "SSIS Package" job step), these jobs use a CmdExec ...
1
vote
1answer
37 views

Is it possible to uninstall SSRS?

I installed SQL Server with Reporting Services package by mistake and I will never have a requirement to use the Reporting Services part. Is it possible to uninstall Reporting Services (and anything ...
3
votes
1answer
170 views

Why is SAN Replication is Causing Random Database Corruption?

Having a strange issue with a disaster recovery technology we're trying to implement. The environment in both datacenters is the same having VMWare and Dell Equallogic SANs, which are the same ...
0
votes
1answer
98 views

Best approch to replicate data from one db to other db on same server

I am facing issue of time out and slow data response so I did search on Google and found that I could create a server which replicates main database data to secondary database and both on same server ...
2
votes
1answer
220 views

Last user update for a table

Since my server was started one month back, I am getting 2015-07-31 as the value of last_user_update for a table. Does that mean my table’s data hasn't been modified (inserted, updated, deleted) ...
2
votes
1answer
479 views

computed column as foreign key allow null

I have two tables. TABLE A: One of them stores some integer identificators, which are unique, but actually are structured entities. I will call them full_id. Actually its a two parted indetificator,...
2
votes
0answers
86 views

Techniques for moving database from Enterprise to Standard Editiion

I have a SQL Server 2012 Enterprise edition and a Model database. On a virtual machine I have installed SQL Server 2012 Standard Edition and want to create a copy of the Model database on it. I have ...
1
vote
1answer
346 views

How to migrate SSAS and SSRS from SQL Server 2008R2 to SQL Server 2012?

We are upgrading our SQL Server 2008R2 to 2012 and separate the SQL Server engine from SSAS and SSRS. We want put on Server 1 the engine and on Server 2 SSAS and SSRS. I did the side-by-side ...
3
votes
2answers
278 views

SQL Server 2012 SP2 update failure

I have been having failures to install SQL Server 2012 SP2 on a 2-node active\passive cluster. I have uploaded detail and summary logs for the latest run on the passive node here: https://www.dropbox....
2
votes
1answer
107 views

How to generate a unique barcode without using identity or sequence in SQL Server 2012

We're currently building an application where customers need to have 1 unique barcode. Each time a new customer has been added to the system, a new unique barcode needs to be generated for that ...
5
votes
1answer
73 views

Does Resource Governor help protect page life expectancy?

I have several large tables that I need to copy into partitioned copies on a transactional database. I am worried about the hit that this will cause to performance of my production applications. In ...
2
votes
1answer
96 views

Understanding `dbcc showcontig` Record Size

I am comparing two tables. They are: CREATE TABLE Table1( Column1 [bigint] NOT NULL, Column2 [VARBINARY](max) NULL, Column3 [int] NULL, Column4 [DATETIME] NULL, Column5 [INT] ...
1
vote
0answers
5k views

The target principal name is incorrect. Cannot generate SSPI context - SQL Server 2012 error

I don't understand why this error is popped up suddenly. It was working till yesterday. It is a stand alone env. Problem is when me or any user wants to connect from their machine locally it is ...
1
vote
2answers
1k views

How can I call a remote User Defined Function?

I have SQL server which contains a link to another server(For e.g: test) I have a function in linked server(name:getvalue(@parameter)).so this function output i want to retrieve in SQL server 2012.I ...
3
votes
1answer
73 views

Stats Maintenance after Restoring to Newer SQL Server

What's the ideal (or necessary) sequence of call when restoring a SQL Server 2012 backup onto a SQL Server 2014 instance and updating the compatibility level? -- Update Statistics for all tables EXEC ...
3
votes
0answers
49 views

Compress backup taken from two different environments take different time to restore

I have two backup files one from Normal SQL Server and one from SQL Server from Azure VM. The restore of these backup files is totally different from each other. Though the database backups are ...
1
vote
1answer
104 views

Replication with fail over cluster in SQL Server 2014

Presently I am Using Replication Feature in SQL Server 2012 .I want to migrate to SQL server 2014 .I want to use fail over cluster feature .Does it effect the replication feature which we are using ...
1
vote
2answers
633 views

How to tune a stored procedure that is fast on test data but slow in production

If you have a SQL Server 2012 database with test data in development and preproduction phase and the real from the company's server take place only in the production phase. In other words, the real ...
6
votes
1answer
3k views

When to use sort_in_tempdb when rebuilding indexes?

We are debating whether to use the SORT_IN_TEMPDB option for our DW tables. My understanding is that there are more writes when using this option, although they are more sequential. We have a SAN (...
1
vote
2answers
73 views

Create rows when selected rows exist

I haven't spent much time with SQL Server, and I can't seem to figure something out. I have 3 tables; user, usergroup, group. usergroup is a table that contains both a group id and a user id, where ...
2
votes
3answers
262 views

Show all stored procedure definitions (content) for editing

Apologies if this has been asked before, the suggested 'related' questions weren't relevant and my own search turned up very little. I need to list the definitions (code) of all my stored procedures, ...
4
votes
1answer
6k views

I/O is frozen on Database & also I/O was resumed on Database on daily basis in log with complete Backup

I would like to say that as on daily basis i got the message in my log file. First The I/O is frozen on Database (DatabaseName) message appears in log. The message is like I/O is frozen on ...
0
votes
1answer
84 views

SQL Server DeleteFolder Job ran successfully but it doesn't deleted the folder

I have a job to delete past 15 days folder in SQL Server. The job run successfully and delete the folder in local SQL Server. But it runs successfully and does not delete the folder in another SQL ...
4
votes
1answer
2k views

Connection Reset by Peer: Socket Write Error

We have a vendor working on Java (JDBC) application saying they are getting the error Connection Reset by Peer: Socket Write Error They are insisting that the SQL Server (SQL Server 2012) is ...
2
votes
2answers
183 views

Disk size and log file growth during upgrades

I have four SQL Server databases. Per the maximum load requirements, each database file can be between 1 and 2 TB in size. The HDD is a multi-disk DAS with about 9TB of space. During a database ...
1
vote
0answers
58 views

Oracle migration to SQL Server

I am working in a Oracle 11g database migration to SQL Server 2012, I did the migration using SSMA v5.3 and all works fine. However, I did re-write code in some objects like triggers and stored ...
11
votes
1answer
1k views

SET STATISTICS IO- worktable/workfile

I am executiong query, that produces plan: Statistics IO: Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-...
1
vote
1answer
93 views

Which technology to synchronise SQL Server and MySQL data?

Which technology should be used if I want to move my data from SQL Server to MySQL server when data is entered to SQL Server row by row and getting feedback from MySQL server? Should it be 1. Linked-...
3
votes
1answer
36 views

SQL Server 2012 Explicit transactions taking time with Always on Setup

We have a weird issue while we setup the AlwaysOn on Azure VM. We have explicit transactions in our stored procedures, and which are causing some delays and blocking when till the time we get the ...