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

learn more… | top users | synonyms (3)

6
votes
2answers
1k views

Can't get SQL Server 2012 RTM LocalDB working on Server 2008/x86/ SQL Server 2008 machine

I have installed SQL Server 2012 and LocalDB on my development machine, and am able to connect to LocalDB using both the SQL Server Management tool 2012 and from within my winform application using a ...
1
vote
1answer
1k views

What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?

From microsoft connect you learn, that it is closed by design. But they do not tell how to replace EXEC sp_dboption master to query the current db options.
44
votes
4answers
14k views

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

My company is facing the decision whether to purchase SQL Server 2012 Denali or SQL Server 2008 R2 for a new database server. I am looking for objective reasons to choose one over the other. Our ...
-7
votes
1answer
581 views

Where will i download denali SSMS from? [closed]

I have read many blogs around praising new features in denali SSMS. I really wanna try but unable to find how to download only SSMS (denali).
7
votes
2answers
4k views

sp_executesql with user defined table type not behaving correctly

Problem Is there a known issue with user defined table types as parameters to sp_executesql? Answer - no, I'm an idiot. Set up script This script creates one each of table, procedure and user ...
5
votes
3answers
6k views

Are there any advantages in SQL Server Always On vs. SQL Server 2008 R2 Mirroring with only two nodes?

We are currently hosting a SaaS website on two Windows 2008 R2 / SQL Server 2008 R2 Servers. Would upgrading to SQL Server 2012 / Always On give us any advantages with respects to high availability? ...
8
votes
2answers
8k 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: ...
13
votes
1answer
1k views

What's the anatomy of a columnstore index?

One of the new features in SQL Server 2012 codenamed Denali is the Columnstore index. I know a good bit about regular old row-store indexes, like the b-tree structure, differences in storage between ...
1
vote
1answer
2k views

SQL Server 2012 Create index with Sort In TempDb On - Gains False?

If I create an index e.g Create nonclustered index(Path, Value, Id) with(sort_in_tempdb=on); It doesn't fail but when looking at the index in SMMS, it says False. Any ideas why? EDIT: Can not find ...
5
votes
1answer
2k views

SQL Server 2012 replication permissions with virtual user and agent credentials

For development/testing I set up replication in SQL Server 2012 RC0 (11.0.1750) using the default permissions on the agent, and I'm getting this error: Message: Access to the path 'C:\Program ...
4
votes
2answers
3k views

SQL Server 2012 RC installation failing

I'm trying to test out the new SS 2012 RC, but I'm having problems with the installation. My installation stops a ways in saying that the resource needed cannot be found. I'm using the ISO from MSDN ...
0
votes
1answer
247 views

Quiet installation of MS SQL 2012 RC0 from command line using config file [closed]

My problem is that I recently deployed Microsoft SQL server 2008 R2 Express to create a database for a locally hosted application to access. To save myself time I used the /CONFIGURATIONFILE option ...
0
votes
1answer
2k views

SQL Server 2012 Installation Error

I been trying to install SQL Server 2012 on Windows 7 SP1 32 bit. Logged in as Administrator and launched setup. Everything installs fine but SQL Server DB Services fails with following error ...
1
vote
2answers
871 views

SQL Server AlwaysOn Failover Transparency

This is using RC0. I have set up a SQL Server 2012 AlwaysOn (or more accurately, highly-likely-but-not-always-on) Availability Group. I take the Primary offline. The Secondary takes up to 25 ...
6
votes
1answer
813 views

Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?

I posed a question about Denali sequences here and another question about emulation of identity columns in Oracle Global Tables here. I always thought that I could trust that identity values ...
4
votes
2answers
8k views

How to set full text catalog location SQL Server 2008/2012

I want to upgrade my SQL Server 2005 database to SQL Server 2012. In SQL Server 2005 you can set the location of the full text catalog when you create it. But in SQL Server 2012 (and in SQL Server ...
24
votes
2answers
2k 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 ...
8
votes
2answers
379 views

Shouldn't SQL Server Support RANGE?

As someone who develops websites and does a bit of SQL Server, it seems a no brainer to me that SQL Server should support a simple clause that indicates the results should only include a specific ...
15
votes
6answers
2k views

What is SQL Server “Denali”? What's new?

I found a new title called SQL Server "Denali" in the drop down list on MSDN, but I didn't find much information about it: What's New (this documentation is for preview only as I see) Top 9 New ...