Questions tagged [sql-server-2012]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
289 views

SQL Trigger to verify account, if not verified dont process stored procedure/transactions

Is there a way to create a trigger or function to check a user against the database and if not verfied, the following stored procedure is not ran. I would like this option for verification check ...
4
votes
3answers
9k views

SELECT every nth value by Date from large table

Rewrote this question 2012-06-20 for clarity, check edits for older version Background and Question I collect data for a couple of sensors on some devices. This data I want to display for the user as ...
0
votes
1answer
1k views

Can You Replicate Sequences

In SQL 2012 can you replicate sequence objects, and if so do changes to the sequence (including consumption of values) get replicated? If not is there a good reason why this was not included?
5
votes
1answer
324 views

Does the PCI require to protect the Credit Card Info in the transaction log?

The PCI Data Security Standard https://www.pcisecuritystandards.org/documents/pci_dss_v2.pdf forbid storing Credit Card info in the transaction log 3.2.1 For a sample of system components, examine ...
3
votes
1answer
2k views

Is there a way to use a SQL Server 2000 database in SSIS 2012?

I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and ...
9
votes
1answer
19k views

SQL Server 2012 performance v SQL Server 2008 R2

Does anyone have any links to performance benchmarking of the database engine, or any anecdotal reports of the performance improvements in SQL Server 2012. We are only using the DB engine,not ...
3
votes
2answers
10k views

Recover registered servers in SQL Server Management Studio 2012

My computer died so it's be reinstalled. Previously I had SQL Server 2008 R2 installed. On the new system I have SQL Server 2012. I have the old RegSrvr.xml file (that contains the list of ...
5
votes
2answers
2k 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
589 views

SQL 2012: Import DB changes original data scheme

I'm migrating data from SQL 2008 R2 Servers to SQL 2012. Therefore I'm using SSMS Import Data Task on the SQL 2012 machines. As a test I copied the data files of one of the DBs, did an "Attach ...
4
votes
1answer
3k views

How does performance of SQL Server CE and SQL Server Express compare?

We have an application that runs on netbooks. It currently uses a SQL Server CE 3.5 database, and we are thinking of upgrading to SQL Server Express. Just wonder if there are any benchmarks to ...
4
votes
2answers
131 views

Mirroring and Buffer Page Write/s

Is the "Buffer Manager: Page writes/sec" (* 8 KBytes) a good indicator of how much bandwidth will be used to replicate all databases via Availability Groups? If not, why are these not equivalent? Is ...
36
votes
21answers
54k views

SQL Server Management Studio slow opening new windows

After upgrading both SQL Server and Management Studio from 2008 to 2012, Management Studio 2012 is very slow when new query windows and dialog boxes are opened. Even right clicking on tables is slow. ...
16
votes
3answers
2k views

Where to learn SQL Server Service Broker?

Are there any good resources to learn Service Broker? I'm looking for a newbie-friendly guide.
4
votes
1answer
1k views

How can I automatically trigger a script when my DB fails over?

I have some Windows services that I'd like to restart after a database failover but I can't find any details on triggering external actions after a failover. I'm working with SQL Server 2012 database ...
15
votes
3answers
10k views

Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS?

Is it possible to connect to the DAC using SSMS? If I understand correctly, it should be possible by using "admin:" prefix before the server name, but I receive the following message: Dedicated ...
5
votes
1answer
8k 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 plug-...
6
votes
1answer
408 views

Few Questions about SSAS Cubes

I am newbie to SSAS 2012 and here are my questions: Can we have measures of complex types (table)? Is it possible to order the results by a specific measure or attribute? My cube can be modeled as ...
8
votes
2answers
2k views

Can Availability Groups replace transactional replication?

I've been looking at the new features of SQL Server 2012, and how it can help my current situation. Currently we're on SQL Server 2008 R2, and replicate two OLTP servers' databases to a single ...
2
votes
1answer
707 views

Service Account Groups in SQL Server 2012

I was tracking down some permissions issues on SSRS 2012 and I started looking for the local groups that I am used to seeing for SQL Server. I noticed something I had not seen before, the groups have ...
7
votes
1answer
3k views

Service Broker & AlwaysOn Availability Groups: Odd Transmission Queue Behavior

I have also posted this question on my blog: http://www.sqldiablo.com/2012/04/15/service-broker-alwayson-availability-groups-odd-transmission-queue-behavior/. I’ve been working on a project over the ...
1
vote
1answer
175 views

Which should be used after messing up clustered index? Update statistics, Reindex or Reorganize

If I have a clustered single column index, e.g FooId in SQL Server 2008, 2012 and I know I have messed up the order of the rows to not have sequential order of the FooId column anymore, which command/...
5
votes
2answers
3k views

How to assign CTRL+F1 to sp_whoisactive in ssms 2012?

When I go to Tools > Options > Environment > Keyboard and Type in Query.Sp_whoisactive Press shortcut keys: Ctrl+F1 Click Assign. When I press Ctrl+F1, It still calls Help.
2
votes
1answer
2k 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 encountered....
4
votes
1answer
4k views

Management Studio 2012 Backward Compatibility

Two quick questions for anybody that's tried this: Will Management Studio 2012 install and run side-by-side with, say, Management Studio 2008? I vaguely recall not being able to do this with 2008 and ...
2
votes
1answer
996 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.
14
votes
4answers
4k views

Does the order of columns in a columnstore index matter?

I have a table with ~200 million rows and ~15 columns in it. I am planning to create a COLUMNSTORE index on my table. Will there be any change in performance based on the order of columns that I use ...
8
votes
3answers
16k views

Upgrade process from SQL Server 2000 to SQL Server 2012

I have a SQL Server 2000 database that I would like to upgrade to SQL Server 2012 (running on a different server). I don't think there is a direct upgrade path, but if there is, what is it? My ...
4
votes
2answers
315 views

SSRS: how to handle unavailability of service when datawarehouse is being rebuilt

We use SSIS to build datawarehouse (full Microsoft environment). This is legacy SSIS package that starts by truncating all tables in datawarehouse, run nightly. During this time, we restrict access ...
4
votes
1answer
1k 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 ...
6
votes
2answers
2k 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
2k 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.
50
votes
4answers
15k 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 ...
12
votes
3answers
8k 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? Set up script This script creates one each of table, procedure and user defined table type (restricted SQL ...
5
votes
3answers
8k 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
9k 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: http://www.microsoft.com/sqlserver/en/us/future-...
21
votes
1answer
2k 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
3k 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
4k 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 Files\...
4
votes
2answers
4k 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
253 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
1k 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
1k 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 ...
5
votes
2answers
14k 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 ...
36
votes
2answers
4k views

Why are Denali sequences supposed to perform better than identity columns?

In his answer to Which is better: identity columns or generated unique id values? mrdenny says: When SQL Denali comes out it will support sequences which will be more efficient than identity, but ...
9
votes
2answers
417 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 ...
20
votes
6answers
6k 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 ...

1
86 87 88 89
90