Steve Jones - SSC Editor (2/11/2016)

---

Ian_McCann (2/11/2016)

---

krypto69 (2/11/2016)

---

did you try changing the compatibility level to check for cardinality issues?

We have had many and some times the quick way to tell...

Ken McKelvey (2/11/2016)

---

You may find the Word document referenced here to be useful:

https://msdn.microsoft.com/en-us/library/dn673537.aspx

Please note, I have played with this a bit but not used it in anger as...

krypto69 (2/11/2016)

---

did you try changing the compatibility level to check for cardinality issues?

We have had many and some times the quick way to tell for sure is to switch it,...

Hallo Gail.

Unfortunitly I can't post them.

But in comparing them I see that the 2008R2 Actuel plan is using a loop join and 2014 a Hash Match.

I've used a hint to...

Thanks, but alas I'm still missing the CDC tables in the script.

Here is an example database , with one table and a view that looks at the CDC table.

USE [master]

GO

CREATE...

I have found this article

SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 stops responding and a "Non-yielding Scheduler" error is logged

https://support.microsoft.com/en-us/kb/2699013

and I am going to stop...

Sorry, I miss read your comment.

Since the restart I only have logins and back ups in the event log plus the dbcc checkdb that I ran and the cycle error...

DBCC CheckDB showed no errors.

I roll the event logs over every two days and keep 7 logs (so 14 days worth of events) and other than some failed login attempts...

Thank you Gail.

It is actually the first stack dump we have had on this hardware, which is two years old.

Hence my lack of experience dealing with it 🙂

Here is the...

Thank you Gail.

That could be solving another issue I have.

When MyTable was used in the restored database the log_reuse_wait_desc always showed 'Replication' and cdc had to be set up to...

Problem Solved 🙂

When MyDB is restored from its own backup the CDC tables are there.

When the MyDB backup is used to restore a test database the CDC tables are not...

All on the one server

create database MyDB

create table MyTable (ColID int primary key, Col1 int)

USE MyDB

GO

EXEC sys.sp_cdc_enable_db

GO

EXEC sys.sp_cdc_enable_table

@source_schema = N'dbo',

@source_name = N'MyTable',

@role_name =...

Thank you Gail

there is just one file in MyDB.BAK.

I've just noticed I'm moving between a productive 2008R2 database and a 2014 Test database and I am trying to recreate this...

kind of 😉

openning the script in notepad++ and saving it as utf8 encoded and then reading it back with -Encoded UFT8 did work,

( there is always a but)

but

It took away...

Hmmmm

I've fixed the script by reading the contents of the tsql file and then invoking sqlcmd -Query instead of invoke sqlcmd -inputfile

clear-host

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.VisualBasic') | Out-Null

$filepath = [Microsoft.VisualBasic.Interaction]::InputBox("Enter a Path name", "Release...