Tagged Questions

3
votes
1answer
44 views

Convert SQL Server 2012 SSIS package to 2008

I've created a few SSIS packages in SQL Server 2012 that I need to run on SQL Server 2008. I've been told that it is impossible in their current state. Is there a way to convert the 2012 packages to ...
1
vote
2answers
52 views

SQL Server Memory Clerk Description

Trying to understand different memory clerks reported by sys.dm_os_memory_clerk however, not able to find description of the each individual memory clerk either on web (google and binged) or in SQL ...
0
votes
1answer
17 views

Is there a system primary key associated with each row?

Does a system primary key or unique identifier for each row in a table exist? Like @@ROWID, @@IDENTIFER, or some other identifier that uniquely identifies each row regardless of how it was created? ...
1
vote
1answer
83 views

Total Memory used by SQL Server (64 bit)

My knowledge on the subject suggests that perf counter SQL Server:Memory Manager: Total Server Memory only gives you buffer pool memory. There is a column called physical_memory_in_use in a DMV named ...
1
vote
1answer
60 views

Restoring SQL Server 2012 database onto 2008

I am trying to restore a SQL Server 2012 database after I set the compatibility level to SQL Server 2008 by following the instructions as listed on: ...
1
vote
2answers
78 views

Will SSIS 2012 work with SQL Server 2008R2 (not integrated)

Our company has SQL Server 2008R2 and plans to upgrade to 2012 in late 2013 or early 2014. I would like to use SSIS 2012 now as we do have the software. We have a company policy where we cannot run ...
4
votes
1answer
71 views

SQL Server 2012 indirect checkpoint

I am trying to understand where to draw a fine line for Indirect Checkpoint that was introduced in SQL Server 2012. Based on my understanding SQL Server does checkpoint to flush dirty pages out to ...
4
votes
1answer
38 views

Can I query data_space names when not in context of the database for multiple databases?

I have a data set pulled from sys.master_files. The data set looks something like this: database_id filename physical_name data_space_id ----------- ---------------- ------------- ...
2
votes
1answer
119 views

Inside SQLOS – Scheduling

Using SQL Server 2012 Enterprise Edition SP1 running on Windows Server 2008 R2 SP1 For each logical processor core on SQLOS has a scheduler assigned to it. Those scheduler can be viewed as status ...
2
votes
1answer
501 views

Active/active SQL Server Clustering in Installation Center (setup.exe)

I like to know which option to choose in the setup.exe in SQL Server 2012/2008? What I have here is Windows Active/Active Cluster setup with one quorum and one msdtc configured. I installed my first ...
2
votes
1answer
125 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 ...
2
votes
1answer
101 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 ...
3
votes
2answers
285 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
181 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?
0
votes
2answers
74 views

Getting notification when log truncation is delayed

Is there any way to notify DBA proactively when transaction log truncation has been queued multiple times however for some reason (it could be an open transaction, replication, currently running full ...
3
votes
1answer
188 views

SQL Server Dynamic Memory management

I am reading a book on SQL 2008 internals and troubleshooting by Christian Bolton, Brent Ozar and a old book written by late Ken Henderson and I am getting confused and curious about SQL server's ...
3
votes
2answers
126 views

Does the Query cost in Sql Server account for buffering?

If I am comparing 2 queries by checking their relative "Query cost" as a high level indicator of performance, does the buffer status have any effect on the values shown in the execution plan?
3
votes
1answer
382 views

transactional replication, failing with communication link failure half way through bcp

I am trying to replicate to a 4th subscriber on a remote site. 3 subscribers work fine locally. the other difference is this is a 2012 subscriber from a 2008 r2 publisher and remote distributor. When ...
0
votes
1answer
85 views

seeking a confirmation — SQL Server backup performance [duplicate]

Possible Duplicate: Is SQL Server Backup single or multi-threaded? Does SQL Server uses a separate writer thread for each backup device (backup file) or separate thread is used only when ...
2
votes
1answer
81 views

Execute job every time database changes - execute job on each change-event

I have a transactional-replication running in my database, and I need to execute a service on my website that refreshes the cache every time the database changes. So i guess i have two options to ...
4
votes
2answers
320 views

SQL Server Concise List Of Trace Flags

I did my 5 minute research and have not come up with a concise list, or even a list really except for Trace Flags (2012) which is a bit lacking. Looking at this query which uses 8691, I was wondering ...
2
votes
1answer
35 views

In real terms, how much effect does a bad fillfactor have on performance?

There's a storm brewing, or maybe I should say firestorm. A customer has recently implemented SQL Server 2012 Always On but that's not the most important bit. A list of fires to be put out has been ...
1
vote
1answer
147 views

Enable Lock Pages in Memory for SQL Server on VM

We have several SQL 2005 instances that are in a process of being virtulizaed and upgraded to SQL 2008 R2 running VMWare vSphere 5.1. Our VMWare admin told me that in our org they do not over ...
6
votes
2answers
399 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 ...
-3
votes
2answers
894 views

Comparison Chart for SQL Server 2008R2 and SQL Server 2012 [closed]

I was wondering is anyone has a feature comparison chart for SQL Server 2008 R2 and SQL Server 2012?
7
votes
1answer
407 views

Direct the OUTPUT of an UPDATE statement to a local variable

I would like to do this : DECLARE @Id INT; UPDATE Logins SET SomeField = 'some value' OUTPUT @Id = Id WHERE EmailAddress = @EmailAddress -- this is a parameter of the sproc Is this even ...
0
votes
1answer
271 views

Fast Recovery in SQL Enterprise Edition

Starting with SQL Server 2005 and all later versions, Enterprise Edition includes a feature called "Fast Recovery". a) Does fast recovery use multiple OS threads to perform "REDO" operation? b) Does ...
2
votes
2answers
440 views

How to detect compatibility errors - SQL Server 2012

I am changing a database's compatibility mode from 90 (SQL Server 2005) to 110 (SQL 2012) and I am wondering at what point would I see errors from breaking changes if there are any. I ran Upgrade ...
5
votes
1answer
357 views

SQL Server 2012 Resource Governor Enhancement

In SQL Server 2012 what specific enhacement was made regarding controlling memory usage by using Resource Governor. Up until SQL Server 2008 R2 resource governor was only able to control memory ...
1
vote
2answers
166 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
2answers
85 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 ...
1
vote
1answer
84 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 ...
5
votes
2answers
551 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 ...
26
votes
4answers
8k 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 ...
6
votes
2answers
738 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 ...
3
votes
2answers
1k 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 ...
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 ...