Tag Info

New answers tagged

0

If you have access to the database, Echo (instead of run) your variable with SQL command and then put that command into SQL server and see what error you have there. $tsql2 = "INSERT INTO pedidos (numero_local, emailUser,codigopapel,cantidad, color) VALUES ('$local', '$emailOn', '$codigopapel', '$cantidad', '$selectcolor')"; /* $stmt2 = ...


0

As in http://stackoverflow.com/questions/17148144/insert-into-sqlsrv-query-statement-not-working .. you might try die('Errors: ' . print_r(sqlsrv_errors(), TRUE); .. or something like that. (I don't know PHP.) Also, use placeholders (?) for values, then pass your parameters. If you just interpolate strings into your SQL literally, you may be vulnerable to ...


1

This does not make sense: INSERT INTO pedidos VALUES((SELECT numerolocal FROM localidad WHERE numerolocal = $local)) You haven't specified a column list, so this should fail with a syntax error (since your table clearly has more than one column). Formats for INSERT are typically: INSERT dbo.table(col1, col2) SELECT col1, col2 FROM dbo.othertable; Or: ...


0

I conducted a series of performance tests against the new service tiers (as mentioned by another poster above). I tested I/O rates back in July and have now also tested the memory (i.e. max buffer pool size) in each tier: http://cbailiss.wordpress.com/2014/11/11/azure-sql-database-memory-limits-by-service-tier/ (I was going to add this as a comment on ...


1

Two more additional filters are necessary for your first query. 1- You need to execute query for user databases only i.e. resource_database_id > 4 and 2- Session status "sleeping" mean, session is currently running no request, so exclude such sessions from your result. i.e. [sessions].status <>'Sleeping' select sessions.session_id,* from ...


0

Old question I know, but if anyone is still looking for one potential workaround... I wrote a small utility (shared on my blog) that makes life easier when working with this DMV. This utility takes a baseline of the query stats to act as an effective zero. The utility then queries the DMV repeatedly and works out the changes to show what has executed over ...


2

I am the author of the blog post mentioned above by Andrew. The new service tiers scale (ie. limit) I/O, CPU and memory by tier. Higher levels/tiers provide more resources. There are no documented limits by resource type (only vague DTUs), though my tests provide some indicative I/O numbers. UPDATE: I have now tested the memory limits by Service Tier, ...



Top 50 recent answers are included