for SQL Server 2012, major build version 11.00.xxxx. Released April 1, 2012 with a projected end-of-life date of 7/12/2022.
0
votes
1answer
14 views
SQL Express 2012 SP1 install still not 11.1
I run the SQL Express 2012 SP1 install and it succeeds. After I have rebooted my computer, I do a
select @@version
But still I only have version 11.0.21600.64. I have tried this on two computers ...
0
votes
0answers
26 views
What are the “additional actions” available for “Recovery Pending” databases?
I've used powershell to run a sql script on several databases on a test server. Disk space was low, so the script failed on 34 out of 75 databases. All fair enough.
In any case, afterwards 10 of my ...
2
votes
2answers
135 views
Transaction log back up
Another accidental DBA question. We have a DB instance that host 10 databases. This DB server doesn't have any maintenance plan set up. I want to set up a decent maintenance plan that will do a full ...
1
vote
0answers
35 views
Scheduling a task to run after a SQL SERVER 2012 executes a different set of scripts?
Im working on a project for a job I am interning for. I've had a few months of database design. I am still learning all the techniques.
I am currently trying to schedule a console app to run every ...
25
votes
8answers
6k views
Is select * still a big no-no on SQL Server 2012?
Back in the days of yesteryear, it was considered a big no-no to do select * from table or select count(*) from table because of the performance hit.
Is this still the case in later versions of SQL ...
1
vote
0answers
52 views
Database Archival Process
I am designing a database archiving process - which is a automated process. Do you have any advice for how to accomplish these goals?
Below are my thoughts :
create another clone database ...
1
vote
1answer
76 views
Installing SQL Server 2012 SP2 on instance with Cumulative Update #10
We have Cumulative Update #10 installed on SQL Server 2012 SP1 that we need because of a specific fix to DQS.
Since the recently released SQL Server 2012 SP2 only contains fixes from CU1 through CU ...
2
votes
0answers
32 views
Listener pointing to incorrect AlwaysOn Availability Group
All, Thanks in advance
I have two instances of SQL Server 2012 SP1 on a three node WSFC with a HAdr group on each instance with a corresponding listener. Instance 1's listener points to Instance 1, ...
1
vote
0answers
27 views
Rolling Back Stored Procedures in Entity Framework
I currently working a on project that operates within a transaction in entity framework. Before now all of the changes were made using a DataContext. I need to add a call to a stored procedure using ...
11
votes
1answer
121 views
“Cannot create a row of size 8074 which is greater than the allowable maximum row size of 8060” while altering the table
I am trying to alter a column in a table. The existing table is like this:
CREATE TABLE [dbo].[table](
[id1] [int] NOT NULL,
[id2] [int] NOT NULL,
[id3] [int] NOT NULL,
[name] ...
2
votes
1answer
55 views
SQL Server Replication questions
This is kind of the part 2 of Replicating a SQL SERVER database & Optimization that I started earlier this week, but I believe it owes to be a different questions now that I have a clear idea of ...
2
votes
1answer
35 views
What does role db_owner allow
I have been trying to troubleshoot a login that is not able to view certain tables in a SQL Server 2012 database. In doing so I find I don't quite understand what membership in the db_owner role ...
0
votes
0answers
24 views
RavenDB as a buisness logic store
There is currently some talk at my place of using a NoSQL DB to store our business logic and keep all of the user/customer data in SQL Server.
So the business logic data will consist of rules and ...
1
vote
1answer
44 views
Replicating a SQL Server database & Optimization
We got a database of approximately 100-120 GB on a server with 128GB ram, while the db is sitting on an 256 GB SSD drive.
The bulk of the database space is spent on the tables below:
Page_contents ...
3
votes
1answer
81 views
Set simple recovery mode and shrink log files for all user created databases
I hope you can point me in the right direction.
I'm not a frequent user of T-SQL, but I did some googleing, and found the script below. I corrected the script a bit.
I want the script to:
To select ...
-3
votes
0answers
28 views
Issues while upgrading sql server 2000 to 2012! [closed]
I upgraded 2000 sp4 to 2008R2 sp2, through full backup and also with LDF/MDF, then
upgraded 2008R2 sp2 to 2012 sp1 (again with full backup and LDF/MDF) but errors raised are:
SQL Server is busy with ...
1
vote
1answer
30 views
Migrate Management Data Warehouse to a New Instance
Is there a defined procedure to follow for moving a SQL Server 2012 management data warehouse to a new server\instance?
We intend to setup an MDW on a test sql server instance first, but will then ...
1
vote
2answers
43 views
ownership of users
Two related questions: Using SQL Server 2012, how does one find out who/what owns a user, and how can you set the ownership for users, if at all?
To add a couple of questions: 'how to' for both of ...
1
vote
1answer
38 views
Map a Login to a User that was Created Without Mapping to a Login
This question has been asked before, but I didn't see any answer (http://stackoverflow.com/questions/6468813/assign-a-login-to-a-user-created-without-login-sql-server)
How does one map a login to a ...
-1
votes
1answer
40 views
how to select column3 from rec1 value which is matched to column1 val in rec2
i am having following scenario :
col1 col2 col3
10 2 13
13 4 14
14 5 15
15 6 16
form the above given table col3 value(13) in row1 is seen in col1 value(13) in ...
0
votes
1answer
40 views
Changing Databases Dynamically using Variables [closed]
I want change into a database programatically using in code:
DECLARE @SQL nvarchar(2000)
DECLARE @DBName sysname
SET @DBName= 'foo'
SET @SQL = 'USE [' + @DBName + ']'
select @SQL
execute @SQL
...
0
votes
1answer
14 views
Remove Cluster Nodes after Cluster Object was deleted
While building new 2012 servers to move to we had some change in requirements. We are using Availability Groups on the new servers.
Here's where we started.
Servers:
Serv1a
Serv1b
Serv2a
Serv2b
...
2
votes
1answer
36 views
Best Practice in storage allocation for compressed and partitioned tables
I have a fairly large database that basically consists of one table, this table is paritioned by month and all partitions are compressed with page compression. After the initial load of the data there ...
1
vote
2answers
170 views
Improve query performance when selecting almost all rows with many “group by” columns
I have a table with 20 columns and about 600,000 records. The maximum row size is only around 100 bytes. The table is repopulated every few days, but the number of records remain about the same.
For ...
0
votes
1answer
15 views
Best scenario for replication type
We are using SQL Server 2012 and we have the Main office server. All modification on the product pricing table is done through the Main office.
We have 10 remote sales branches. Those remotes ...
0
votes
1answer
40 views
Inhibit SQL Server trigger execution
A table with various prices per item have a trigger that will update price 3 when price 0 is changed.
The ERP that uses this database has a utility that when run updates the database with ...
1
vote
0answers
26 views
Manual Fulltext index population time in SQL Server 2012
I would like to know if there is a way to see how much time did it take SQL Server 2012 to index all the data in a table?
In my example I create the table, create the index and set the population to ...
1
vote
1answer
41 views
How can I have a gap in the SQL Server Job Agent history for a job?
I have a job (Update Tickets) scheduled in Job Agent with a single schedule of "Occurs every day every 30 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 11/4/2013." ...
1
vote
0answers
18 views
Issue with MDS data when viewed in Excel addin after connecting to MDS Model
In MDS 2012, while exploring for a entity, I can see the data in Client and Product column are properly assigned as Code and Code {Name} as seen below:
but while connecting to the MDS model via ...
2
votes
1answer
43 views
Should I change my old datetime columns from SQL Server 2005 to just date datatype for SQL Server 2012
My database was developed in 2005 for SQL Server 2005 version.
In that time for columns which store pure date without time we used datetime data type.
Our database has survived up today and now we ...
6
votes
1answer
90 views
How can I tell how many Cores SQL Server is actually using?
I have two servers running SQL Server.
Server 1: SQL Server 2008 R2 Express (4 core)
Server 2: SQL Server 2012 Developer Edition (8 core)
As far as I am aware SQL Server 2008 R2 Express should ...
0
votes
1answer
26 views
How to uninstall SQL server 2012 not showing in control panel's “Programs and features”
i am frustrated to the core while fixing my sql server I've made the situation worse.
here is the problem : initially my master database was corrupted so MSSql service was not starting.i tried to ...
8
votes
1answer
144 views
Sequence is reusing
I have a sequence that generates tracking numbers for objects in my system. It had been working fine for quite some time.
Last week we noticed that it was starting to re-use values.
What seems to ...
1
vote
1answer
138 views
Understanding execution plans using TVPs
I have some slow running queries (8 seconds across 1M records grouped by months) and have been trying to make sense of the execution plans. We use around 10 TVPs to send in a set of filters that the ...
2
votes
0answers
66 views
SQL Server 2012 Local SSD TempDB Slow
I have a production deployment using local SSDs for tempDB. I have 2 SSDs in a RAID1 configuration. I am seeing average reads of 1-2ms but the average writes are showing as 1377ms on all four of my ...
0
votes
1answer
51 views
Script to automate converting a clustered index on primary key (with foreign keys to it) column to non clustered?
What's a good way to easily convert a clustered index on a primary key column to a nonclustered index? I know how to do this manually, but it's time consuming if there are several tables which have ...
1
vote
2answers
79 views
Backup of database X on SQL Server 2008 on server A - restore to SQL Server 2012 database Y on server B
I want to copy a SQL Server 2008 database to SQL Server 2012 with a different database name.
Took a backup of 'production' and copied it to the SQL Server 2012 machine.
Created a new SQL Server 2012 ...
2
votes
1answer
83 views
SQL Server large transaction log for simple recovery model? help! [closed]
Hi all i'm building a data warehouse and noticed that my tran log is massive (in simple recovery). MDF file is 2.6 GB. LDF file is 7.8 GB!!! Why is this??? i don't want a stupid tran log that's why ...
0
votes
0answers
29 views
“Not In” returns no rows all the time [duplicate]
Whats wrong with the following query. The first part of the select always return 0 rows.
DECLARE
@AgentID varchar(20),
@StringValues varchar(max),
@ContactKey int,
@Note ...
0
votes
1answer
48 views
DB2 Linked Server on SQL Server 2012 - Grant Access to Users
I have a linked server on SQL Server 2012 Instance to point to a DB2 database and I have Sys Admin access to that Instance. I am unable to test connection to that DB2OLEDB database as I get below ...
2
votes
1answer
66 views
Fix Linked Server Without Restarting SQL Server Instance
Problem:
Occasionally a nightly job will fail, and when I look into it, it is the result of a query across a linked server failing. But for some reason that query seems to remain 'open' in some way ...
1
vote
1answer
35 views
Log shipping - failed over to secondary, how to fail back
SQL 2012
I've been researching and testing Log Shipping as a DR solution. I got the two servers setup. Log shipping is in place and verified to be working correctly. I failed over by restoring the ...
1
vote
0answers
38 views
How to troubleshoot how resource governed query is being throttled in SQL 2012?
I have a parallelized query on SQL 2012 SP1 (ent) that is running in a user defined resource governor pool much much slower (2 seconds versus 125 to 140 seconds under user defined pool = ~75 times ...
4
votes
0answers
67 views
SQL Server 2012 Unable to Utilize Defined Amount of Locks
So I've been beating my head against the wall for two days about this and I can't find a solution. I'm running a script to stage a large amount of data. This script requires roughly 35 million locks ...
0
votes
0answers
18 views
Linked Server Performance Issue in SQL Server 2012 SP1
We are having issues with a job that seems to run for a long time and not seem to complete. The job runs a sproc that calls other sprocs and uses a linked server. The server that the job runs on is ...
2
votes
1answer
55 views
Do decimal separators behave differently for Money and Decimal data types?
I've recently been troubleshooting some problems with a third party application around regional settings and decimal separators. The detail of these problems isn't too relevant except to say that the ...
2
votes
1answer
62 views
Shrink my database log file, make sense? [duplicate]
I am now taking log backups daily after a long gap(1.5 years). Now when I run,
DBCC SQLPERF('logspace')
Result,
Database Log Size (MB) Log Space Used (%) Status
master 1.742188 ...
0
votes
2answers
37 views
Output a 2 column table to a three column query
Hi I have a Table with 2 columns, one column for the employeename and another column for shift, below is a sample.
EmployeeName Shift
John 1
Peter 1
...
4
votes
1answer
55 views
Which version of Microsoft Tape Format is supported by which MS SQL Server
When you create a backup with Microsoft Sql Server, the resulting file is in Microsoft Tape Format.
Different versions of SQL Server apparently use different version of this format.
Which version of ...
0
votes
0answers
11 views
Application Role and access second database
I have written a script to create an audit trails to my database in a second one db. So far I had no problems during tests on my dev machine from SQL Server Management Studio. Problems started to ...
