Back in the day, when learning about databases, a rule-of-thumb I was taught was that if you have a column that contains 'numeric' data then only set it's data type...

The problem I always faced when testing my own code, particularly when I was a software developer, was that I tended to not test things the way users would test...

I think only one person noted that this was a very useful article as it included creating and referencing an external DLL. I'm sure sure some of the other solutions...

In the past 15 years I've gone from a similar situation - large company with a small IT dept all in the same room with me filling both the development...

Thanks Willem. Changed line 64 to $SqlHost = "(local)\<myserver>" and that worked. Getting a problem connecting via sqlcmd now but that's a a problem for me to solve 🙂

Gordon.

Hi, I'm getting an 'unexpected token' error when trying to specify a named instance of SQL Server on line 64.

Gordon.

A rule of thumb, David, is that the query optimiser will go for the smallest structure available so it can read more of it into memory- i.e. you can read...

I have to say I thought all the queries would use the non-clustered scan as it was just as quick to do a scan than a seek.

Pace Douglas Adams, the answer probably ought to have been 42.

I'm agreement with others that the question ought to have been 'recommended minimum memory', hence my incorrect answer of 'none of the above'.

SSChampion's response is a valid one. How big can any or all of your results become? If one or more queries return hundreds, or even thousands of rows, well I...