This tag is specifically for SQL Server 2012
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 ...
24
votes
4answers
7k 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 ...
1
vote
3answers
1k views
Cannot start SqlLocalDB instance with my Windows account
I'm the administrator and simply run the command:
sqllocaldb start v11.0
Result:
Start of LocalDB instance "v11.0" failed because of the following error:
Error occurred during LocalDB instance ...
14
votes
6answers
1k 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 ...
13
votes
2answers
650 views
Why does DELETE leave a lingering effect on performance?
At the end is a test script for comparing the performance between a @table variable and a #temp table. I think I've set it up correctly - the performance timings are taken outside of the ...
19
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
552 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 ...
5
votes
1answer
551 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
3answers
2k views
Not able to install any piece of SQL server 2012 dev edition on my windows 7
I have tried everything i can think f to install SQL 2012 but no luck I am getting these errors but after looking through the logs I can't find the actual cause to get a solution.
every feature gives ...
4
votes
1answer
62 views
Are the cost percentages in this SQL Server plan over 100% for a valid reason?
I'm looking through the plan cache, looking for low-hanging optimization fruit and came across this snippet:
Why are many of the costs listed above 100% ? Shouldn't that be impossible?
4
votes
1answer
220 views
Mirroring and Availability Groups in SQL2012
I've been looking at the new features of SQL 2012, and how it can help my current situation.
Currently we're on SQL 2008R2, and replicate two OLTP servers' databases to a single reporting server via ...
0
votes
2answers
259 views
SQL Server 2012 Data Warehousing Overall Flow [closed]
I am studying Data Warehousing in SQL Server 2012
I am attempting to learn the various tools included by practicing on the different tools separately.
I have practiced with:
AdventureWorks ...
9
votes
1answer
689 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 ...
6
votes
3answers
386 views
What is a good, repeatable way to calculate MAXDOP on SQL Server?
When setting up a new SQL Server 2012, I use the following code to determine a good starting point for the MAXDOP setting:
/*
This will recommend a MAXDOP setting appropriate for your machine's ...
7
votes
3answers
277 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 ...
6
votes
2answers
393 views
SQL Server 2012 Availability Group is it “AlwaysON”?
In a traditional SQL Server clustering when failover occurs, all client that are connected to SQL Server failover instance looses the connection and each client must reestablish a new connection to ...
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: ...
4
votes
5answers
454 views
using IDENTITY column with increment -1
I need to run a sql server logging db with 2 main tables in 2 seperate datacentres writing to both at the same time.
I had the idea of restoring the db to the new datacentre and then reseeding the ...
4
votes
2answers
3k 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 ...
3
votes
2answers
390 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
1answer
139 views
How can I configure SQL Server 2012 to use multiple NICs?
How can I configure SQL Server 2012 to use multiple NICs?
I've a server with 4 NICs. I want to use 2 NICs to query my databases, and 2 NICs to retrieve results from them.
I want them to work in load ...
2
votes
4answers
528 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 ...
0
votes
0answers
92 views
How to create table set from several XSD in SQL Server 2012 or with VS 2012
Is there any solution in T-SQL or in C# how to create XML schema collection in T-SQL or C#?
Problem is I cannot use:
USE Database_test
GO
CREATE XML SCHEMA COLLECTION Collection_from_XSD AS
N'
...
0
votes
1answer
77 views
How can I install a provider for linked server?
I have a provider for a linked server called PervasiveOLEDB.11.0 installed on a sql server 2005 machine. It always me to have a connection to a pervasive sql database.
I would like to use this same ...
