Test remote database

[Emanuele Colombo]

Does anyone know where I can find a remote database, accessible from the internet, with SQL server installed to use for a test?
No matter what types of data the database contains, I would like to verify the performance of my queries.

Thanks

[Robert Wolfe]

what id recommend is getting a vps to do what you need. you canget a winows vps for $10usd a month from interserver.net.

[Michael Mattias]

No matter what types of data the database contains, I would like to verify the performance of my queries.

If you are trying to analyze if your queries are efficient at the database level, SQL/Server should offer some kind of "Show Plan" ("Plan" is the magic word here) option for queries. This will tell you if your query has somewhere generated code which requires a full table scan, which is exactly what you want to avoid.

But these analyzers (and Oracle offers a terrific one) will not - and cannot - tell you if you have used the correct query for your application.

If you are talking about specifically performance over the internet, just keep your result sets small by FETCHing individual rows rather than trying to return one big result set all at once. Or better still, structure your program to use prepared 'return single row' statements rather than "fresh" queries returning a full table.

[Kurt Kuzba]

A quick search shows that you can set up a free Microsoft Azure account and create your own SQL database there.