Declare @holdname sysname

Declare getdbname cursor for
Select name 
from master.sys.databases 
order by name

Open getdbname

fetch next 
from getdbname
into @holdname

while @@fetch_status=0
BEGIN

    select 
    ...

Jeff Moden:-

Yes, that was my exact test.

I have attached a test sql code.

Jeff, thanks for being a real one.

Sacrificing your soul to make sure that everyone gets a lot more.

Amen,

Daniel

Manny:-

I do not think example 2 actually works.

Here is your SQL Statement for Example 2:-

Declare @holdname sysname
Declare getdbname cursor for
Select name from master.sys.databases order by name
Open getdbname
fetch...

• This reply was modified 2 years ago by  Daniel Adeniji-180202.

Boss Man:-

Typo here:-

The documentation notes this is a strig function that takes two parameters, but not as most other functions.

Should read:-

The documentation notes this is a string function that takes...

Phil:-

It seems your thoughts here are not fully written-out:-

"Only bother with a re-connection strategy if you really need to the data. If it's just logging, then consider throwing it away...

Guido :-

You cannot really resolve the issue.

Are you using encryption.

If you are using encryption the varbintohexsubstring function is used by DecryptByKey and other decryption routines.

Daniel Adeniji

Roust_m:

Worked for me, as well.

Can't believe this is still an issue with MS SQL Server v2017.

Great Thanks for sharing.

Daniel Adeniji

Works for me, as well.

Source sql server 2005, Destination 2017.

Set Compatibility Level to 2008 using

ALTER DATABASE [LAB] SET COMPATIBILITY_LEVEL = 100
GO

Chris:

I have battled with the same question for a while here. You did not give the exact offset that you are getting, nor the SAN Vendor.

If NetApp, I will...

Mohit:

I need a bit of help to identify our current settings ratio of read to write Cache.

It seems that you eluded to knowing how in your posting:

Many things can cause...

It is quite possibly that the problem that I am having are related to "File System Filter Drivers":

A tale of CHECKDB failures cause by 3rd party file-system drivers

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/12/10/a-tale-of-checkdb-failures-cause-by-3rd-party-file-system-drivers.aspx

Two...