Dana, your avatar is evil, pure and simple. I can't tell you how many times I've stopped my hand from swatting away the insect on my screen. Damn...

Easy point: continuing to run SQL Server 2005 boxes hath its rewards, finally!! 🙂

Here's a small, stupid, recent example where I needed RDP access: Making a registry change so that OPENROWSET() calls can read in pipe-delimited files (instead of comma-delimited) for a large...

Finally - continued use of an older SQL release earns me easy points on QotD!

Rich

I'm beginning to think that we need some kind of "posting shorthand" for replying to QotD.

My first suggestion: we need a term that means "I thought this looked...

Thanks Dwain.c.

No, I don't see the behavior being at odds with BOL either, but I do see it being at odds with computational integrity and statistics. And BOL has...

Old thread, but in case someone finds this still relevant, I did finally discover the problem and solution.

If you Google memtoleave you will find the answer: SQL 2005 sets aside...

This thread is almost 4 years old -- you might want to start a new one.

Rich

Steve, you need to read the chapter in Don Mitchell's Moving Upcountry: A Yankee Way of Knowledge. (Old farts, yes that is a pun on Don Juan). It's...

Regarding the "how big should my log file be permanently set to after I back up and shrink it?" question:

I came across a very nice script that will tell you...

Hugo Kornelis (2/11/2013)

I'm surprised you didn't know this. Integer is actually the official name; int is an accepted abbreviation.

*cough* I have to retract the above. That's what I always thought,...

Good question, had to think a bit.

Stupid me, scratching my head: what is that extra "databasename#" argument doing there?

I always use the (unnecessary) "As" when aliasing columns,...

Glad you got it working. If you figure out what data was breaking your query, post back and let us know!

Rich

Once I changed your table definition for the Grade column from VARCHAR to NUMERIC(10,2), this works for me:

WITH cte AS

(

SELECT CourseDate, PersonID, Grade,

ROW_NUMBER() OVER(PARTITION...

Can you SELECT from the MySQL tables using the MS SQL Linked Server?

There's an old, long thread here at SSC http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx that has some recently added information.

In particular, I was...