Hello!

I believe the most important keys to solving this one (as you rightly mentioned) are to understand that:

1. Both the WHERE & HAVING are "binary" conditions, i.e. they would either...

One thing I find that normally interferes with automatic formatting is the use of tabs. Try replacing tabs with spaces by selecting the code block an then going to Edit...

I am trying to find out "why" this behaviour is seen and believe that there is definitely something influencing this (I am just not able to find out what). It's...

The essence of this question is in the following:

SELECT CONVERT(NVARCHAR(2),0) -- returns 0

SELECT CONVERT(INT,N'') ...

Hello!

Here's more food for thought:

I got a 64-bit Intel Xeon dual CPU box (2x2GHz), with 4GB RAM running Windows Server 2008 R2 and SQL Server 2008 R2. The system went...

Hello!

I believe the rating of bugs is very much linked to a previous editorial that ran on SSC about scoping features & bugs for a new release.

Scoping is indeed very...

I agree. This definitely looks like a buffer/memory setting of some sort. I ran this today on a much powerful server and workstation (as compared to my previous attempt) and...

Not a problem at all. I am happy that you are now all set.

Have a wonderful day ahead!

Try this: (I had removed the UNICODE N' in the query earlier, but had missed the '' at the end of the file name, which have been removed now)

DECLARE @SourceDB...

The error was a OutOfMemory exception in the messages pane.

Okay. So, the problem is not in the query. The problem is in returning results back to SSMS.

The following works:

Select a.C + b.C + c.C + d.C AS 'AsciiChars'-- create...

Oops...sorry. Try this: (I removed the UNICODE N' from the start of the path)

DECLARE @SourceDB nvarchar(255)

set @SourceDB = 'D:\FS_Database\Backups\FSDBMR\FSDBMR_backup_' + cast(datepart(year, getdate()) as varchar(4))

+ replace((space(2 - len(cast(datepart(month, getdate()) as varchar...

Is this what you were looking for?

http://www.pinaldave.com/best-sql-server-download.cfm?Download=Logical-Query-Processing-Poster

Hello!

I believe your issue is because you are not adding a valid backup device. The below should do the trick (I myself use it in my development environments).

DECLARE @SourceDB nvarchar(255)

set...

Hello!

Just a thought - I trust you do not have any white spaces in the database name - can you just give it a try (eg. you have [MyDB ]...