Thank you very much Anthony!

I've discussed the in-place upgrade approach with the developers and application team, and there are too many alarm bells ringing and "maybe's" for this to be...

Thank you very much for your reply!

Well, you confirm what I thought myself, that this would not be an easy upgrade.

Also ... IF we would go down this slippery and...

Seems like our future configuration (which we haven't set up yet) will work just fine, if we used RO secondary replica with the primary configured for Read/write.

Thank you very much...

OldFashionGang (12/2/2013)

---

You have chosen a strange title for the article. It`s starts with "High-Performance..." but there is no performance comparison between Windowed Functions and other approaches. The article itself is...

This article is a complete ripoff from Itzik Ben-Gan's book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions! Nowhere is there any credits to the original author ... Shame,...

They seem to be stored in the data files directory on the secondary server, e.g "E:\SQLDATAFILES\MSSQL10.INSTANCE1\MSSQL\DATA", where the .mdf files are placed.

That's not the same drive as where we keep...

Ah .. I get your point, and totally agree with what you're saying!

In this case, there will be no more Names or Sizes in the that table. All values will...

Thank you very much for your answers, guys!

@cadavre: What do you mean when you say "key that allows to see the start and end.."?

The table with the odd...

Sounds reasonable. Thank you everyone for your answers!

Sincerely,

Gord

OK, thanks again!

Yeah, I got the correct percentage before the last post, but thought that there might be another way than dividing the two aggregations.

The warning is something I can...

Thank you so much, Howard, it worked great!

I also want to get the percentage, which is done with this formula: DiffBckSize/FullBckSize * 100.0

When doing this a NULL is returned in...

Thank you very much for your answers!

Jeffrey: That sounds logical, I agree. But what about the part "The log scan number (82666:12760:1) passed to log scan in database.." in the...

Worked like a charm! 🙂

Thank you very much Jason, for your fast reply and nice solution of my problem!

Btw, now I definitely know the importance of posting the whole code...

Thank you for your answers!

Jason: Tried substituting the function with at.Database_Name, but unfortunately it didn't help... Good point though to use an already existing value, instead of the overhead of...

Thank you for your answer Jeremy!

That makes it a bit clearer...

I'll do as you suggest, and run DBCC IND with different combinations of page, data and index allocations.

Take care.