This tag is specifically for SQL Server 2012
2
votes
1answer
623 views
SQL Server 2012 is putting [brackets] around Table and Column Names
Is there anyway to turn that off? I'm unable to find anything in options, and they're really a distraction.
2
votes
1answer
126 views
Why do I have to drop a snapshot in SQL Server 2012 to restore a database?
I never had to drop a snapshot with SQL Server 2008, but now when I try to restore in SQL Server 2012, I get the error:
System.Data.SqlClient.SqlError: The operation cannot be performed on a ...
1
vote
1answer
78 views
Do locks on readonly secondary databases propagate to the Read/Write Database
I'm thinking about using SQL Server Availability Groups in SQL Server 2012 to offload reporting on our main database to a second read only server that is kept in sync through the availability group.
...
1
vote
0answers
49 views
Page Header DB Frag ID Property
I am using SQL Server version: Microsoft SQL Server 2012 - 11.0.2100.60 (X64).
I created a single table containing one and only one integer-valued column. I then added one and only one row to the ...
2
votes
1answer
620 views
Cannot connect remotely to sql server 2012 instance using SSMS
I have installed sql server 2012 Express on a local network machine, then added a new login: "sqlUser" mapped to "database1", and configured the instance to accept the remote access with both Windows ...
1
vote
0answers
113 views
SQL Server keeps crashing [closed]
I have had SQL Server 2012 on my server for about 6 months. Over the last few weeks, a problem has developed, whereby the SQL Server stops functioning, and any attempt to connect or query returns the ...
3
votes
2answers
396 views
SQL Server (2012) non-blocking DDL?
I'm not very experienced with SQL Server, so maybe I'm missing something
My situation is as follows:
Session 1 runs a CREATE TABLE (or other CREATE statements) with autocommit off and the CREATE is ...
2
votes
0answers
75 views
How to use a foreach loop with project deployment model
I have a SSIS project that is configured to project deployment model, within this I have two connections one for a flat file and one for a sql db. Both connections are in project mode. Now I want to ...
3
votes
1answer
110 views
sql_slovak_cp1250_ci_as vs Slovak_CI_AS
Can someone explain to me what is the difference between collation sql_slovak_cp1250_ci_as vs Slovak_CI_AS?
I have a db set to sql_slovak_cp1250_ci_as and shared hosting supports only Slovak_CI_AS. ...
4
votes
1answer
2k views
TFS2010 for SSMS 2012
SSMS 2012 does not work with VSS 6. We installed modern source control, TFS 2010 server.
Then I Installed Team Foundation Server MSSCCI Provider 2010.
However the only choice for Source control ...
2
votes
1answer
68 views
Always On and Partition Swapping
Is it possible to use SQL 2012 Always On over two machines and perform partition swapping on the primary machine ?
1
vote
0answers
89 views
Best Practice to update columnstore indexed tables
I have a table with aprox. 22 Bn rows, for each month I have made one partition that and each partition has two data files. I created the columnstore index on this table and the performance ...
6
votes
1answer
99 views
Ok to drop indexes on FK's if they have no stats in the DMVS
I have used the well known query below from Kevin Kline to check for unused indexes. Several indexes created on Foreign keys returns no read stats, only writes.
Are you 100% safe to drop these ...
2
votes
1answer
672 views
How do I fix SQL Server assembly optimization errors and memory exhaustion?
The .NET Runtime Optimization Service (mscorsvw) keeps consuming all my workstation's memory since I installed SQL Server 2012 Service Pack 1.
It consumes about 1.6 GB of memory before exhausting all ...
1
vote
3answers
470 views
Moving rows from one table to another
I am moving records from one database to another, as a part of archiving process. I want to copy the rows to destination table and then delete the same rows from the source table.
My question is, ...
3
votes
1answer
106 views
Easiest Way to Move 100 Databases
I need to move about 150 databases from one server to another server.
SQL Server 2008 Web Edition
SQL Server 2012 Preview (in a different datacenter - East Coast Azure)
I was planning on moving ...
0
votes
1answer
121 views
Color syntax printing in SSMS 2012
It seems the SSMS of Sql server 2012 cannot print the SQL statements with syntax color anymore. Is it a bug? Does it have any workaround?
6
votes
1answer
722 views
Upgrade SQL Server 2005 to SQL Server 2012
I have a test environment set up with the following:
Virtual Machine (Hyper-V)
Windows Server 2008 R2 SP1(x64-bit)
Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name)
1 ...
0
votes
1answer
41 views
Is it possible to use Native Clients from previous releases to connect SQL Server 2012?
Is it possible to use SQL Server Native Clients from previous SQL Server releases (e.g. SQL Server 2008 R2 Natice Client) to connect SQL Server 2012 database?
2
votes
1answer
102 views
SQL Server Plan Guide vs Plan Freezing
I am bit confused with terminology as official Microsoft SQL Server documentation including BOL refers to plan guide the one you create using sp_create_plan_guide proc. Does plan freezing is same ...
6
votes
2answers
4k views
Sql Server 2012 data warehousing and different versions
With Sql Server 2012 there are 3 flagship editions: Enterprise Edition, Business Intelligence, Standard.
The full comparison between the three: ...
6
votes
1answer
189 views
Recovery time effects of AlwaysOn
We did different kinds of basic Tests and AlwaysOn passed in many tests. We finally did a heavy write test for AlwaysOn and it gave surprising results.
The actual Test details are here, the goal is ...
20
votes
2answers
1k views
Why are Denali sequences supposed to perform better than identity columns?
In his answer to sql2005 whats better: identity columns or generated uinique id values?
mrdenny mentions, says
When SQL Denali comes out it will
support sequences which will be more
efficient ...
13
votes
2answers
570 views
Optimising plans with XML readers
Executing the query from here to pull the deadlock events out of the default extended events session
SELECT CAST (
REPLACE (
REPLACE (
XEventData.XEvent.value ...
2
votes
1answer
688 views
“No such interface supported” after upgrading SourceSafe project to 2012 SSMS format.
We had SQL Server 2008 r2 project.
Then we converted it to SSMS 2012 format.
Now I can't open the converted project.
I am getting an error
C:\Views.ssmssqlproj : error : Unexpected error ...
6
votes
1answer
587 views
Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)?
I have been testing the the Always On high availability feature in SQL Server 2012 and am finding that there is approximately 15 seconds of down time when the primary server fails over to the ...
1
vote
1answer
146 views
SQL Server table appears locked for no reason
My database was running just fine this morning, up until it wasn't.
This query:
SELECT TOP (1) *
FROM tblTask;
comes back in no time at all, while this query:
SELECT *
FROM tblTask this_ with ...
3
votes
2answers
288 views
Procedure cache (plan cache) size
I'm developing an application with many, dinamycally-assembled, complicated SQL queries. I'd like to keep the query plans in the procedure cache for as long as it is possible. To prevent discarding ...
2
votes
1answer
338 views
SMO v11 (SQL Server 2012) not scripting key definitions, indexes, and constraints
I have a .ps1 PowerShell script that runs on a Central Management Server. The script goes out to all databases in our environment, and scripts out all of of objects. For tables scripts, the output ...
6
votes
1answer
209 views
What is the migration/deployment path from a LocalDB solution to Enterprise instance?
Given the extant definition for SQL Server 2012's LocalDB as
SqlLocalDB is a local, low-overhead database engine of SQL Server 2012
(and future versions) that allows developers to focus on ...
4
votes
1answer
370 views
Kerberos authentication not working with Linked Servers in SQL Server 2012
I am setting up a DEV/TEST environment using 2 SQL Servers running SQL Server 2012 on Windows Server 2012. We are moving from SQL Server 2005 on Windows Server 2008, where we already have this ...
4
votes
1answer
75 views
Expanding a partitioned table
I have a table that holds four years of data, where for each month I have a partition that is based on a filegroup with two files. Unexpectedly, I received eight more years of data and prepared the ...
10
votes
1answer
223 views
MDX Query for RANK regardless of hierarchy
I'm hoping to add a calculation to my SSAS Cube (SSAS 2012) that will show the relative rank of whatever the current member is against all other members in that grouper, without specifying the ...
8
votes
1answer
315 views
Forcing an index spool
I know its something that should be avoided for performance reasons, but am trying to show a condition where it appears as a demo on how to make sure it does not appear.
However, I end up with a ...
2
votes
0answers
107 views
Schema for multiple identical queue tables
I am migrating a message processing application that was built on MSMQ to SQL Server 2012 (preferably Standard Edition). Messages are received and distributed via TCP/IP endpoints and the typical ...
1
vote
0answers
123 views
Transactional Replication Snapshots causing serious locking after 2012 upgrade
I am experiencing serious locking when adding new articles to an existing transactional replication publication, which is hanging the website. This is the first time I have attempted this since I ...
7
votes
3answers
281 views
Why are there execution plan differences between OFFSET … FETCH and the old-style ROW_NUMBER scheme?
The new OFFSET ... FETCH model introduces with SQL Server 2012 offers simple and faster paging. Why are there any differences at all considering that the two forms are semantically identical and very ...
3
votes
1answer
135 views
How to link users and logins in an Availability Group?
I've got an Availability Group going and need to map some logins to database users on an active secondary replica. (Node2) Unfortunately, when I try to exec sp_change_users_login or alter user with ...
3
votes
1answer
110 views
Lost databases in SQL Server 2012
Had three databases connected to SQL server 2012, unfortunately, now I can't see any of them under the Databases part of the tree in SQL Server Management Studio. The files (.mdf) are still on the ...
25
votes
2answers
2k views
Are SQL Server in-place upgrades as ill advised as they used to be?
I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade.
I'm currently upgrading my 2008 R2 DEV and TEST ...
2
votes
1answer
183 views
Merge replication SQL Server 2008 publisher with SQL Server 2012 subscriber
is this somehow possible to have SQL Server 2008 publisher with a SQL Server 2012 subscriber for merge replication?
5
votes
2answers
203 views
case versus isnull versus coalesce
I am just reading through the documentation for the SQL Server 2012 exams and I saw the following point:
case versus isnull versus coalesce
Now, I know HOW to use each one but I don't know WHEN ...
1
vote
1answer
149 views
Can't grant role permissions under sysadmin login
I'm trying to execute this script from Management Studio:
GRANT ALTER ON ROLE::[AdaptTemplate] TO [AdaptAdmin] AS [AdminSapr]
Execution fails with this message:
Msg 15151, Level 16, State 1, ...
1
vote
1answer
322 views
SQL Server Full-Text Indexer with stoplists/stopwords
As I'm working on a graduate project (Textmining with SQL Server 2012 Semantic Search) I run into a situation where I need to post a question on this website, hoping someone can help me.
This ...
2
votes
4answers
545 views
limiting sql server backups inside .bak file
I have a job scheduled to run a few times everyday. The job backups my databases, like:
BACKUP DATABASE [databasename]
TO DISK = N'd:\sqlserver\backup\databasename.bak'
I can track the backups in ...
5
votes
2answers
324 views
How to handle sql server database logins when using AlwaysOn. (they aren't syncing)
We have 2 servers in an AlwaysOn group.
While the user accounts within each syncronized database exist on both servers, the database instance level logins only exist on one of the servers. Ie ...
1
vote
0answers
110 views
SQL Server: Collation of the resource database
I'm trying to use stopwords so that some words are skipped by the Full-Text Indexer. I can add those stopwords in the table sys.fulltext_stopwords.
When trying to get a list of stopwords and ...
1
vote
1answer
389 views
Upgrade SQL Server database Using Compatibility Level
I've made a backup of a SQL Server database running on SQL Server 2008.
I've restored that backup into a SQL Server 2012 instance.
I've set the compatibility level on the restored instance to SQL ...
2
votes
1answer
177 views
SQL Server 2012 data striping
Is data striping possible like mentioned here data striping in older SQL Server 2005
in the newest version of SQL Server like SQL Server 2012?
I know this is possible in 2008 and 2008R2.
2
votes
1answer
2k views
Access denied when trying to run an agent job
Can someone please point me in the right direction. I keep getting the below error message when I try to run a job that executes a package I created and saved on the SQL Server.
12/03/2012 ...
