I suppose if you had...

Thanks, best post I've seen all week. I love stuff like that. 🙂

Yes, I was forgetting COUNT_BIG.

As for your last comment perhaps a better answer to the question would be "Limited by how much money you have" 😉

I wonder if there are any limits peripheral to this though?

For example, when I look at Table Properties in SSMS and select Storage it tells e how many rows...

It's encouraging that 8 people so far have gone for the Leprechaun answer. It's not all about the points 😉

I wonder if Italians eat Reindeer too? We'd have to get an answer from Venice on that.

A better question would be "What is the maximum number of databases a developer can handle?". I've got 8 open at the moment and in danger of losing track of...

Interestingly there are now 39% incorrect answers but only 31% of people picked the wrong answer. I'm assuming that means that 8% chose less than three answers.

Well, I'm glad I looked at these posts. I knew you could order a view if you did the SELECT TOP (100) PERCENT thing but I hadn't realised that it...

Thanks for the reply. I was using the TRUNCATE purely for speed as the table may contain 10 million records in a few months time. There's also less of an...

Alternatively, you could use ROW_NUMBER to accomplish this:

SELECT VulnID, Host, SCANCOMPLETETIME FROM (

SELECT VulnID, Host, SCANCOMPLETETIME,

ROW_NUMBER() OVER (PARTITION BY Host, VulnID ORDER BY SCANCOMPLETETIME DESC) rw FROM VULNS_VIEW

) q

WHERE...

Me too, sadly I was wrong!

45% incorrect answers would imply that it wasn't an easy question! Well done to those who knew the correct answer or, like me, guessed there would be a catch somewhere.

I thought it would execute from master as well so got this one wrong. Never mind, I'd never create a user proc with the sp prefix anyway 🙂

...or that not everybody here is a DBA.